Kwery01GRID
Virtualized results
Scroll 50,000-row results without the UI flinching. Only visible cells are drawn, on the GPU.
Native SQL editor · MCP built in
The SQL editor
your agent asks
before it writes.
Kwery is a fast, native editor for PostgreSQL, MySQL and SQLite. Its MCP server keeps running with the app closed, and nothing touches your data without your say-so.
Lifetime license, €18.99 excl. VAT · one active device · buy more for your team anytime.
LinuxmacOSWindows
3engines: PostgreSQL, MySQL, SQLite
0Electron, JVM or webview
1 txper batch of grid edits
6MCP tools for your agent
€18.99once. Not per month.
01 · Features
Everything you reach for.
Nothing you wait on.
Kwery is built on gpui, the GPU UI framework behind the Zed editor. It opens instantly and scrolls big result sets smoothly, with nothing between you and the rows.
02EDIT
Inline editing, staged
Double-click to edit, add or delete rows. Changes show as a diff until you apply them in one transaction.
03SAFE
One-row guard
Every UPDATE and DELETE must hit exactly one row by primary key, or the whole batch rolls back.
04PAGE
Tables that page
1,000-row pages with infinite scroll, a WHERE filter, and ORDER BY on the server when you click a header.
05SQL
A real console
Column and foreign-key JOIN autocomplete, run the statement at the cursor, explain plans as a tree, parameters, cancel anytime.
06TREE
Folders & colors
Group connections in folders and color the risky ones. Production in red looks like production everywhere.
07LAZY
Drivers on demand
Each driver is its own small binary, fetched on first use and sha256-verified. Unused engines stay off your disk.
08MCP
Agent-ready
A stdio MCP server for Claude Code, Cursor and friends. It runs even when the editor is closed.
09ASK
Approval popups
Reads and writes can be Allowed, Asked, or Disabled — globally or per connection. Asking pops a native dialog.
02 · Console
Write. Run.
Cancel.
Each console gets its own driver process, so a runaway query never freezes the app — hit Stop and Kwery kills it.
| Ctrl/⌘ Enter | Run statement at cursor or selection |
| Ctrl/⌘ . | Cancel running query |
| Ctrl/⌘ T | New console |
| Ctrl/⌘ W | Close tab |
| Ctrl Tab | Next tab |
| Ctrl/⌘ , | Settings |
03 · Editing
Edit rows like a diff.
Changes sit staged — yellow for edited, green for new, red for deleted — until you hit Apply.
- All pending changes apply in a single transaction.
- Each UPDATE and DELETE is keyed on the primary key and must hit exactly one row, or everything rolls back.
- Inserts only send the columns you filled, so defaults and sequences still work.
- No primary key? The table opens read-only rather than guessing.
04 · MCP server
Let agents query.
Keep your hand on the write key.
Kwery exposes your connections to Claude Code, Cursor and any MCP client over stdio. The server is its own process, so it works with the editor closed, and approvals appear as a native popup.
$ claude mcp add kwery -- kwery mcp ✓ Added stdio MCP server kwery # tools the agent gets list_connections names, drivers, effective policy list_tables tables and views per connection describe_table columns, keys, indexes, foreign keys, DDL list_saved_queries the SQL you saved, as examples compare_schemas dev vs prod drift, as a script query SQL, 500-row cap, policy-checked > query shop "DELETE FROM orders" ✗ Write queries are disabled for MCP on this connection.
| Policy | Read queries | Write queries | Scope |
|---|---|---|---|
| Allow | Run immediately, inside a read-only transaction | Run immediately | Global default, overridable per connection |
| Ask me | Native popup: Allow / Deny | Popup with a red Allow button | |
| Disabled | Hide a connection's data from agents | Default — agents can't write |
05 · Compare
Honest about the trade-offs.
Kwery is deliberately small. If you need 20 engines, schema diffs and ER diagrams today, DataGrip and Beekeeper Studio are great. If you want fast, native, safe for agents and paid once, try Kwery.
| Kwery | Beekeeper Studio | DataGrip | |
|---|---|---|---|
| Price | ● €18.99 once | ◐ Free Community · paid from $9/user/mo | ◐ Subscription · free non-commercial |
| Runtime | ● Native Rust, GPU-rendered | ◐ Electron | ◐ JVM IDE |
| MCP server without the GUI | ● kwery mcp | ○ In-app AI shell only | ◐ Needs the IDE running |
| Per-connection AI read/write policy | ● Allow · Ask · Disabled | ◐ Asks before running SQL | ● Consent levels |
| Reads forced into read-only transactions | ● Yes | ○ — | ○ — |
| Inline edit with staged apply | ● Yes, PK + one-row guard | ● Yes | ● Yes |
| Engines | ◐ PostgreSQL · MySQL · SQLite | ● 26 (many paid) | ● 20+ |
| SSH tunnels | ● Yes, via your ssh config | ● Yes | ● Yes |
| Export CSV / JSON / SQL | ● Yes, whole tables streamed | ● Yes | ● Yes |
| Schema & data compare | ● Yes, as a migration script | ○ — | ● Yes |
Competitor details from their public sites, September 2026. Prices are list prices and may change.
06 · Pricing
Pay once.
Query forever.
One license per person, active on one device at a time. Buy several and hand them out from your account.
- Desktop app for Linux, macOS and Windows
- Built-in MCP server and approval popups
- Assign licenses to teammates by email
- Move devices yourself from kwery.sh/account
07 · FAQ
Questions, answered.
What does “one active device” mean?
Each license can be activated on one computer at a time. Moving machines? Deactivate the old one in Kwery or from your account on kwery.sh, then activate the new one. No support ticket, no waiting.
Can I buy licenses for my team?
Yes. Choose a quantity at checkout. Every license shows up in your account, where you assign it to a teammate by email. They sign in with that email to get their key. You can reassign any time — the old device is signed out.
Is it really a one-time payment?
Yes. €18.99 per license excluding VAT, once. VAT for your country is added at checkout. No subscription, no seat renewal.
Does my data go through your servers?
No. Kwery connects straight from your machine to your database. kwery.sh only knows your email, your licenses and the name of the device each one is active on.
How does the MCP server stay safe?
Write queries are disabled for agents until you allow them. You can require approval for every read or write, per connection. Reads also run inside a read-only transaction, so a sneaky WITH … DELETE is rejected by the database itself.
Who handles payments and invoices?
Polar is our merchant of record: they handle checkout, VAT and invoices. Everything after checkout — licenses, seats and devices — lives in your kwery.sh account.