Connect to any PostgreSQL database, browse its schemas, write SQL with autocompletion and
edit tables with every change queued for review. A lightweight desktop GUI for Postgres on
Windows, macOS and Linux.
At home on Linux, Windows and macOS. A real desktop app, not a web page in a window.
Nothing runs unreviewed
Edits wait in the Transaction Log and are committed together as one transaction.
Users and extensions made easy
Create users, grant roles and enable extensions from a panel, without writing any SQL.
Keep an eye on the server
See every session and its query, end a stuck one, and check a database’s size and health.
Features
Everything you need for everyday PostgreSQL work
From connecting to a Postgres database to exporting a table with millions of rows, JumboSQL keeps the whole job in one fast window.
Live schema tree
Schemas, tables, views, materialized views, functions and procedures, with indexes, constraints and triggers under each table and partitions nested under their parent. Loaded on demand from pg_catalog and refreshed whenever you ask.
Smart autocompletion
Tables, columns, functions and keywords as you type, with fuzzy matching that follows your search_path and table aliases. Around it, an SQL editor with script tabs, find and replace, results streamed in as they arrive, and a jump straight to an error.
PostgreSQL, local or cloud
Connect to any PostgreSQL 14 – 19 server, your own or one managed in the cloud. Use the postgresql:// URI from your provider’s console, sign in with a password or a cloud login token, and connect over TLS with full certificate checks.
Review before you commit
Edit table structure and data in place. Every change becomes a SQL statement in the Transaction Log, where you can read it, discard it, or commit everything as one all-or-nothing transaction.
A safety net for risky SQL
Before an UPDATE or DELETE without WHERE, a TRUNCATE or a DROP that loses data runs, JumboSQL asks first and names each statement’s line and what it will do. You choose which checks are on in the Run menu, including one for statements that lock a table.
Entity relationship diagrams
See how tables connect: a table’s ERD tab draws it with the tables its foreign keys link it to. Drag the boxes, zoom in, show column types, and export the diagram as PNG or SVG.
Export any amount of data
Save query results, or stream whole tables of any size to disk: SQL in pg_dump’s three styles or as ON CONFLICT and MERGE upserts, and more.
CSV
SQL
JSON
JSON Lines
ODS
ZIP
Manage roles and extensions
Create users and roles, set passwords and grant or revoke memberships, with passwords sent only as SCRAM-SHA-256 verifiers. Enable, update or disable extensions, and see the functions each provides.
Accessible by design
Buttons, fields and tree rows have names that screen readers such as Orca, Narrator and VoiceOver read aloud. Shortcuts cover everyday actions, the editor’s text can be made larger, and light and dark themes follow your desktop.
Download
Download the PostgreSQL client
JumboSQL 0.3.0-beta for Windows, macOS and Linux. Free for any use, no sign-up.
Now
Free for everyone
Any use, including commercial use at work. No sign-up, no license key.
When paid licenses start
What you have stays free
Every version released before then stays free for any use, for good. We’ll announce paid licenses at least 60 days ahead.