Postgres and Open Source Experts

24x7x365 since 1997

PgManage

Previous Next

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.1.1.AppImage

Windows

pgmanage-1.1.1_setup.win64.exe

MacOS X

pgmanage-1.1.1_mac_x64.dmg

Latest News

PgManage 1.1.1 has been released

  • New features:
    • added IPv6 support for database connections
    • allow using UNIX domain socket paths in connection form -> server field (#438)
    • allow empty server values in the connection form for Postgres connections
    • password prompt will now be shown when user tries to establish database connection with wrong password
    • queries in console query history modal can now be copied to query tab with a double-click
    • console history buffer is now cleared from memory when "clear console" button is clicked

  • Bugs fixed:
    • fixed unrestricted code execution vulnerability in monitoring widget back-end. The issue was reported by Andrew Effenhauser, Ayman Hammad and Daniel Crowley of X-Force Red
    • fixed Entity Relationship not rendering diagram for some database layouts
    • fixes issue when expanded DB object tree node was not always scrolled to the top of viewport
    • fixed missing GRANT statements when roles is displayed in DDL tab
    • fixed a bug when application tabs may become unresponsive some cases
    • various minor layout fixes and tweaks

  • Lots of fixes and minor improvements, see the full changelog on Github Release Page

Community

Discovered a bug? Have a feature request? Want to contribute?

Feel free to create an issue or a Pull Requset on GitHub

The latest version of PgManage documentation is available on ReadTheDocs

Get Postgres Help