Skip to content

remcostoeten/dora

Repository files navigation

Dora Logo

Dora

The database explorer

A native-feeling desktop database studio for PostgreSQL, MySQL, SQLite, and LibSQL.

Release Downloads License: GPL v3 Snap Built with Tauri Rust TypeScript

Dora App Demonstration

UI heavily inspired by Drizzle Studio

Dora is a cross-platform database studio for PostgreSQL, MySQL, SQLite, and LibSQL. Built with Tauri, it weighs ~10 MB versus the 100+ MB of TablePlus — no Electron bloat, just a fast native app with a Data Viewer, Monaco SQL/Drizzle editor, and local Docker PostgreSQL tooling.

Features

Connect

  • Save, edit, test, search, and switch between connections
  • PostgreSQL, MySQL, SQLite, LibSQL / Turso
  • Structured fields or full connection strings
  • Open SQLite files via native file picker
  • SSL/TLS and SSH tunneling (PostgreSQL)
  • Restore last connection on startup

Local PostgreSQL with Docker

  • Create, start, stop, restart, inspect, remove containers
  • Search, filter, sort containers by status
  • Open container directly in Data Viewer
  • View logs, open terminal, run seed scripts
  • Copy connection snippets, export Docker Compose

Explore and edit data

  • Browse schemas, tables, columns, indexes, and metadata
  • Switch between content and structure view
  • Sort, filter, paginate, show or hide columns
  • Inspect row details and set values to NULL
  • Inline cell editing, add/duplicate/delete rows
  • Bulk edit selections
  • Stage changes in dry-run mode before applying
  • Export data as JSON, CSV, or SQL INSERT
  • Copy schema as SQL or Drizzle
  • Add columns, rename/drop/truncate tables
  • Seed tables with generated data
  • Live table updates (PostgreSQL: LISTEN/NOTIFY, MySQL: polling, others: polling)

Write and run queries

  • Monaco-based SQL and Drizzle editor with autocomplete
  • Run SELECT, INSERT, UPDATE, DELETE, and DDL
  • Save snippets in folders, reuse per connection
  • Schema sidebar to browse and insert tables/columns
  • Query history with search and re-run
  • Filter result sets, switch between table and JSON view
  • Export results as JSON or CSV
  • Edit or delete rows from single-table result sets

Make Dora fit your workflow

  • Keyboard-first navigation with customizable shortcuts
  • Vim keybindings in the editor
  • Dark/light themes and configurable font sizes
  • Secure credential storage via system keyring
  • Query history with search and re-run
  • Multiple result tabs
  • Export database schema (SQL, Drizzle)
  • Control delete confirmations, notifications, and startup behavior

Platforms

Dora is a Tauri app built for macOS, Windows, and Linux.

Get Dora

Download the latest release for your platform:

Install

# Debian / Ubuntu — apt repository (recommended for Linux)
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 dora
# Arch Linux (AUR)
yay -S dora
# Linux (Snap)
sudo snap install dora
# macOS (Homebrew)
brew install --cask remcostoeten/dora/dora
# Windows (Winget)
winget install remcostoeten.dora
# Linux — one-off .deb install
wget https://github.com/remcostoeten/dora/releases/latest/download/Dora_0.0.106_amd64.deb
sudo apt install ./Dora_0.0.106_amd64.deb
# Linux (.rpm)
wget https://github.com/remcostoeten/dora/releases/latest/download/Dora-0.0.106-1.x86_64.rpm
sudo dnf install ./Dora-0.0.106-1.x86_64.rpm
# Linux (AppImage)
wget https://github.com/remcostoeten/dora/releases/latest/download/Dora_0.0.106_amd64.AppImage
chmod +x Dora_0.0.106_amd64.AppImage
./Dora_0.0.106_amd64.AppImage

Database Support

Database Status Notes
PostgreSQL ✅ Supported Full desktop path, SSH tunneling, live change monitoring via LISTEN/NOTIFY
MySQL ✅ Supported Connection pooling, schema introspection, live change monitoring via polling
SQLite ✅ Supported Native desktop workflow with file picker
LibSQL / Turso ✅ Supported Local and remote flows

Development

bun install
bun run desktop:dev

To build: bun run desktop:build

License

GNU General Public License v3.0. See LICENSE.

About

Dora, the db explorah. A lightweight Rust database manager for PostgreSQL, LibSQL, SQLite, and MySQL. Query runner, table viewer, seeding, and built in Drizzle LSP. Includes Docker container management for quick local setups.

Resources

License

Stars

Watchers

Forks

Contributors