DORA
Features
Multi-DatabasePostgreSQL, MySQL, SQLite & libSQLQuery HistorySearch, replay and analyze every querySchema VisualizationLive ER diagrams of your relationshipsDocker ContainersSpin up and manage local databasesSSH TunnelingReach private databases through secure tunnelsORM CockpitDiff Drizzle/Prisma schema, preview migrationsThemingCustom look and feel for your workspaceAnalyticsQuery PostHog with HogQL, build dashboards
All features
ChangelogDORADocumentationView web app
Dora docs
Dora docsGetting StartedInstallation

Connect a database

Connections

Features

Features

Guides

Working with data

Data StudioSQL ConsoleSchema VisualizerChartsExportLive change monitoring

ORMs

ORM CockpitORM Runners

Productivity

Command Palette & shortcutsAI AssistantDocker Manager

Reference & internals

Credentials & securityMock Data GuideBackend Features Integration

Reference

API ReferenceShared TypesDora runner (Go CLI/TUI)
Guides

Loading documentation…

Preparing this guide.

Loading page content

Data Studio

Browse, filter, sort, edit, import, and export table data in Dora's spreadsheet-style grid.

Schema Visualizer

See your database as an entity-relationship diagram of tables, columns, and foreign-key relationships you can search, rearrange, and export.

Engineered by remco_stoeten
GitHub ProfileRepositoryFeaturesDocsChangelog
© 2026 Dora. All rights reserved.
Guides

SQL Console

Write SQL with schema-aware autocomplete, run full queries or selections, view and chart results, and reopen anything from history.

The SQL Console is a Monaco-based editor with SQL syntax highlighting and schema-aware autocomplete. Open it from the sidebar.

Write and run

As you type, Dora completes table names, column names (with type hints), SQL keywords, and aggregate functions from the connected schema, so users. offers the real columns.

  • Run the whole editor with Mod+Enter.
  • Run just the selection with Mod+Shift+Enter, useful when the editor holds several statements separated by semicolons.
  • Stop a long-running query from the toolbar while it executes.
  • Format the SQL with Mod+Shift+F.
  • Comment a line with Mod+/, and save the script with Mod+S.

Results

Results open in a table you can sort and filter by column. From there you can:

  • Copy a row as JSON or SQL from its context menu,
  • Chart the results, see Charts,
  • Export to CSV, JSON, or SQL, see Export.

Run an EXPLAIN / EXPLAIN ANALYZE query and Dora shows the query plan in a dedicated panel.

Query history

Press Mod+H to open history. Every query you run is recorded with a timestamp, a preview, its duration, and whether it succeeded. You can search history, group it by connection, pin queries you reuse, re-run any entry, and export or clear history.

Ask the AI

Open the assistant from the console to generate SQL from a description, explain the current query, or fix an error. See AI Assistant.

Prefer your ORM? The console can switch to a Drizzle mode, and Dora also has dedicated Drizzle and Prisma runners.

Data Studio

Browse, filter, sort, edit, import, and export table data in Dora's spreadsheet-style grid.

Schema Visualizer

See your database as an entity-relationship diagram of tables, columns, and foreign-key relationships you can search, rearrange, and export.

On this page

Write and runResultsQuery historyAsk the AI