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

Downloads

Linux AppImage

pgmanage-1.2.1.AppImage

Windows

pgmanage-1.2.1_setup.win64.exe

MacOS X

pgmanage-1.2.1_mac_x64.dmg

Latest News

PgManage 1.2.1 has been released

  • Bugs fixed:
    • fixed error notification link colors, added minor layout tweaks
    • fixed DB object tree node data refresh in some edge-cases
    • fixed erroneous "Discard Changes" warning when closing Query tab
    • fixed connectivity issues in built-in SSH terminal
    • fixed bug with multiple tabs highlighted as "active" #570
    • fixed app crash when schema editor is opened immediately after DB workspace is loaded
    • fixed bug with DROP database unable to complete in some cases #582
    • fixed bug with DB object tree context menu disappearing when monitoring dashboard refreshes #607
    • fixed race condition in Backup/Restore job status modal when running multiple jobs simultaneusly
    • fixed bug that allowed to register duplicate hotkey actions #611
    • fixed bug that caused old SQLite3 DB file being used when connection properties updated with a new file #598
    • fixed SQLite3 tables not ordered by name in DB object tree # #596

  • Other changes:
    • bumped happy-dom version to fix potential security vulnerability in dev environment
    • silenced SASS deprecation warnings during js bundle build
    • plus icons are now used for all context menus associated with "create" action #557
    • improved readability of multiple modal windows shown on-top of each other
    • improved SQLite3 DB connection "Test"
    • improved database metadata loading and autocomplete engine initialization
  • Lots of fixes and minor improvements, see the full change log on Github Release Page
  • In the near future we will be placing the Windows and Apple binaries in their stores respectively.

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

Get Postgres Help