Dory Documentation

Dory is an AI-native data workspace for modern databases. It brings schema-aware SQL Console, conversational AI, Database Explorer, result analysis, and charting into one workspace so you can move faster from question to execution to insight.

5-Minute Quick Start

1. Install Dory with the desktop app, Homebrew, or Docker.
2. Create or open a workspace.
3. Add a database connection.
4. Browse schemas in Explorer.
5. Write SQL in SQL Console, or ask AI to generate the first query.

What You Can Do with Dory

• Browse database schemas, tables, columns, and sample data.
• Write, run, debug, and optimize SQL.
• Use AI Chat to generate SQL, explain queries, fix errors, and continue analysis.
• Turn query results into charts and reusable analysis.
• Save common queries and share them with a team.
• Use ClickHouse-specific monitoring, privileges, and operational views.
• Connect external AI agents through MCP.

Recommended Reading Order

1. Start with Quick Start.
2. Read Connect Your Database.
3. Learn SQL Console and AI Chat.
4. Review Deployment before rolling Dory out to a team.

Supported Databases and AI Providers

Dory currently focuses on:

• ClickHouse with deep operational integration.
• PostgreSQL, Neon, MySQL, MariaDB, SQLite, DuckDB, and MotherDuck.
• OpenAI, OpenAI-compatible providers, Anthropic, Google, Qwen, and xAI.

Why Dory

Dory is built for people who work with real database structures every day. Instead of treating AI as a standalone chat box, Dory connects AI assistance to schema context, SQL execution, result review, and reusable workflows.

Version Updates

See Release Notes for recent product changes and documented capabilities.