Dora is a cross-platform database workbench built with Tauri and Rust. It ships as a ~10 MB binary — versus the 100+ MB you get from Electron-based alternatives — and covers the full day-to-day loop without asking you to leave the app.
Connect to PostgreSQL, MySQL, MariaDB, CockroachDB, SQLite, libSQL/Turso, and DuckDB. Open CSV, JSON, Parquet, and NDJSON as queryable data files. One-click presets for 10+ hosted providers (Supabase, Neon, PlanetScale, Fly.io, Railway, and more). Browse data, run SQL in a Monaco editor, generate SQL with AI, write ORM queries with Drizzle or Prisma, inspect schemas as an ER diagram, and manage local Docker databases — all keyboard-first.
macOS
brew install remcostoeten/tap/doraWindows
winget install RemcoStoeten.DoraArch Linux
yay -S doraDebian / Ubuntu
curl -fsSL https://remcostoeten.github.io/dora/KEY.gpg \
| sudo gpg --dearmor -o /etc/apt/keyrings/dora.gpg
echo "deb [arch=amd64 signed-by=/etc/apt/keyrings/dora.gpg] \
https://remcostoeten.github.io/dora stable main" \
| sudo tee /etc/apt/sources.list.d/dora.list
sudo apt update && sudo apt install doraLinux (Snap)
sudo snap install doraLinux (Flatpak / AppImage / deb / rpm) — download from the releases page.
| Database | Status |
|---|---|
| PostgreSQL | Full support — SSH tunneling, live updates via LISTEN/NOTIFY |
| MySQL | Full support — SSH tunneling, live updates via polling |
| SQLite | Full support — native file picker |
| DuckDB | Full support — local .duckdb files, import CSV/JSON/Parquet as tables |
| libSQL / Turso | Full support — local and remote |
| MariaDB | Full support — MariaDB-aware dialect; native UUID / INET4 / INET6 types |
| CockroachDB | Full support — CockroachDB-aware schema introspection, live monitor auto-tuned |
| Data files (CSV / TSV / Parquet / JSON / NDJSON) | DuckDB-backed sessions — query, export, cross-file JOINs; save as DuckDB to edit |
Hosted & serverless providers are auto-recognized from the connection string with one-click presets — correct engine, dialect, and SSL applied for you:
Neon · Supabase · PlanetScale · Fly.io · Railway · Render · Vercel Postgres · Aiven · DigitalOcean · Crunchy Bridge · Timescale · AWS RDS/Aurora · Azure Database · Google Cloud SQL · CockroachDB Cloud · TiDB Cloud · Yugabyte
They all speak standard Postgres/MySQL/libSQL — no special integration to maintain, just paste the string. See docs/architecture/data-sources.md.
Browse schemas, tables, columns, indexes, and row data. Sort, filter (with AND/OR toggle), and paginate. Inline-edit cells, bulk-edit selections, set values to NULL, add/duplicate/delete rows, and stage changes in dry-run mode before committing. Export as JSON, CSV, or SQL INSERT — respecting your active filters and sort order. Back up a database to a .sql dump and restore from one.
Multi-tab workspace with isolated execution state. Monaco editor with autocomplete, syntax highlighting, and Vim keybindings. Run SELECT, INSERT, UPDATE, DELETE, and DDL. Filter result sets, switch between table and JSON view, export results. Tabs persist across relaunch and can be dragged to reorder.
Press ⌘I / Ctrl+I, describe what you want, get schema-grounded SQL back. Hit Fix with AI on a failed query to send the query and error to the assistant automatically. Supports OpenAI, Anthropic, Gemini, Groq, and Ollama — API keys are stored encrypted (AES-256-GCM) with the master key in the OS keychain. Ollama runs entirely offline, no key required. See docs/ai-providers.md.
Drizzle runner — write and run Drizzle ORM queries with schema-aware autocomplete and a SQL preview before execution.
Prisma runner — write and execute Prisma Client queries natively inside Dora, with schema-aware autocomplete. No separate script file or ts-node needed.
Every query you run is stored, searchable, and re-runnable. History is scoped per connection.
Interactive ER diagram with pan, zoom, FK edges, and a search that dims unrelated tables. Export to SVG or PNG — follows the active theme.
Create, start, stop, inspect, and remove local database containers without leaving the app. Open a container directly in the data viewer, view logs, run seed scripts, or export a Docker Compose file.
Dora distinguishes database files from data files:
| Open this | What you get |
|---|---|
.sqlite / .db |
Editable SQLite database |
.duckdb |
Editable DuckDB database — browse, edit rows, run SQL, import more files |
| CSV, JSON, Parquet, TSV, NDJSON | Readonly DuckDB-backed session — SQL queries, export, cross-file JOINs |
Save as DuckDB materializes a data-file session into a new .duckdb file on disk, then opens it as an editable connection. Import files pulls CSV/JSON/Parquet into physical tables on an existing DuckDB connection.
If a data file moves or goes missing, Dora shows connection health and lets you relocate or remove sources from the source panel without losing the connection entry.
Connect to databases behind firewalls through encrypted SSH tunnels. Tunnel config is stored per connection alongside its credentials.
Dark and light themes, custom accent colours, and configurable font sizes. Live preview, no restart required.
Dora is a Bun + Turborepo monorepo:
apps/
desktop/ # Tauri app (Rust backend + React/TypeScript frontend)
marketing/ # Next.js marketing site
packages/
studio/ # @dora/studio — shared Studio package used by desktop and marketing demo
style/ # Shared oxlint + oxfmt config
Prerequisites: Bun, Rust, and the Tauri prerequisites for your platform.
# Install dependencies
bun install
# Start the desktop app in development mode
bun run desktop:dev
# Run the marketing site
bun run --cwd apps/marketing devBuild
bun run desktop:build # current platform
bun run desktop:build:linux # AppImage + deb + rpm
bun run desktop:build:win # nsis + msi
bun run desktop:build:mac # dmgTests
bun testNote
The desktop app uses Vite as its dev server (http://localhost:1420). Hot-reload works for the TypeScript frontend; Rust changes require a full rebuild.
Bug reports, feature requests, and pull requests are welcome. Open an issue to discuss anything non-trivial before sending a PR.
For significant changes — new database support, new UI surfaces, changes to the Rust backend — please open an issue first so the approach can be agreed on.
macOS (Apple Silicon + Intel), Windows (x64), Linux (x64) via AppImage, deb, rpm, Snap, or Flatpak.
GNU General Public License v3.0. See LICENSE.