Dora

The Database Explorer

Dora is a high-performance, keyboard-centric database manager. Built with Rust and Tauri, it provides a native database management experience in a minimal package.

At just ~8.5MB, Dora is tiny compared to pgAdmin (~400MB) or Beekeeper Studio (~120MB).

Manage connections, run queries, visualize data, and handle migrations efficiently without leaving your keyboard.

Key Features

• Performance: Instant startup and negligible memory footprint (vs 100MB+ Electron apps).
• Keyboard-Centric: Optimized for efficiency; navigate and query without a mouse.
• Local & Private 100% offline SQLite storage with no telemetry or cloud dependencies.
• Cross-Platform: Native support for Linux, macOS, and Windows.

Download

Dora is natively available for Linux, macOS, and Windows. Pre-compiled binaries are available through the releases page.

Latest Release: v0.0.95

Features: Expanded packaging targets (.rpm, .msi, Intel macOS build support), plus changelog popover stability and UX fixes.

Download by Platform

• Linux

  • .deb - Debian/Ubuntu (recommended for apt-based systems)
  • .AppImage - Universal Linux executable (works on most distributions)
  • .rpm - Red Hat/Fedora/CentOS (for rpm-based systems)

• macOS

  • .dmg - macOS installer (Intel & Apple Silicon support)

• Windows

  • .exe - Windows installer (recommended)
  • .msi - Alternative Windows installer option

👉 Download Latest Release

Installation by Platform

Linux (Debian/Ubuntu)

# Using .deb package
sudo dpkg -i dora_0.0.95_amd64.deb
dora

# Or using AppImage
chmod +x dora_0.0.95_x64.AppImage
./dora_0.0.95_x64.AppImage

macOS

# Download and mount the .dmg file, then drag Dora to Applications
# Or use Homebrew (if available)

Windows

Download the .exe installer and run it, or extract the portable version.

Development & Building

Option 1: The Dora CLI (Recommended)

Dora comes with a custom CLI tool to manage builds, releases, and databases. It is a single binary that works on any OS without any prerequisites. If you want to rebuild, or modify the CLI however you will need to have Go installed.

1. Running the CLI

   // in the root directory
   ./dora

   This opens an interactive menu to Run the app, Build artifacts, Generate release notes, or Manage your DB.

   Example Output:

   ╭───────────────────────────────────────────────╮
   │  DORA DEVELOPMENT CONSOLE           v0.0.9    │
   ╰───────────────────────────────────────────────╯
   > Run all
     Run app...
     Build all
     Build specific platform...
     Run compiled builds...
     Install Build (.deb)...
     Uninstall Dora...
     Reinstall Build (.deb)...
     Check Build Sizes
     Database Management...
     ─────────────────────────
     Release Notes...
     AI Setup...
     Update/Rebuild Runner
     ─────────────────────────
     Visit GitHub Repo
     Go to Releases
   
   [↑/↓] Move • [Enter] Select • [Esc] Back • [q] Quit
   

2. Build the CLI Only needed if you want to modify the CLI bash cd tools/dora-cli go build -o ../../dora . # Outputs binary named 'dora' to root cd ../.. This will output a binary named 'dora' to the root directory.

Option 2: Manual Setup

If you prefer standard tools, you can run Dora directly. I recommend Bun (or pnpm).

# Install dependencies
bun install

# Run web view (No database connection, purely frontned mock view stored in memory)
bun run dev

# Run Desktop App (Dev Mode)
# Use the workspace helper so the Windows tooling runs: `bun run desktop:dev`

# Build React (Vite / Rolldown)
bun run build

# Build for Production
bun run tauri build

Features (Early Beta)

Dora is in active development. Below is a list of implemented features available in the current build.

Category	Feature	Status	Description
Connectivity	Connection Manager	Done	Save, pin, and organize database connections.
	SSH Tunneling	Done	Securely connect via SSH tunnels with key support.
	History	Done	Track recent connections for quick access.
	Docker Manager	Beta	Manage containers, view logs, and auto-compose DBs.
Data Studio	Spreadsheet View	Done	Multi-cell selection, drag-select for rows/cols.
	Context Menu	Done	Right-click to duplicate, delete, or export (JSON/CSV/SQL).
	Mutation History	Done	Local undo/redo stack for data changes.
	Soft Delete	Done	Mark rows as deleted without removal (recoverable).
Querying	Drizzle Query Runner	Done	Custom Drizzle LSP for flawless autocompletion.
	Performance Stats	Done	Accurate query duration and execution timing.
	Snippets	WIP	Save/Delete scripts (Creation logic WIP).
	Visual Builder	WIP	Drag-and-drop query building (In Progress).
Schema	Schema Export	Done	Export schema as SQL or Drizzle ORM definitions.
	Inspector	Done	View tables, keys, indices, and DDL.
Tools	Command Palette	Done	Keyboard-driven command menu (Ctrl/Cmd + K).
	Custom Shortcuts	WIP	Module ready, remapper UI under construction.
UI/UX	URL State	Done	Deep linking for selected rows, cells, and active tables.
	Sidebar	Done	Collapsible, animated sidebar with unified navigation.
	Theme Sync	Done	Seamless dark/light mode synchronization across windows.

Roadmap & Under Construction

Feature	Status	details
Microsoft SQL Server	WIP	Initial implementation started.
Prisma Support	Planned	Full LSP Query Runner, Snippets, and Schema Visualizer.
Schema Converters	Planned	Two-way conversion between Prisma <=> Drizzle schemas.
AI Schema Gen	Planned	AI-assisted schema creation and migration generation.
NoSQL Support	Planned	MongoDB, Firebase (Planned).
Cloud Providers	Planned	Amazon RDS, Azure, Cloudflare D1.
Detailed Metrics	WIP	Database size, table stats, detailed storage analysis.
Snippet Folders	Planned	Organizing scripts into folders (File system/Storage).

Legend: Done | WIP (Work in Progress) | Planned

License

This project is licensed under the GNU General Public License v3.0 (GPL-3). See the LICENSE file for details.

ignore this https://svg-sparkle-clean.lovable.app/