PgManage
What is PgManage?
PgManage is a modern Open Source SQL editor and database administration tool.
It works on Windows, Linux and MacOS.
Supported Databases
PgManage targets PostgreSQL primarily. It also supports MySQL/MariaDB, SQLite3, and Oracle databases.
Features
Multiple Workspaces
Work with multiple databases at once
SQL Autocompletion
PgManage completes the code as you type
Secure Credential Storage
Your database credentials cannot be read without master password
Postgres Config Management
Search and tweak your PostgreSQL server configuration via convenient GUI
Database Backups
Back up and restore your PostgreSQL cluster in the background while working on other tasks
Visualize
Pgmanage supports query-plan visualization, entity relationship diagrams, and performance metric dashboards for your database
Dark or Light
Choose a theme to your taste
Features | Community | Enterprise |
---|---|---|
Remote Access via web browser | ✖️ | ✔️ |
Multi User Support | ✖️ | ✔️ |
Oauth2 Support | ✖️ | ✔️ |
Downloads

Linux AppImage

Windows

MacOS X
Latest News
PgManage 1.3.1 has been released
- Bugs fixed:
- Fixed error when loading foreign key information in DB Tree in SQLite3 (#682)
- Fixed error when loading index information in DB Tree in MariaDB (#688)
- Fixed incorrect stylesheets for the password strength validation widget
- Fixed erroneous "Discard Changes" warning when switching between connections in the connection manager (#698)
- Fixed the issue with the incorrect where clause generated when using the data editor query filter in Oracle
- Fixed errors when loading DDL for metadata link objects in the DB tree
- Fixed back-end issue with the idle schema editor thread not always getting terminated
- Fixed "autocommit" checkbox not working for Oracle DB connections
- Fixed validation errors when entering octal file permissions in the Server Configuration Tab (#705)
- Fixed error when rolling back Postgres Server Configuration snapshots that have values not applicable to the current server setup
- Fixed errors when restoring Postgres Server Configuration for databases running with non-English locales (#707)
- Fixed query result file export when query results have duplicate column names (#715)
- Fixed query result copy as JSON when query result has duplicate column names (#712)
- Fixed issue with saving custom monitoring widgets without a chart code block defined (#720)
- Other changes:
- Updated RestrictedPython from 7.4 to 8.0
- Updated Django from 4.2.19 to 4.2.23
- Updated oracledb from 2.5.1 to 3.2.0
- Updated cryptography from 41.0.7 to 45.0.5
- Updated nw.js from 0.69.1 to 0.77.0
- Refactored database capability flags code in the back-end
- Removed unnecessary files from binary packages
- Minor layout fixes and improvements
Community
Discovered a bug? Have a feature request? Want to contribute?
Feel free to create an issue or a Pull Request on GitHub
The latest version of PgManage documentation is available on ReadTheDocs