QueryDeck is a native macOS database client built with Swift and AppKit. SQL editor, AI assistant, ERD generation, EXPLAIN ANALYZE, all in one tool. $79 once.
Schema-aware SQL editor
Per-dialect syntax highlighting for PostgreSQL, MySQL, SQLite, MongoDB, and Redis. Autocomplete that knows your tables, columns, and functions. Multi-tab queries with keyboard-first navigation. Built on AppKit, not a web view.
AI-assisted SQL generation
Describe what you want in plain English. QueryDeck generates the SQL using your schema as context. Use your own API key, a local model via Ollama, or Claude CLI. 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.
Biometric production gating
Require Touch ID authentication before running queries on production databases. Prevent accidental writes with a hardware-backed safety net.
Five databases, one client
PostgreSQL, MySQL, SQLite, MongoDB, and Redis. Switch between databases without switching tools. Connection color-coding keeps environments distinct.
Cmd+K for everything
Access any action from the keyboard. Switch connections, run queries, open tables, search schema, all without touching the mouse.
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.
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+
Universal
What databases does QueryDeck support?
QueryDeck supports PostgreSQL, MySQL, SQLite, MongoDB, and Redis, all from a single native macOS app.
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.
What macOS version do I need?
QueryDeck requires macOS 14 (Sonoma) or later. It runs natively on both Intel and Apple Silicon Macs as a Universal binary.
Native macOS database client. $79 one-time. All your Macs.
