Ecosystem:dbForge Studio for PostgreSQL

From PostgreSQL wiki
Jump to navigationJump to search

dbForge Studio for PostgreSQL is an 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, 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. The Studio 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

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

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 Heroku, IBM Cloud, Alibaba Cloud, Amazon Redshift, Amazon RDS, Amazon Aurora, Azure PostgreSQL, ElephantSQL, Greenplum DB, DigitalOcean Managed Database, YugabyteDB, Neon Tech, AWS Babelfish, CitusData, ApsaraDB, PolarDB, AnalyticDB, and bit.io.

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.

The latest version 3.1 adds 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.

For a list of changes see the revision history.

Learn more

The Studio comes with a free 30-day trial; feel free to download it here.

To learn more about dbForge Studio for PostgreSQL, please visit this page.