01Ask
Ask anything. No made-up columns.
Schema-aware autocomplete and SQL generation keep the AI honest — every suggestion is based on real tables, real fields, and real joins.
AI-native Data Studio
Connect databases and use SQL, AI, and visualization to explore, analyze, and reuse.
Dory workspace
Query databases, understand tables, and talk to data - All in One modern workspace.
AI copilot
Generate SQL and explain results from the current connection, schema, and query context.
SQL workbench
Keep the editor, schema browser, query results, and execution history in one workflow.
Save & reuse
Save useful queries and result context so one-off exploration becomes a reusable workflow.
AI-native workflow
Ask. Act. Stay grounded.
No context switching. No hallucinated fields. Just accurate SQL and real results.
02Actions
Do more than chat — take action.
Run transformations, save and share queries, and trigger common analytics tasks right from the workflow — no copy-paste, no tab hopping.
03Context
Context that keeps you in control.
Dory tracks what you’re working on — tables, relationships, and recent queries — so results stay consistent across Ask, Action, and Context.
Core workspace
Built for real SQL work — not just chat.
A fast editor, a trustworthy schema view, and saved work you can reuse — the foundation of daily data work.
Dory workspace
SQL Editor that feels native
Fast, keyboard-first editing with schema-aware autocomplete — so you can write correct SQL without breaking flow.
Schema Explorer you can trust
Browse tables, columns, and types in context — the same grounding the AI uses to avoid hallucinated fields.
Saved Queries & Results
Turn one-off exploration into a workflow. Save, revisit, and share the queries that matter.
Schema-aware autocomplete with syntax guidance.
Multi-tab, multi-result-set query workflows.
High-performance result grids with sorting, filtering, and fast navigation.
Designed for large data volumes and complex analytics.
AI Table Overview
Auto table intelligence that frames every column and distribution.
Automatically generates table-level overviews, semantic annotations, and usage cues so AI understands business data before it writes SQL.
Dory workspace
Database chat
Chat with Your Database
Dory’s Chatbot is not a generic AI assistant. It’s a database-native copilot that understands your schema, writes real SQL, and helps you explore data through conversation.
Dory workspace
DATABASE SUPPORT
Connect the data stack you already use.
Supports PostgreSQL, MySQL, SQL Server, Oracle, SQLite, MariaDB, DuckDB, and ClickHouse. A modern workspace for querying, exploring, and analyzing your data.
ClickHouse
PostgreSQL
MySQL
SQL Server
Oracle
SQLite
MariaDB
DuckDB
More
⭐ Advanced Experience for ClickHouse
Deep schema support
Query analytics dashboard
Team-ready workspace
More features
SQL workspace designed for everyday data work
Local-first, responsive
Local-first security
Queries, personal settings, and workflows stay on your computer so privacy and control never leave your hands.
SSH Tunneling
SSH tunnels wrap every connection in strong encryption, so your credentials, queries, and data never leave your network in plain text.
Save Queries & Workflows
Save queries, context, and results so you can rerun and build on work again and again.
Modern experience
A clean, restrained interface that keeps you immersed in the rhythm of your work.
Bright / Dark & Multi Themes
Light, dark, and multiple accent themes adapt to your environment while keeping the visuals readable and comfortable.
Open Source
Apache 2.0 licensed, extensible, and ready for self-hosting.
FAQ
Questions and Answers
Is Dory free to use?
Yes. Dory provides a free version that you can use for personal projects and local workflows.
How does the AI Copilot work?
Dory’s AI Copilot understands your database schema, tables, and query context to help generate SQL, explain queries, and explore data faster.
What databases does Dory support?
Dory currently supports ClickHouse, PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite, and DuckDB, with a deeply integrated experience for ClickHouse.
Is my data safe?
Dory follows a local-first philosophy. Your connections and workspace metadata can stay on your machine when using the desktop version.
Try Dory in minutes
Start now
Download Dory now, or deploy it locally with Docker and connect it to your real database.