pgjumbo is a free Postgres client that shows what a write will do first
A new desktop client for PostgreSQL previews rows, locks and cascades before a statement runs, and can rehearse changes in an uncommitted transaction.
PostgreSQL.org announced pgjumbo this week: a new, free desktop client for Postgres 12 and later, built by Benjamin Ibrulj, for Windows, macOS and Linux. It is now listed on postgresql.org under administration and development tools.
Before a statement runs, pgjumbo shows which rows it will touch, which triggers will fire, which foreign keys cascade, and what gets locked. A “Rehearse” mode runs an UPDATE, DELETE or MERGE inside an uncommitted transaction and shows old and new values side by side before you commit. It also renders EXPLAIN output as a diagram with the slowest step marked, and can test a hypothetical index without actually building one. Production-marked servers get an extra confirmation prompt on destructive statements. It connects directly, over SSL or through an SSH tunnel, and supports Amazon RDS and Aurora with IAM sign-in.
-- in pgjumbo: run as a rehearsal first, see the before/after, then commit
UPDATE orders SET status = 'cancelled' WHERE customer_id = 482;
Why it matters: the usual way to find out a WHERE clause was too broad is after it has already run. A client that shows the blast radius of a write, and lets you try it in a transaction you can still roll back, catches that before it becomes an incident.
The caveat: it is a brand-new 1.0.x tool from one developer, not an established client like pgAdmin or DBeaver, so treat it as worth trying rather than a default yet.