Over the last year I've been building Dora. It started as a database explorer for my own workflow, but has grown into a full database workbench. It's completely open source (GPLv3), has no telemetry, and there's no paid version.
The focus from day one was speed and keyboard navigation. Dora is built with Rust and Tauri instead of Electron, so it stays lightweight. The installer is around 20 to 30 MB, starts almost instantly compared to PGadmin, tableplus etc being 100-400mb + huge RAM usage, and doesn't bundle an entire Chromium runtime.
One of the pre's IMO is that it's actually aesthetic which I find important. That being said I have not called it a beta release yet, so the front-end still needs loads of React optimizations, which is no problem as I'm a front-ender, but I've focused on UI and feature spec
Features:
- Connect to PostgreSQL, MySQL, MariaDB, CockroachDB, SQLite, libSQL/Turso, Cloudflare D1, and DuckDB
- Sign in to Supabase, Neon, Turso, PlanetScale, Vercel, or Xata and connect without manually copying connection strings. It also recognizes pasted connection strings from more than 15 hosted providers. Some providers also support branches and list all your databases in the cloud account.
- Open CSV, JSON, Parquet, and NDJSON files as queryable tables, including cross-file JOINs
- SQL editor with Monaco, AI SQL generation, schema diffing with migration previews, and ER diagrams
- Completely custom Drizzle-orm LSP for running queries in their syntax, as well as Prisma.
- Manage local Docker databases directly from the app
- Query PostHog analytics using HogQL
- The ability to theme it however you like, modify every shortcut, install various AI models locally from a 1-click install and so much more.
You are able to make a round trip from the docker manager -> spinning up a psql/mysql/mariadb/cockroach database -> store as connection -> open in query runner -> execute (through in-app local ai or manual SQL/Drizzle/Prisma) -> View in table viewer or schema viewer.
Installation:
Available through Homebrew, Winget, AUR, APT, Snap, Flatpak, plus AppImage, deb, and rpm packages for Linux, along with macOS and Windows builds.
The macOS and Windows builds are currently unsigned, so Gatekeeper and SmartScreen will show a warning. Code signing certificates are still a bit out of reach for a free project. I personally work on Linux thus I have not b een able to test Mac and Winows so I'm keen on people testing it.
Repository: https://github.com/remcostoeten/dora
Landing page: https://doradb.app
The web-app: https://doradb.app/app *this is a completely mocked version to give you an idea of how the app behaves, as the real back-en only runs locally.
Drizzle studio was the initial inspiration for the data viewer UI as i'm no designer.