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 at once

  • SQL Autocompletion: PgManage suggests completion options as you type. Schema, table, view, function and column completion are supported.

  • Secure Credential Storage: sensitive information such as DB passwords, SSH keys etc. is stored in an encrypted form and protected by Master Password.

  • Postgres Config Management: easily search and tweak your Postgres server configuration parameter using a convenient GUI.

  • Database Backups: back-up and restore your Postgres cluster or database in background while working on other stuff.

  • Visualize: PgManage Supports query plan visualization and entity relationship diagrams.

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

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

  • Built-in SSH terminal.

Supported Databases

  • PostgreSQL

  • SQLite

  • MySQL

  • MariaDB

  • Oracle

Supported Platforms

  • Linux

  • Windows 10 and higher

  • Mac OSX

Note: PgManage currently only supports x86_64 architecture. ARM64 support may be added in the future.

Credits

  • We proudly leverage all of the great work done by the original (now dormant) project OmniDB

  • Postgres query plan visualization is powered by Dalibo Postgres Explain Visualizer 2

  • Though now dormant, the OmniDB project provided important underlying work for the expansions done on PgManage. OmniDB was a lightweight, browser-based application that supported PostgreSQL, Oracle, MySQL, and SQLite. PgManage continues OmniDB’s legacy by providing a simple, unified interface to manage DBMS.