A brand new, completely free PostgreSQL desktop client shipped yesterday on postgresql.org. It’s called pgjumbo, runs on Windows, macOS, and Linux, and its central bet is that your database GUI should show you what it’s about to do before it does it. Every DML statement is previewed before execution, destructive queries can be rehearsed inside a transaction without committing anything, and automatic savepoints prevent one failed statement from torching the entire session. That’s a meaningfully different philosophy from every other PostgreSQL client currently on the market.
The Rehearsal System
The headline feature is what pgjumbo calls rehearsal. When you put your cursor in an UPDATE or DELETE statement, the client counts how many rows it will touch, names any triggers and cascades that would fire, and surfaces a Rehearse button. Clicking it runs the query inside a real transaction — but does not commit. You see every row that changed, old value beside new value, before you decide whether to actually save anything. It’s a preview mode for destructive queries, and it’s the right answer to a problem that has quietly cost developers hours of data recovery work.
The data editor works the same way: changes appear as SQL statements you review before they run. On servers you’ve marked as Production, any destructive statement requires explicit confirmation. Automatic savepoints handle the safety net at the transaction level — each individual statement gets its own savepoint, so if one fails, only that statement rolls back. The rest of your transaction survives intact. These are not groundbreaking database concepts, but no major free PostgreSQL client wraps them this cleanly into the UI.
Query Tool: EXPLAIN as a Diagram, Errors from the Real Parser
The query tool has two features worth calling out. First, pgjumbo renders EXPLAIN output as a visual diagram — not raw text, not an indented tree, an actual node graph showing cost, row estimates, and join types at a glance. You can also view EXPLAIN as a table if you prefer columns. Second, inline syntax errors come from PostgreSQL’s own parser, not a third-party linter. That means the error you see while typing is exactly the error PostgreSQL would throw — no false positives, no guesses. Parameter binding is built in for safe parameterized queries.
Connections: IAM, SSH, SSL
pgjumbo connects to PostgreSQL 12 and up, including Amazon RDS and Aurora with IAM authentication out of the box. SSH tunnel support covers password auth, key auth, and your existing SSH agent. SSL connections work alongside all of the above. This covers the full spectrum from a local dev instance to a locked-down production RDS cluster without requiring workarounds or separate tooling.
Free, and Actually Free
The pricing landscape for PostgreSQL clients is awkward. pgAdmin is free but runs as a web server, has a notoriously complex UI, and shows nothing before it executes your queries. TablePlus is polished and fast but costs $99 or more. DBeaver’s community edition is free but it’s a multi-database tool built to cover 80 databases rather than one. pgjumbo is entirely free — no subscription, no “pro” tier, no telemetry, no crash reporting. It downloads as a native application for Windows (x64 and ARM64), macOS (Apple Silicon and Intel), and Linux (AppImage, .deb, .rpm).
pgSherpa: The macOS Monitoring Companion
Released the same day: pgSherpa, a free PostgreSQL monitoring companion for macOS available on the Mac App Store. pgSherpa sits in a corner of your screen and polls your PostgreSQL servers for health metrics — lock-wait chains, replication lag, idle-in-transaction sessions, transaction ID wraparound, connection limits. The security tab compares your installed PostgreSQL version against the latest minor release and surfaces CVEs fixed since — useful for anyone running a version that’s a few patches behind. Cloud integrations cover DigitalOcean Managed Databases, Supabase, and Amazon RDS and Aurora. The SQL box is read-only by default.
Who Should Try It
If you’re on pgAdmin because it’s free and tolerating the friction, pgjumbo is a direct upgrade worth trying. If you’ve been eyeing TablePlus but not paying for it, pgjumbo fills most of that gap at zero cost. The rehearsal system alone justifies the install if you manage any production PostgreSQL data. Version 1.0.4 is available now at pgjumbo.com.

