Ecosystem:PostgreSQL only:Database administration/development
From PostgreSQL wiki
dbForge Studio for PostgreSQL
- Provider -- Devart
- Website -- https://www.devart.com/dbforge/postgresql/studio/
- License -- proprietary
- Interoperability level -- supports PostgreSQL 8.1 or higher
- Verified PostgreSQL versions -- https://docs.devart.com/studio-for-postgresql/getting-started/compatibility.html
- Last update (YYYY-MM-DD) -- 2021-07-29
- Description -- dbForge Studio for PostgreSQL is a universal GUI tool for PostgreSQL database development, management, and editing process enjoyable and easy by Devart. The PostgreSQL IDE allows users to create, develop, and execute queries, edit and adjust the code to the requirements in a convenient and UI. The tool provides the PostgreSQL data editor functionality for queries customization and property window for viewing all the required information of PostgreSQL database objects.
Key features:
- Plan Tree of query execution
- Diagram of query execution with the cost of all operations as a percentage of the total batch cost
- List of top operations taking place on the server
- Execution plan in the XML format
- PostgreSQL code completion
- SQL code formatting
- SQL syntax check
- PostgreSQL query validator
3) Data Export and Data Import
- 10+ file format support, including Google Sheets
- Flexible data import and export customization
- Handy wizards for data export and import
- PostgreSQL data migration
- Data Report Wizard
- Report Designer
- Pivot Tables
- Chart Designer
- Retrieve data from the database on a single SQL document
- Truncate a table
- Select Properties to view information on the object
- Generate Script AS
6) Data Editor
- In-place data editing
- Look-up data editing
- Cached Updates Mode data editing
- Table, Text, Card Views
- Design View for setting up relations between tables
- Data View for handy display of results
- Smart sorting and filtering
- Additional info -- click here
EDB Postgres Enterprise Manager
- Provider -- EnterpriseDB Corporation
- Website -- https://www.enterprisedb.com/products/edb-postgres-platform/edb-postgres-enterprise-managerpem
- License -- proprietary
- Interoperability level -- explicitly supports PostgreSQL 9.1 or higher
- Verified PostgreSQL versions -- See: https://www.enterprisedb.com/services/edb-supported-products-and-platforms#PEM
- Last update (YYYY-MM-DD) -- 2017-6-7
- Description -- EDB Postgres Enterprise Manager is designed for monitoring, managing and tuning large scale installations of local and remote Postgres deployments. DBA features include: customizable monitoring dashboards with drill down tables/charts, over 225 pre-defined monitoring probes, custom probes, server auto-discovery, At-A-Glance global status and performance dashboards, Capacity Manager, Audit Manager, Log Manager, Log Analyzer Expert, Postgres Expert (best practice configuration engine), SQL Profiler, Index Advisor, Tuning Wizard, Team Management, flexible SMTP/SNMP alerts, and job scheduler. Developer features include: visual SQL debugger to step through server side stored procedures and triggers, drag and drop SQL query editor, data grids for instant editing, Graphical Query Editor, syntax highlighting, indentation, auto completion, macros and a graphical explain plan.
- Additional info -- click here
repmgr
- Provider -- 2ndQuadrant
- Website -- https://www.2ndquadrant.com/
- License -- GPL v3
- Interoperability level -- explicitly supports PostgreSQL 9.3 or higher
- Verified PostgreSQL versions -- https://www.2ndquadrant.com/en/resources/repmgr/
- Last update (YYYY-MM-DD) -- 2020-04-13
- Description -- repmgr is a popular tool for PostgreSQL replication and failover management. It simplifies administration and daily management, enhances productivity, and complements the built-in replication capabilities in PostgreSQL.
- Additional info -- click here
pgMustard
- Provider -- pgMustard
- Website -- https://www.pgmustard.com/
- License -- proprietary
- Interoperability level -- explicitly supports PostgreSQL 9.6 or higher
- Verified PostgreSQL versions -- https://www.pgmustard.com/docs/
- Last update (YYYY-MM-DD) -- 2021-02-22
- Description -- pgMustard is a quick way to review EXPLAIN ANALYZE output, and it also provides tips to improve performance.