Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

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

PgManage Enterprise Edition

Features Community Enterprise
Remote Access via web browser ✖️ ✔️
Multi User Support ✖️ ✔️
Oauth2 Support ✖️ ✔️

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