Desktop App per Machine
pgAdmin runs as a desktop app on each machine, or as a web app you deploy yourself. QueryGlow installs with one command on your server and the whole team opens the same URL.
Native PostgreSQL Support
A Self-Hosted PostgreSQL GUI Your Team Opens in a Browser
pgAdmin is the free, official PostgreSQL admin tool. QueryGlow is a PostgreSQL GUI your whole team opens in a browser, with schema-only AI, Safe Mode and a check before writes on production.
The live demo is the real app on a sample database (read-only, AI switched off, no signup).
Less than DataGrip's first year ($109, individual) or a year of DBeaver Lite ($113 per user per year, as of September 2026). $79 once: source code included, every 1.x update, every server you run, your whole team.
- Web-Based
- Schema-only AI
- SSH Tunnels
- 6 Databases
“Beautiful interface and very intuitive.”
Jean-Francois, Mildor Violon, verified customer
https://db.your-company.com
Where pgAdmin and QueryGlow Differ
pgAdmin is free and covers a lot of ground. These are the points that matter for day to day development.
DROP TABLE Runs as Typed
In pgAdmin's Query Tool a DROP TABLE runs as typed. QueryGlow refuses it by default and asks before any write on a production connection.
What the AI Sees
pgAdmin added an AI Assistant in 9.13. QueryGlow's Ask AI sends only the schema (table and column names with their types), never rows, with your own key.
Admin Tool or Daily Work
pgAdmin covers administration and monitoring; QueryGlow focuses on browsing, querying and editing data.
Everything You Need for PostgreSQL Development
What you get in the browser tab.
Opens in a Browser Tab
No desktop client to launch, nothing to install per machine. Open the URL and work. One ./queryglow update on the server updates everyone.
Schema-Only AI SQL
Ask AI drafts PostgreSQL from plain English with your own OpenAI, Anthropic or Google key. It sends table and column names with their types and your prompt, never rows. Enter the key in the app (stored encrypted on your server) or set it in .env.
Web-Based Access
Open your PostgreSQL databases from any modern browser. Your whole team uses the same install behind one shared login.
SSH Tunnels Built-In
Reach PostgreSQL in private networks. Paste your private key into the connection form. The host key is pinned on first connect; a server that presents a different key is refused.
Asks Before Writes on Production
Mark a connection as production and it shows in red in the sidebar and header. The Query Editor shows the statement and asks before any INSERT, UPDATE, DELETE or DDL runs on it.
JSON and JSONB Cells
JSON and JSONB columns show as JSON text in the Data Browser and in query results, and you can edit them.
Visual Column Editing
Add, rename, retype and drop columns. You see the exact ALTER statement first, and what runs is exactly what you saw.
Paste a Connection URL
Paste a postgres:// URL from Supabase, Neon or RDS and the form fills itself. Find databases on this server lists every database your login can open and adds them in one go.
CSV Import and Export
Import with INSERT, UPSERT (ON CONFLICT) or REPLACE. Detects the delimiter; you pick the encoding. Export streams up to 100,000 rows per file by default.
EXPLAIN Visualizer
Visual query plan analysis with color-coded nodes. Warnings flag sequential scans and suggest CREATE INDEX statements.
SQL Autocomplete
Schema-aware completions for tables, columns, keywords, and functions. Type table. to see columns with data types.
Agent Access with Activity
Give Claude Code or Cursor a read-only token instead of a connection string. Every agent call shows up in the Activity tab, and you can pause one agent or all of them.
Set It Up Your Way
Dark or light theme, six accent colors, rows per page up to 500, NULL display, time zone and date format, and your own keyboard shortcuts.
QueryGlow vs pgAdmin
| Feature | pgAdmin | QueryGlow |
|---|---|---|
| How it opens | Desktop app, or a web app you deploy (server mode or container) | Browser tab, one install on your server for the whole team |
| Query guard | No statement guard (Auto commit can be turned off) | Refuses DROP TABLE, TRUNCATE and unfiltered UPDATE/DELETE by default; asks before writes on production |
| AI data boundary | AI Assistant (since 9.13) | Ask AI: schema only, never rows, your own OpenAI, Anthropic or Google key |
| SSH Tunnels | Yes (identity file or password) | Yes, key pasted in the form, host key pinned |
| Installation | Installer per machine, or server mode | Docker on your server: ./queryglow install, then ./queryglow update (backup, automatic rollback) |
| Focus | Administration, development and monitoring | Browsing, querying and editing data |
| Inline Cell Editing | Yes | Yes |
| Query History | Yes | Yes, per connection (last 1,000 queries) |
| Server Monitoring | Yes (advanced) | No |
| Price | Free | $79 once, whole team |
How it opens
pgAdmin
Desktop app, or a web app you deploy (server mode or container)
QueryGlow
Browser tab, one install on your server for the whole team
Query guard
pgAdmin
No statement guard (Auto commit can be turned off)
QueryGlow
Refuses DROP TABLE, TRUNCATE and unfiltered UPDATE/DELETE by default; asks before writes on production
AI data boundary
pgAdmin
AI Assistant (since 9.13)
QueryGlow
Ask AI: schema only, never rows, your own OpenAI, Anthropic or Google key
SSH Tunnels
pgAdmin
Yes (identity file or password)
QueryGlow
Yes, key pasted in the form, host key pinned
Installation
pgAdmin
Installer per machine, or server mode
QueryGlow
Docker on your server: ./queryglow install, then ./queryglow update (backup, automatic rollback)
Focus
pgAdmin
Administration, development and monitoring
QueryGlow
Browsing, querying and editing data
Inline Cell Editing
pgAdmin
Yes
QueryGlow
Yes
Query History
pgAdmin
Yes
QueryGlow
Yes, per connection (last 1,000 queries)
Server Monitoring
pgAdmin
Yes (advanced)
QueryGlow
No
Price
pgAdmin
Free
QueryGlow
$79 once, whole team
pgAdmin facts as of September 2026 (pgAdmin 4 v9.18), from pgadmin.org.
Honest note: pgAdmin is free and has advanced DBA features like server monitoring and backup tools. If you're a full-time DBA managing clusters, pgAdmin might be the better choice. QueryGlow is for developers who browse and query data every day and want a query guard and schema-only AI in the browser. Its table list and autocomplete cover the public schema.
See it on a real database before you decide
$79 once for your whole team, every 1.x update included.
Try the live demo
Stripe checkout. You'll need a GitHub account for the repo invite. No refunds, so try the read-only demo first.
Works with the PostgreSQL Ecosystem
QueryGlow uses the native pg driver. CockroachDB and TimescaleDB are PostgreSQL-compatible.
All three use the same pg driver and the same UI; EXPLAIN output differs by engine.
One License, Six Databases
Your $79 license includes all six databases with unlimited connections.
PostgreSQL FAQ
Is QueryGlow better than pgAdmin?
It depends on your role. pgAdmin is free and has more DBA features like server monitoring, maintenance tools and backup utilities. QueryGlow ($79 once) is a browser GUI for daily development with Safe Mode, schema-only AI SQL, SSH tunnels and a check before writes on production. If you mostly browse data and write queries, try the live demo (the real app on a sample database, read-only, AI switched off, no signup) and decide.
Does QueryGlow have Safe Mode for PostgreSQL?
Yes. Safe Mode always refuses DROP DATABASE and COPY ... TO/FROM PROGRAM. By default it also refuses DROP TABLE, TRUNCATE, and DELETE or UPDATE without WHERE (QUERYGLOW_ALLOW_DESTRUCTIVE=true lifts these). A SELECT without LIMIT gets LIMIT 1000. Safe Mode is on in a fresh install and covers the Query Editor and AI agents. On a connection marked production, the Query Editor also asks before any INSERT, UPDATE, DELETE or DDL.
Can I connect to remote PostgreSQL servers via SSH?
Yes. QueryGlow has built-in SSH tunnels bound to localhost on a random port. Paste your private key into the connection form, no terminal setup and no separate SSH client. The SSH host key is pinned on first connect, and a server that presents a different key is refused. For direct connections turn on SSL; Verify server certificate checks certificates from a public authority (leave it off for Amazon RDS, whose certificate authority is not in the public store). Works with PostgreSQL on AWS RDS, DigitalOcean, Supabase or private networks without exposing database ports.
Does QueryGlow work with CockroachDB and TimescaleDB?
Yes. CockroachDB and TimescaleDB are PostgreSQL-compatible and use the same pg driver. Schema-only AI, Safe Mode, CSV import and export and inline editing work the same way. One tool for PostgreSQL, CockroachDB and TimescaleDB.
How does the AI feature work with PostgreSQL?
Ask AI sends your database type, table and column names with their types, and your prompt. Never rows. You describe what you need in plain English, the SQL lands in the editor, and you review it before running. Use your own OpenAI, Anthropic or Google key, entered in the app (stored encrypted on your server) or set in .env. Ask AI is switched off in the public demo.
Does QueryGlow show every PostgreSQL schema?
The table list, autocomplete and Ask AI cover the public schema. Tables in other schemas can be queried by name in the Query Editor.
Can AI agents query my PostgreSQL database safely?
Agent Access gives Claude Code, Cursor or another MCP client a token instead of a connection string. Tokens are per connection and read-only by default, enforced by the database with a read-only transaction. Every call, including refused ones, shows up in the Activity tab, and you can pause one agent or all of them.
Is QueryGlow secure for production PostgreSQL databases?
Connection passwords, SSH keys and AI keys are encrypted at rest with AES-256-GCM. Safe Mode refuses destructive statements by default. Connections marked production show a red badge in the sidebar and the header, and the Query Editor shows the statement and asks before any write runs on them. SSH host keys are pinned, and SSL connections can verify the server certificate. Your rows never leave your server; Ask AI sends only the schema, and only to the provider whose key you entered. No telemetry, no tracking.
How do updates work?
Run ./queryglow update on your server. It backs up first, checks the new nginx config, keeps the running image as queryglow:previous, checks that the new version is serving and rolls back on its own if not. Every 1.x update is included in the $79.
Ready to Try QueryGlow on PostgreSQL?
$79 once. Safe Mode. Schema-only AI. All six databases included.
One-time payment. No subscription. Try the demo first.