Dory Usage Guide
This guide follows the typical path from opening Dory to completing reusable database analysis.
1. Enter Dory
Open Dory through the desktop app, online demo, or self-hosted deployment.
2. Create or Select a Workspace
Use workspaces to separate projects, teams, environments, or customers. Keep production and development databases in clearly named workspaces when possible.
3. Add a Database Connection
Choose the database type and fill in the connection settings. Test the connection before continuing.
| Connection Type | Typical Use |
|---|---|
| ClickHouse | Analytics, observability, event data, and operational monitoring |
| PostgreSQL / Neon | Application data and product analytics |
| MySQL / MariaDB | Business systems and application databases |
| SQLite | Local files, demos, prototypes, and small datasets |
| DuckDB / MotherDuck | Local analytics and file-based analysis |
4. Browse Database Structure
Open Explorer to inspect databases, schemas, tables, columns, and sample rows. This step helps you understand the data before writing SQL.
5. Write and Run SQL in SQL Console
Use SQL Console for query tabs, execution, result review, and saved queries. Start with safe previews and add filters or aggregations gradually.
6. Use AI for Analysis
AI Chat can help you:
- Generate SQL from a natural-language request.
- Explain a query or a table.
- Fix SQL errors.
- Optimize slow SQL.
- Continue analysis based on previous results.
Always review AI-generated SQL before execution.
7. Review Results and Generate Charts
After a query runs, inspect the result table. If the result is chart-friendly, create a chart directly from the result.
8. Save and Reuse Queries
Save useful queries with clear names and descriptions. Saved Queries are best for recurring analysis, common operational checks, and team knowledge.
9. Use ClickHouse-Specific Capabilities
For ClickHouse connections, Dory can expose monitoring, query logs, slow queries, error queries, cluster operations, and privilege-related workflows when the connected user has permission.
10. Connect External AI Agents
Use MCP / Agent Access when you want tools such as Codex or Claude to inspect Dory context and perform controlled database-assistant workflows.