Ecosystem:dbForge Studio for PostgreSQL

From PostgreSQL wiki
Jump to navigationJump to search

dbForge Studio for PostgreSQL is an AI-powered all-in-one integrated environment that facilitates routine development and management of PostgreSQL databases. It is equipped with a selection of tools that help users write, run, and optimize queries, debug functions and procedures, design queries and database objects visually, import, export, and edit data, compare and synchronize PostgreSQL schemas and table data, generate realistic dummy data for testing, and build pivot tables and data reports for subsequent data analysis. dbForge Studio for PostgreSQL is perfectly suitable for beginners and seasoned database developers alike.

SQL Development

Improve the speed of your coding and the quality of your queries with the following features:

  • SQL editor
  • Code autocompletion
  • Code formatting
  • Code snippets
  • Syntax check

Integrated AI Assistant

Generate, explain, and fix SQL queries with the integrated dbForge AI Assistant:

  • Context-aware SQL generation
  • Natural language to SQL conversion
  • Query optimization
  • SQL explanations
  • SQL troubleshooting
  • Error analysis
  • Free plan available

Visual Database Design

Design queries and database objects visually without writing SQL code:

  • Query Builder
  • Database Editor
  • Schema Editor
  • Table Editor
  • Visual editors for functions, procedures, and event triggers

Debugging

Debug functions, procedures, trigger functions, and event trigger functions with the PostgreSQL Debugger:

  • Breakpoints
  • Step-by-step execution
  • Call stack
  • Variable values

Database Explorer

Explore the object tree, find the items you're looking for in the fastest way⁠—and perform the following operations from the context menu:

  • Get quick object information via Properties
  • Script out your objects via Generate Script As
  • Import and export data
  • Truncate a table

Query Profiling

Find bottlenecks in slow SQL queries and optimize them using the built-in Query Profiler. The profiling findings are organized logically across multiple tabs, with each tab delivering the following profiling information:

  • Plan Tree
  • Query execution diagram with the cost of all operations as a percentage of the total batch cost
  • List of top operations on the server
  • Query execution plan in XML

Database Comparison & Synchronization

Compare source and target databases to examine and deploy changes in database structures and table data:

  • Find and analyze differences in database objects
  • Detect and explore differences in table data
  • Generate scripts to synchronize differences between source and target databases
  • CLI-powered comparison and synchronization
  • Automatic and manual schema and table mapping

Data Export and Data Import

Populate your PostgreSQL databases with data from external sources and migrate data between your systems with a handful of versatile options.

  • Support for 10+ most widely used file formats for both import and export
  • Intuitive wizards that help you get things done faster
  • Customizable options
  • Templates for recurring operations

Test Data Generation

The built-in Data Generator is at your service to help you create any volumes of realistic dummy data for testing purposes—and populate your databases with said data in a matter of moments.

Data Reports and Analysis

Finally, dbForge Studio for PostgreSQL offers multiple features for aggregating and managing your data, as well as provides compelling visual reports to help you analyze your data with convenience.

  • Data Report Wizard
  • Report Designer
  • Pivot Tables
  • Chart Designer
  • Data Editor
  • Master-Detail Browse

Compatibility

  • Microsoft Windows 7/8/8.1/10/11
  • Linux: Ubuntu/Debian/Fedora/Red Hat Enterprise Linux (available via CodeWeavers CrossOver)
  • macOS 10.13 or later (available via CodeWeavers CrossOver)

Additionally, dbForge Studio is compatible with multiple databases and cloud services, including Supabase, Heroku, Neon Tech, IBM Cloud, Alibaba Cloud, Amazon Redshift, Amazon RDS, Amazon Aurora, Azure PostgreSQL, Greenplum DB, DigitalOcean Managed Database, YugabyteDB, AWS Babelfish, CitusData, ApsaraDB, PolarDB, AnalyticDB, bit.io, Google Cloud, AlloyDB, and Azure Cosmos DB.

History

Version 1.0.410 was released on June 5, 2018.

Version 2.0 with a brand new Standard Edition was released on December 10, 2018.

Version 2.1 with a new query optimization feature and Greenplum DB connectivity was released on May 6, 2019.

Version 2.2 with SQL Code Formatter, Generate Script As, Cached Updates Mode in Data Editor, and a bunch of other notable improvements was released on October 1, 2019.

Version 2.3 contains the improved Script Generator, SQL Formatter, and Query Profiler. It was released on August, 12, 2020.

Version 3.0 with a new Professional Edition that included Data Compare, Schema Compare, Data Generator, and support for Linux and macOS via CodeWeavers CrossOver was released on January 30, 2023.

Version 3.1 with new compatibility options, including support for Aiven Data Cloud, EDB BigAnimal, SHA-256/512, and Transport Layer Security. It was released on May 24, 2023.

Version 3.2 with a new compatibility options, including support for PostgreSQL 17, integration with cloud platforms like Supabase, Google Cloud, AlloyDB, and Azure Cosmos DB, and support for a new SSL/TLS certificate for connecting to PostgreSQL on AWS. It was released on December 3, 2024.

Version 2025.1 with dbForge AI Assistant integration, support for PostgreSQL 18, and a refined UI/UX was released on June 16, 2025.

Version 2025.2 with AI Assistant web search, streaming responses, error analysis in AI Chat, alias refactoring, and strengthened encryption was released on September 23, 2025.

Version 2025.3 with scroll bar annotations, camelCase identifier formatting, and smarter code completion in routines was released on December 24, 2025.

Version 2026.1 with Query Builder, Database Editor, Schema Editor, Table Editor, and schema and table mapping in Schema Compare was released on May 11, 2026.

The latest version 2026.2 adds the Debugger, visual editors for functions, procedures, and event triggers, support for PostgreSQL 19, file attachments and model selection in AI Assistant, and product activation via sign-in. It was released on September 22, 2026.


For a list of changes see the revision history.

Learn more

dbForge Studio for PostgreSQL is available in a free Express edition, and its full functionality can be evaluated with a free trial.

Detailed information about the dbForge Studio for PostgreSQL functionality is provided on the official page.

Retrieved from "https://wiki.postgresql.org/index.php?title=Ecosystem:dbForge_Studio_for_PostgreSQL&oldid=44775"