Dory

Dory is an AI-native SQL client for humans and agents.

Query databases, explore schemas, visualize results, and turn agent database work into editable SQL workspaces.

Dory combines a familiar SQL workspace with AI assistance and MCP support. You can write SQL manually, ask AI to help with queries, or let external agents like Claude and Codex explore your database through Dory MCP.

Unlike a plain database MCP server, Dory does not just return query results back to a chat. It records the SQL, results, tabs, and charts generated by agents, so you can open the work as a real workspace, verify it, edit it, and continue the analysis.

🚀 Try Live Demo   •   🍺 Install via Homebrew   •   🍎 Download for macOS   •   Download for Windows   •   📦 Quick Start   •   🏠 Self-Hosting   •   🤝 Contributing   •   ⭐ Star

No signup required. Click "Enter as Demo" to start instantly.

👇 Live Playground: https://app.getdory.dev

🚀 Quick Start

Install on macOS with Homebrew

brew install dorylab/dory/dory

Run with Docker

Make sure Docker is installed, then run:

docker run -d --name dory \
  -p 3000:3000 \
  -e DS_SECRET_KEY="$(openssl rand -base64 32 | tr -d '\n')" \
  -e BETTER_AUTH_SECRET="$(openssl rand -hex 32)" \
  -e BETTER_AUTH_URL="http://localhost:3000" \
  -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 \
  -e NEXT_PUBLIC_REQUIRE_EMAIL_VERIFICATION=false \
  -e DORY_INIT_USER_EMAIL=admin@getdory.dev \
  -e DORY_INIT_USER_PASSWORD=admin \
  dorylab/dory:latest

Then:

Username: admin@getdory.dev

Password: admin

The initial administrator account is controlled by DORY_INIT_USER_EMAIL and DORY_INIT_USER_PASSWORD in .env.

To enable email verification, set RESEND_API_KEY to a valid resend key and EMAIL_FROM to a validated email.

Self-host with Docker Compose

For long-running self-hosted deployments, Docker Compose runs Dory with a dedicated PostgreSQL database and persistent volumes.

cp docker-compose.env.example .env
# Edit .env and replace all placeholder secrets/passwords.
docker compose up -d

For comprehensive self-hosting documentation, environment variables, and deployment guides, see the Self-Hosting Documentation.

✨ Key Features

🧠 SQL Copilot

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.

---

⌨️ Schema-Aware Autocomplete

• SQL completion based on real database schema
• Suggests tables, columns, functions, and aliases
• Supports multi-table joins and subqueries

---

✍️ Intelligent SQL Editor

• Multi-tab SQL workspace with support for multiple result sets
• Save and organize frequently used queries
• AI-powered SQL Copilot for writing, explaining, and optimizing queries
• Instant query visualization with built-in charts

---

💬 Database Chatbot

• Built-in conversational AI assistant
• Automatically understands connected database schema
• Ask questions directly about tables and SQL
• Quickly locate field meanings and query ideas

---

🔗 Agent Access via MCP

• Desktop MCP endpoint for local agent clients
• No manual token copy/paste in the desktop app
• Supports schema discovery, saved queries, read-only SQL, table previews, monitoring summaries, and analysis tools

---

📈 ClickHouse Monitoring (Deep Integration)

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

---

🔐 ClickHouse Privileges (Deep Integration)

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 Support

Database	Status
ClickHouse	✅ Deeply integrated
PostgreSQL	✅ Supported
Neon	✅ Supported
MySQL	✅ Supported
MariaDB	✅ Supported
SQLite	✅ Supported
DuckDB	✅ Supported
SQL Server	✅ Supported
Oracle	✅ Supported
Snowflake	🚧 Planned

---

🧠 Supported AI Providers

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	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.

---

🔗 Desktop MCP

The Dory desktop app includes local MCP (Model Context Protocol) support, so agent clients can use your Dory connections without manually copying API tokens.

To enable it:

1. Open the Dory desktop app.
2. Go to Settings → Agent Access.
3. Turn on Enable.
4. Add the displayed local endpoint to your MCP client.

By default, desktop MCP runs at:

http://127.0.0.1:3318/api/mcp

For Codex CLI:

codex mcp add dory --url http://127.0.0.1:3318/api/mcp
codex mcp list

For Claude Code:

claude mcp add --transport http dory http://127.0.0.1:3318/api/mcp
claude mcp list

Dory manages the desktop MCP grant automatically. The local MCP endpoint can list connections, inspect schemas, read saved queries, preview tables, run read-only SQL, and build analysis context for connected databases.

---

🗺️ Roadmap

See the latest roadmap here:

Dory Roadmap

---

⚙️ Tech Stack

• Next.js + React + Tailwind
• Drizzle ORM
• Multi-model AI SDK integration
• PGLite
• Resend
• Shadcn UI
• Monaco Editor

---

🎯 Who is it for?

• Data engineers
• Data analysts
• Database platform teams
• ClickHouse operations teams

---

Your data stays yours. Except for AI requests sent through Cloudflare Gateway, everything — connections, tabs, and saved queries — is stored locally on your device.

📄 License

Apache-2.0