Free for any use, and what you download now stays free

A fast, native
PostgreSQL client.

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.

No sign-up. By downloading, you accept the License Agreement.

  • Windows, macOS & Linux
  • PostgreSQL 14 – 19
  • Version 0.3.0-beta

Truly native

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.

Loading the download links…

By downloading JumboSQL, you accept its License Agreement.

Community & support

We’d love to hear from you

Questions, bug reports and ideas about the preview are all welcome.

Join us on Discord

Ask questions, share feedback and follow JumboSQL’s development together with other PostgreSQL users.

Join the Discord server

E-mail support

Tell us what you were doing, which versions of JumboSQL and PostgreSQL you use, and what happened.

The address is loaded only when you ask for it, to keep it away from spam bots.