PostgreSQL
A minimalist PostgreSQL GUI.
Paste a connection string and you are looking at your schema. JustDB is a small, native desktop GUI for PostgreSQL — local, in Docker, or hosted — that skips the dashboards and admin panels and gets you straight to tables, queries and rows.
Free · No signup · Local-first
-- top customers by paid revenue
select u.name,
count(o.id) as orders,
sum(o.total_cents) / 100.0 as revenue
from users u
join orders o on o.user_id = u.id
where o.status in ('paid', 'shipped')
group by u.name
order by revenue desc;| name | orders | revenue | |
|---|---|---|---|
| 1 | Linus Torvalds | 1 | 674.0 |
| 2 | Ada Lovelace | 1 | 129.99 |
| 3 | Alan Turing | 1 | 79.5 |
-
Connect in seconds
Any PostgreSQL you can reach — localhost, a Docker container, or a hosted server with TLS. Paste a URL and connect.
-
Just the essentials
No server dashboard, no role manager, no nine panels. Tables, a SQL editor and inline editing — the everyday loop.
-
Credentials stay yours
A direct connection from your machine. Passwords live in the OS keychain, never a cloud account.
What you get
Everything you need. Nothing you don't.
- Browse tables, views, columns, indexes and foreign keys
- Follow a foreign key to the row it points at
- SQL editor with completion, formatting and EXPLAIN plans
- Inline row editing with a Review-SQL step and cascade preview
- Connect to local, Docker or hosted Postgres over TLS
- Import from CSV; export to CSV, JSON, SQL or Excel
FAQ
Common questions.
Is JustDB a full PostgreSQL admin tool?
No — and that is the point. JustDB focuses on the everyday developer loop: browsing schemas, running queries and editing rows. For deep server administration, a tool like pgAdmin is a better fit.
Can it connect to Postgres in Docker?
Yes. A container is just a host and a port — point JustDB at localhost:5432 (or whatever you published) like any other server.
Does it work with hosted Postgres?
Yes. Any PostgreSQL you can reach over the network, with TLS when the server requires it.
Is it free?
Yes. No account, no trial, no paid tier. It is a free native desktop app for macOS and Windows.