QoreDB

One app for all your databases.

The fast, open-source database client built with Rust. Connect to 15 native drivers from a single, beautiful interface. Local-first: your data stays yours.

Website · Download · Docs · Roadmap · Discord

_{8,000+ downloads · 15 database drivers · Two releases a month · Used in production by indie devs and startups.}

Why QoreDB?

DBeaver, pgAdmin, phpMyAdmin do the job — but they feel slow, dated, and full of dialogs from another era. QoreDB is what we wished existed: a tool you actually enjoy opening every morning.

Supported databases

_{Driver auto-detection from DSN — paste a connection string and QoreDB picks the right driver.}

Screenshots

Database browser — multi-connection sidebar, table preview, breadcrumbs.	SQL editor — autocomplete, formatting, multi-statement execution, virtualized result grid.
ER diagram — interactive schema graph with isolate/focus workflows.	Data grid — virtualization, column pinning, advanced filters, inline editing.

Features

Query & schema

• SQL editor — Syntax highlighting, formatting, snippets, multi-statement execution
• MongoDB editor — Autocomplete (collections, methods, operators), real-time JSON linter, aggregation pipeline validation with stage classification and examples
• QoreQuery — Type-safe multi-dialect query builder (JOINs, subqueries, aggregates, CAST, COALESCE, LIKE/ILIKE) targeting PostgreSQL, MySQL, SQLite, DuckDB and SQL Server
• Query library — Folders, tags, JSON import/export, reusable queries
• ER diagram — Interactive schema graph with isolate/focus workflows [Pro]
• Visual DDL editor — Full CREATE and ALTER TABLE from the UI: columns, foreign keys, indexes, check constraints with live driver-specific SQL preview
• Explain Plan visualization — Interactive execution plan tree with cost highlighting (PostgreSQL, MySQL, SQL Server)
• Visual data diff — Side-by-side comparison of table/query results [Pro]
• Global full-text search — Search values across all tables and columns
• Foreign key peek + virtual relations — Navigation even without native FK constraints
• Routines, procedures, triggers & events — List, create and edit stored objects with SQL templates

Data operations

• High-performance data grid — Virtualization, server-side filtering/sorting, pagination, infinite scroll, column pinning
• Advanced column filters — contains, regex, greater than, between and more across every driver
• Inline editing — Edit rows directly in SQL and NoSQL datasets
• Bulk edit — Multi-row column updates from the grid with live SQL preview (≤ 5 rows in Core, more in Pro)
• Time Travel — Browse the history of any row with a visual timeline, diff between any two points, preview Rollback SQL before reverting [Pro]
• Blob/binary viewer — Hex / base64 / image preview (PNG, JPEG, GIF, SVG, BMP, ICO) with copy-as-data-URI
• CSV import — Automatic separator/encoding detection, column mapping, preview before import
• Transaction management — Toggle autocommit, explicit Commit/Rollback, active transaction indicator
• Export pipeline — CSV, JSON, SQL, HTML, self-contained HTML (+ XLSX/Parquet in Pro)
• Cross-database federation — Query and join across active connections via DuckDB
• Sandbox mode — Isolated local changes with migration generation
• Backup & restore — Visual wrappers around pg_dump, mysqldump, mongodump and sqlite3 .dump, with streaming logs, cancel mid-run and tool-path overrides
• Query result cache — Recent table navigation served instantly from a local cache, auto-invalidated when you change data through QoreDB
• Plugin system — Install declarative plugins contributing SQL snippet packs, connection templates and color themes — no code execution

Data quality & integration

• Data Contracts — Declarative YAML assertions (12 rule types: NOT NULL %, regex, range, unique, FK integrity, custom SQL) executed as generated SQL, with a health dashboard, notebook cell and post-mutation alert hook [Pro]
• Instant Data API — Expose saved queries as read-only REST endpoints on 127.0.0.1, with Bearer auth, rate limiting, OpenAPI 3.1 generation and one-shot token regeneration [Pro]
• Data Generator — Schema-aware test/seed data (types, constraints and foreign keys honored), realistic values, configurable volume, SQL preview then direct execution or .sql export [Pro]

Notebooks

• Executable documents mixing SQL/Mongo and Markdown cells, connected to a live database
• Parameterized variables ($customer_id, {{date_from}}) with typed inputs
• Run All / Run From Here with stop-on-error
• Inter-cell references and Chart cells (bar, line, pie, scatter) [Pro]
• AI cells — natural-language prompts that generate an adjacent SQL cell [Pro]
• Import from .sql / .md, export to Markdown or standalone HTML
• .qnb file format, Git-diffable

MongoDB & Redis

• MongoDB — Bulk write/find, aggregation pipeline validation, regex and text search, native index management UI
• Redis — Create, edit and delete keys and values across all Redis types from the UI, with Lua script evaluation

Security & reliability

• Secure vault — Native OS keychain storage (Argon2) + optional app lock
• SSH tunneling — Native OpenSSH client with proxy jump support
• SQL Server Windows authentication — NTLM (username/password) and SSPI/Kerberos (integrated, no credentials)
• Environment safety — Dev/Staging/Prod guards, dangerous query detection, read-only mode
• Query rate limiting — Per-connection guardrail against accidental runaway query loops, plus a filesystem capability allow-list
• Universal Query Interceptor — Central hooks for safety, audit and profiling
• Audit logging — Sensitive content redaction in logs, stable SHA-256 query fingerprint per entry, JSONL/CSV export from the full retained trail
• Connection resilience — Automatic reconnection, health monitoring, smart keep-alive
• Background job manager — Async execution for long-running tasks with error recovery

User experience

• Workspaces — Group connections, queries, notebooks and history per project
• Multi-tab workspace — Drag-and-drop reorder, pinned tabs, persistent context across connection switches
• Tab groups — Tabs grouped by connection, collapsible, per-tab context menu
• Session restore — Tabs and their state persist on app restart
• Global search — Cmd/Ctrl + K across connections, history, commands, library
• Breadcrumb navigation — Connection > Database > Schema > Table clickable path
• Dark / light theme
• Customizable keyboard shortcuts — Every binding editable from Settings, click-to-rebind, conflict detection, cross-OS chords, reset per shortcut or globally
• 9 languages — English, French, Spanish, German, Portuguese (BR), Russian, Japanese, Korean, Chinese (Simplified)

AI assistant [Pro]

• Contextual query generation and error correction
• Schema-aware suggestions
• Natural-language DataGrid filters — describe a filter in plain language, preview the generated WHERE clause before applying
• Bring your own key (OpenAI, Anthropic, …)

Performance

• ~25% faster on real workloads (Apple Silicon) thanks to per-column decoders, MessagePack streaming between Rust and the frontend, batch streaming, expanded LRU caches, and the mimalloc allocator
• Lazy loading — heavy frontend modules load on demand for faster startup

How QoreDB compares

We're young but moving fast — see the public roadmap.

Installation

Download

Grab the latest release for your platform from the Releases page or qoredb.com/download.

Arch Linux (AUR)

yay -S qoredb-bin

Build from source

Prerequisites: Node.js 18+, pnpm, Rust 1.70+, Tauri system dependencies.

git clone https://github.com/QoreDB/QoreDB.git
cd QoreDB
pnpm install
pnpm tauri dev      # development
pnpm tauri build    # production

Ubuntu / Debian sys