Description

dbForge Studio for PostgreSQL is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to their requirements in a convenient and user-friendly interface.

The tool also provides functionality for PostgreSQL data reporting, data editing, data import and export, building pivot tables and master-detail relations.

SQL Development
Save your time and improve code quality when creating and editing queries with the following features:

List Members
Parameter Info
Quick Info
Complete Word
SQL Code Formatter

Database Explorer
Navigate through the object tree and find any PostgreSQL object you are interested in. Right-click the required object in the Database Explorer window to perform the following tasks:

Retrieve data from the database on a single SQL document
Truncate a table
Select Properties to view information on the object
Generate Script AS

Data Editor
Editing table data becomes a simple task with dbForge Studio for PostgreSQL. You can manage settings of tables, such as adjust column width, set either paginal or auto-search mode by default. Color and format your rows and cells using a rich set of fonts and size. Additionally, the tool provides you with predefined data type formats so that you can select the most suitable for your needs.

Working with data can be more productive with the help of:
In-place data editing
Look-up data editing
Cached Updates Mode data editing
Table, Text, Card Views

2025.1.124 16-Jun-25

AI Assistant is added

Context-aware query generation
Conversion of natural language to SQL
Query optimization
SQL explanations
SQL troubleshooting
Error analysis and recommendations
AI chat
Integration with the dbForge tools

Connectivity

Added support for PostgreSQL 18

Improvements

Updated color palettes for the Light and Dark skins
Refined font rendering and the coloring of syntax errors
Added Brief View to the Start Page to switch between displaying full paths to recent files and a more compact list

User-reported bug fixes

Fixed an issue where materialized view columns were not displayed in the Database Explorer (#178352)
Fixed the loss of quotes when dragging objects from the Database Explorer into a document (#188973)
Improved query error handling to suppress intrusive message boxes during the initial load and incremental suggestion updates (#199677)
Resolved issues with row selection in SQL Editor (#188972, #199112)
Resolved incorrect parsing of geometry types with dimensions that caused the affected columns to not appear in Database Explorer (#177993, #179971, #202332, #201947)

Additional Information