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

SQL Console

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

Charts

Turn query results into bar, line, area, pie, or scatter charts without leaving Dora.

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

Schema Visualizer

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

The Schema Visualizer draws your database as an interactive entity-relationship diagram. Open it from the sidebar.

What it shows

Each table is a card listing its columns with type and primary-key / foreign-key badges. Foreign keys are drawn as directed edges between tables, labelled with their cardinality (1:1, 1:N) and the columns involved.

Interact

  • Drag tables to rearrange them; the layout is saved per connection.
  • Click a table to open the details panel with its columns, indexes, and one-click SQL DDL or Drizzle export, plus an Open in Studio button to jump to the data.
  • Search with the bar at the top. Plain text highlights matching tables and dims the rest; you can also use tokens like table:users, column:email, type:uuid, schema:public, pk, fk, nullable, and index.
  • Fit to view, toggle the minimap, and toggle edit mode from the toolbar.

Export the diagram

From the toolbar's export menu you can save the schema as JSON, an SVG or PNG image, SQL DDL (CREATE TABLE statements), or Drizzle ORM code, handy for documentation or for bootstrapping a schema file.

SQL Console

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

Charts

Turn query results into bar, line, area, pie, or scatter charts without leaving Dora.

On this page

What it showsInteractExport the diagram