Dory is an AI-native SQL workspace for modern databases.
The AI-powered Data Studio you’ve been waiting for.
It combines intelligent SQL editing, context-aware AI assistance, conversational database exploration, and deep operational integration across modern databases into a single unified workspace — helping engineers and analysts write, understand, and manage data more efficiently.
Make sure Docker is installed, then run:
docker run -d --name dory \
-p 3000:3000 \
-e TRUSTED_ORIGINS="http://localhost:3000" \
-e DS_SECRET_KEY="$(openssl rand -base64 32 | tr -d '\n')" \
-e BETTER_AUTH_SECRET="$(openssl rand -hex 32)" \
-e DORY_AI_PROVIDER=openai \
-e DORY_AI_MODEL=gpt-4o-mini \
-e DORY_AI_API_KEY=your_api_key_here \
-e DORY_AI_URL=https://api.openai.com/v1 \
dorylab/dory:latest
Dory is built with a pluggable AI provider architecture. You can freely switch between different model vendors by changing environment variables — no code changes required.
Currently supported providers:
| Provider | Env DORY_AI_PROVIDER |
Description |
|---|---|---|
| OpenAI | openai |
Default provider. Uses official OpenAI API. |
| OpenAI-Compatible | openai-compatible |
Any service exposing an OpenAI-compatible API. |
| Anthropic | anthropic |
Claude models via Anthropic official API. |
google |
Gemini models via Google Generative AI API. | |
| Qwen (Alibaba) | qwen |
Qwen models via DashScope OpenAI-compatible endpoint. |
| xAI | xai |
Grok models via xAI API. |
An AI assistant grounded in real database schema and current query context.
- Ask — Generate SQL from natural language
- Action — Fix or rewrite the current SQL
- Context — Explain query logic and field semantics
AI that understands your database — not just text completion.
- SQL completion based on real database schema
- Suggests tables, columns, functions, and aliases
- Supports multi-table joins and subqueries
- Multi-tab SQL editing and execution
- Saved frequently used queries
- Deep integration with SQL Copilot
- Built-in conversational AI assistant
- Automatically understands connected database schema
- Ask questions directly about tables and SQL
- Quickly locate field meanings and query ideas
A native observability interface designed specifically for ClickHouse.
- Real-time metrics:
- Total queries
- Slow queries
- Error queries
- Active users
- Query latency trends (P50 / P95)
- Query throughput trends (QPM)
- Multi-dimensional filtering:
- User
- Database
- Query type
- Time range
Native ClickHouse user and role management UI.
- Create, edit, and delete database users
- Create roles and configure grant relationships
- Configure:
- Login username and password
- Allowed host addresses
- Granted roles and default roles
- Supports cluster-level privilege operations (On Cluster)
- No need to manually write GRANT / CREATE USER SQL
| Database | Status |
|---|---|
| ClickHouse | ✅ Deeply integrated |
| PostgreSQL | 🚧 In development |
| MySQL | 🚧 Planned |
| DuckDB | 🚧 Planned |
| SQLite | 🚧 Planned |
- Next.js + React
- Drizzle ORM
- Multi-model AI SDK integration
- Data engineers
- Data analysts
- Database platform teams
- ClickHouse operations teams
Docker one-click deployment coming soon
Desktop client (Mac) coming soon
Apache-2.0