ORM auto-connect, schema drift, Local Snapshot, SQL notebooks, schema-aware AI, EXPLAIN ANALYZE, ERD generation. Native macOS, built with Swift. $79 once.
Auto-detect your ORM, connect in one command
Run qdeck in your project directory. Drizzle and Prisma get the deepest support (that is where the drift gap is widest). Also detects TypeORM, Knex, Django ORM, ActiveRecord, and Sequelize. Reads the connection config and opens pre-connected. No more copy-pasting DATABASE_URL.
Spot the gap between your ORM and your database
QueryDeck compares your ORM schema with the live database in a dedicated read-only view. Drizzle Kit can compute a live diff through push, while Prisma migrate dev detects development drift; QueryDeck keeps the comparison visible inside the database client instead of tying discovery to a migration command. Drift Mode covers Drizzle, Prisma, TypeORM, ActiveRecord, and Django. Knex and Sequelize get auto-connect but no Drift Mode parser.
Reproduce the real production case in a local database.
Start from the PostgreSQL row that reproduces the bug. QueryDeck computes the required foreign-key context, lets you review privacy rules, sanitizes sensitive values while preserving relationships, then provisions a local PostgreSQL snapshot through Docker or a compatible local server.
FK-aware row closure
Deterministic sanitization
Managed Docker or local PG
Open, stop, delete, clean
accounts · id = 1842
7 rows across 4 related tables
Schema-aware SQL editor
Per-dialect syntax highlighting for PostgreSQL, MySQL, SQLite, and MongoDB. Autocomplete that knows your tables, columns, and functions. Multi-tab queries with keyboard-first navigation. Built on AppKit, not a web view.
Schema-aware AI, on-device or cloud
Describe what you want in plain English. QueryDeck generates SQL using your schema as context. Zero-config on-device AI, BYO API key, or local Ollama. Your data never leaves your machine.
Visual query plan analysis
Visual query plan breakdown for PostgreSQL and MySQL. Identify sequential scans, costly joins, and missing indexes at a glance. Stop guessing. Measure.
Auto-generated entity-relationship diagrams
Entity-relationship diagrams generated from your live database schema. Foreign keys become edges. Export to PNG or SVG for documentation.
PostGIS geometry on a native MapKit overlay
Double-click any spatial cell to see the actual shape on Apple Maps. Points, linestrings, polygons, polygons-with-hole, multi-geometries, geometry collections — all rendered natively, not as WKT text you have to paste into a browser viewer. Inline EWKT in the grid is the floor, the MapKit overlay is the ceiling.
Your database as a tool for Claude Code and Cursor
QueryDeck runs as an MCP server. Schema introspection, query execution, and table exploration become native tools for Claude Code, Cursor, or any MCP client. Drop one config block and your AI knows your DB.
SQL notebooks with inline results
Mix SQL cells, Markdown notes, and query results in one interactive document. The Jupyter notebooks for databases. Export to PDF or HTML. Share with your team or attach to a PR.
Cmd+K for everything
Access any action from the keyboard. Switch connections, run queries, open tables, search schema, all without touching the mouse.
Biometric production gating
Require Touch ID authentication before running queries on production databases. Prevent accidental writes with a hardware-backed safety net.
Four databases, one client
PostgreSQL, MySQL, SQLite, and MongoDB. Switch between databases without switching tools. Connection color-coding keeps environments distinct.
Edit data directly in the grid
Double-click any cell to edit. Insert rows, toggle NULLs, set defaults. Pending changes are tracked and applied in a single transaction.
Collapsible tree for JSON and JSONB cells
Double-click any json or jsonb cell to inspect nested objects and arrays in a collapsible popover. Available in query results, table browser, and notebooks.
Connection presets for Postgres, MySQL, and cloud variants
One-click templates for Postgres, MySQL, SQLite, and cloud-managed variants (Supabase, Neon, RDS, Aurora, CockroachDB, PlanetScale, MariaDB). Pick a preset, paste credentials, connect.
Jump across tables with Cmd+Click
Cmd+Click any foreign key cell to open the referenced row in a new tab, pre-filtered on the primary key. Trace data relationships without writing JOINs.
SSH tunnel support for bastion-hosted databases
Connection color-coding: production is red, always
Saved queries organized by project
Data export to CSV, JSON, and SQL
Schema browser with tables, views, functions, and indexes
Query history with full-text search
Read-only mode for production connections
Dark mode, follows macOS system appearance
Full keyboard shortcuts
Works fully offline, no account required
AI assistant is optional, works without it
Swift
AppKit
macOS 14+
Apple Silicon
What databases does QueryDeck support?
QueryDeck supports PostgreSQL, MySQL, SQLite, and MongoDB, all from a single native macOS app.
Which ORMs work with auto-connect vs Drift Mode?
Auto-connect covers 7 ORMs (Drizzle, Prisma, TypeORM, Knex, Django, ActiveRecord, Sequelize). Drift Mode has 5 schema parsers today (Drizzle, Prisma, TypeORM, Django, ActiveRecord). Knex and Sequelize do not have Drift Mode parsers.
What does Drift Mode catch and what doesn't it catch?
Catches: missing or extra columns, column type drift, nullable mismatches, default value drift, missing or extra simple indexes, missing or extra foreign keys, enum type drift. Silently passes (intentionally, to avoid false positives): partial index WHERE clauses, schema-name qualifiers, client-side defaults (UUID/CUID), sort direction, GIN opclasses. Does not catch yet: functional indexes, check constraints, triggers, generated columns, index onDelete/onUpdate changes, custom types like PostGIS.
What AI models can I use with QueryDeck?
You can use OpenAI, Anthropic (Claude), or any model running locally via Ollama. QueryDeck sends only your schema to the AI, never your actual data.
Does QueryDeck work offline?
Yes. QueryDeck works fully offline. No account, no internet connection required. The AI assistant needs internet only when using a cloud API key. Use Ollama for fully offline AI.
Does Bring to Local copy production data as-is?
No. Local Snapshot is designed to de-identify the selected PostgreSQL subset before it is persisted locally. QueryDeck detects sensitive fields, requires review for ambiguous free-form data, keeps credential fields protected, and applies deterministic transforms so foreign-key relationships still match after sanitization.
What macOS version do I need?
QueryDeck requires macOS 14 (Sonoma) or later and an Apple Silicon Mac (M1 or newer). Intel Macs are not supported.
Launch offer: Lifetime at $79 for the first 10 customers, then $149. Try it free for 14 days, no card required.
