The PostgreSQL client that shows its work
Browse, query, edit and administer your servers on macOS, Windows and Linux. You see every statement before it runs.
Open a Query Tool from the Explorer, let autocomplete find the table, run the query, and the Inspector follows what you select. The status bar keeps the server, the transaction state and the timing in view.
The window never waits on the database
A Rust engine talks to PostgreSQL through libpq, the library psql uses, and hands results to the grid as binary pages. Every network call runs in the background and can be cancelled.
to list a schema that holds 5,000 tables
to the first rows of a 1,000,000-row result
for the whole app, on every OS
analytics or telemetry. Logs stay on your machine.
See what will happen before it happens
Generated SQL is always shown first. Changes wait in their tab until you save, and anything that touches production asks before it runs.
Ask Claude about your database
The Assistant runs the Claude Code you installed and signed in to, with pgjumbo's tools and nothing else. It reads only what each server allows, shows every read, and proposes SQL that you accept into the editor. Nothing it writes runs by itself.
- You ask in the pane beside the tab, or with ⌘K or Ctrl+K in the editor.
- Claude reads through pgjumbo's tools, as far as the server's access levels allow. Each read is a line in the conversation.
- You decide. SQL waits in the editor and changes wait in their tab's Review until you run or save them.
Ask why a query is slow. The Assistant reads the tab, names the slow step and proposes an index. Accept in editor puts it under your query, where it waits for you to run it.
Keyboard first, on every layout
Every frequent action has a shortcut, with ⌘ on macOS and Ctrl on Windows and Linux.
No shortcut uses Ctrl+Alt. On Bosnian, Croatian, German and Polish keyboards that combination is AltGr, which types [ ] { } @ \ |, so in pgjumbo it keeps typing them.
Every feature, area by area
All of them work the same on macOS, Windows and Linux.
Build it on your machine
pgjumbo is open source. Install the prerequisites once, then one command builds the app and its installers. Apps you build yourself start without security warnings.
pnpm install pnpm tauri build
Every OS needs Git, Rust through rustup, Node.js 22 or newer, and pnpm. pnpm check-prereqs tells you what is still missing. The installers land in target/release/bundle/.
macOS 13 or newer
Needs the Xcode Command Line Tools. You get pgjumbo.app and a .dmg, and one universal build covers Apple Silicon and Intel.
Windows 10 and 11
Needs the Visual Studio Build Tools for C++ and Strawberry Perl; winget installs both. You get an .msi and a setup.exe.
Linux
Needs WebKitGTK 4.1 and its dev packages. You get an AppImage, a .deb and an .rpm.
PostgreSQL 12 to 18
Including Amazon RDS and Aurora, Google Cloud SQL, Azure Database for PostgreSQL, Supabase and Neon, where features adapt when you are not a superuser.
A real desktop app
Tauri 2, React and a Rust engine. No browser tab, no local web server, and the platform's own menus, dialogs and credential store.
MIT or Apache-2.0
Every dependency can be shipped under both licenses. Read the code, change it, and send a pull request.