pgjumbo: a new free desktop client for PostgreSQL

Posted on 2026-11-18 by pgjumbo
Related Proprietary

pgjumbo is a new desktop client for PostgreSQL 12+, free to use, for Windows, macOS and Linux, with query, data and administration tools.

pgjumbo connects to PostgreSQL 12+, including Amazon Aurora and RDS with IAM authentication, directly, over SSL or through an SSH tunnel. Installers are available for Windows (x64 and ARM64), macOS (Apple silicon and Intel) and Linux (AppImage, .deb and .rpm).

Version 1.0.2 includes:

  • An object explorer and inspector with each object's CREATE script, statistics and dependencies.
  • A Query Tool with completion, syntax errors from PostgreSQL's own parser as you type, parameters, EXPLAIN as a table or a diagram, and results that can be sorted, filtered, compared and exported.
  • A data editor that shows the statements before it saves them.
  • Backup and restore built on pg_dump, pg_dumpall and pg_restore: choosing objects and rows, server backups as a folder of archives, reading an archive's contents before restoring, and restoring into a new database.
  • Maintenance: what each table needs and what holds VACUUM back, VACUUM, ANALYZE and REINDEX as reviewed steps with progress, and autovacuum settings per table.
  • Server activity, configuration, roles and privileges, logs, replication, pg_cron jobs and LISTEN/NOTIFY.

Changes to objects are shown as SQL and reviewed before they run, and on servers marked Production, destructive statements ask for confirmation first.

Download pgjumbo · Release notes for 1.0.2