Introduction

PgManage is a modern, open-source, multi-platform graphical database client and administration toolkit.

Features

  • Multiple Workspaces: connect to and work with multiple databases simultaneously.

  • Context-aware SQL code completion: receive intelligent suggestions for tables, views, columns, aliases, and functions as you type.

  • Postgres Server Configuration Management: easily search and fine-tune Postgres server configuration parameters; take and restore configuration snapshots.

  • Database Backups: back up and restore your Postgres cluster or database in the background without interrupting workflow.

  • Advanced Querying: write SQL with context-aware completion and visualize execution plans to gain performance insights.

  • Data Editor: search and edit database records using a familiar spreadsheet-like interface.

  • Schema Editor: design new tables or modify existing ones with ease.

  • Visual Tools: PgManage supports query execution plan visualization and Entity Relationship Diagrams (ERD).

  • Efficient Navigation: locate and jump to database objects instantly using fuzzy search without the need for manual drill-down.

  • Dark or Light: choose a theme to your taste.

  • Monitoring Dashboard: track database performance with built-in real-time graphs or create your own.

  • Connection Tunneling: connect to your database servers through SSH tunnels.

  • Built-in SSH Terminal.

  • Secure Credential Storage: sensitive data, including passwords, SSH keys, etc. is stored in an encrypted form and protected by a Master Password.

Supported Databases

  • PostgreSQL

  • MySQL

  • MariaDB

  • SQLite

  • Oracle

  • Microsoft SQL Server

Supported Platforms

  • Linux

  • Windows 10 and higher

  • macOS

  • Web *

Note: PgManage currently only supports x86_64 architecture; ARM64 support may be added in the future.
*Web access is supported by PgManage Enterprise only.

Credits

PgManage is being developed by CommandPrompt Inc.
We proudly leverage all of the great work done by the original (now dormant) project OmniDB.
Postgres query plan visualization is powered by Pev2.
SQL query generation is powered by Knex.js.
SQL code completion is powered by ANTLR.
Data tables are handled by the awesome Tabulator.js library.