Free PostgreSQL client · runs in your browser
Paste a connection string. Start querying.
pgquery is a free, open-source PostgreSQL client in your browser: SQL editor, table editor, ER diagram, RLS policies, EXPLAIN viewer and advisors. One Docker container, no account.
Works with any Postgres you can reach: Supabase, Neon, RDS or your own server. Or look around a read-only sample store first.
Compared honestly
Where it wins. Where it doesn’t.
pgquery is ours, so the gaps are listed as carefully as the strengths. Full comparison with CloudBeaver and Adminer, or vs DBeaver.
| Feature | pgquery | pgweb | DbGate | pgAdmin 4 | Supabase Studio |
|---|---|---|---|---|---|
| Self-hosted as | One Go container | One Go binary or container | Node.js server (container or npm); also desktop | Python web app | Part of the Supabase stack |
| Own login and user accounts | NoPut it behind a VPN or auth proxy | PartlyHTTP basic auth | Yes | Yes | PartlyBasic auth when self-hosted |
| SSH tunnel | No | Yes | Yes | Yes | No |
| Visual EXPLAIN | YesTree with time share | PartlyEXPLAIN as text | Not in its feature list | Yes | Yes |
| Row Level Security editor | Yes | No | Not in its feature list | Yes | Yes |
| Performance and security advisors | Yes | PartlyActivity and settings views | No | PartlyActivity dashboards | YesMore checks than pgquery |
| Backup and restore | NoUse pg_dump | Partlypg_dump export, no restore | PartlyImport / export, NDJSON archives | Yes | PartlyPlatform backups |
| Import CSV | No | No | YesAlso Excel, JSON, XML | Yes | Yes |
| License | MIT | MIT | GPL-3.0 (paid Premium) | PostgreSQL License | Apache 2.0 |
| Maturity | New (2026), one maintainer | 10+ years, small team | Very active, company-backed | 10+ years, PostgreSQL community | Large company, very active |
Where pgquery wins
- More than a query explorer: RLS policies, roles, indexes, functions, triggers, extensions and settings, which pgweb doesn’t cover.
- Postgres-specific depth DbGate doesn’t focus on: Row Level Security, performance and security advisors, pg_stat_statements.
- EXPLAIN ANALYZE as a tree that points at the slowest node and flags bad row estimates.
- Small and stateless: one container with a Go binary, nothing stored on the server.
Where pgquery loses
- No SSH tunnels. pgweb, DbGate, pgAdmin and CloudBeaver connect through a bastion host where pgquery cannot.
- No login of its own. pgweb has basic auth, DbGate, pgAdmin and CloudBeaver have accounts; pgquery needs a VPN or an auth proxy.
- PostgreSQL only. DbGate, CloudBeaver and Adminer also speak MySQL, SQLite, SQL Server and more.
- No backup / restore, CSV import or schema diff. DbGate and pgAdmin have them, and DbGate previews even row edits as SQL.
Procedure 1
Run your own
docker run -p 54280:54280 ghcr.io/hxndrik/pgqueryhttp://localhost:54280postgres://user:pass@host/dbContents
Eighteen tools in one window. The linked chapters have their own guide.
Connecting a hosted database? Step-by-step for Supabase, Neon, Amazon RDS and local or Docker.
Specifications
| Footprint | One Docker container, amd64 and arm64 |
|---|---|
| Accounts | None |
| Where state lives | Your browser (localStorage). The server keeps nothing. |
| Schema changes | Shown as SQL before they run; dropping a table asks first |
| Encryption | SSL when the server offers it, with a warning when it doesn’t |
| Connection formats | postgres:// URI, Npgsql / ADO.NET key=value (Host=…;Database=…) |
| Also browses | S3-compatible buckets |
| License | MIT |
Questions
What is pgquery?
A free, open-source PostgreSQL GUI that runs in your browser: SQL editor, table editor, ER diagram, RLS policies, roles, indexes, an EXPLAIN plan viewer and performance and security advisors.
Is it really free?
Yes. MIT licensed, no paid tier, no account.
Where are my connection strings stored?
In your browser's localStorage. The proxy forwards each query and keeps nothing.
How do I self-host it?
Run docker run -p 54280:54280 ghcr.io/hxndrik/pgquery and open http://localhost:54280.
Does it work with RDS, Supabase, Neon or a VPS?
Yes. Any PostgreSQL server the container can reach over the network.
How is it different from pgweb?
pgweb is a lean, mature query explorer shipped as one binary, with SSH tunnels. pgquery adds the administration side (RLS policies, roles, indexes, functions, triggers, extensions, settings), advisors, a visual EXPLAIN tree and an ER diagram; it has no SSH tunnels yet.
Is pgquery related to the pg_query parser library?
No. pg_query by pganalyze is a Postgres query parser for developers; pgquery is a database GUI.