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 Postgres 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 Postgres server configuration via convenient GUI

Database Backups

Back-up and restore your Postgres cluster in background while working on other stuff

Visualize

Pgmanage Supports Query-plan visualization and Entity-relationships

Dark or Light

Choose a theme to your taste

Latest News

PgManage 1.2 has been released

  • New features:
    • implemented support for adding/changing table indexes in Schema Editor
    • implemented Postgres role editor
    • added SQL error annotations in query editor
    • significant code completion improvements: added context-aware schema, table, view, column and function completions
    • added support for Postgres byte array display query results data grid
  • Lots of fixes and minor improvements, see the full change log on Github Release Page

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