Overview
Dory's main workspace includes SQL Console, AI Chat, Explorer, result charts, connection management, and Saved Queries.
Feature Map
| Feature | Use it for |
|---|---|
| SQL Console | Write, run, debug, and save SQL with schema context. |
| AI Chat | Generate SQL, explain queries, fix errors, and continue analysis with database context. |
| Explorer | Inspect databases, schemas, tables, columns, sample rows, and object details. |
| Charts & Results | Review result tables and turn chart-ready SQL output into visual summaries. |
| Saved Queries | Save useful SQL and reusable analysis for yourself or a team. |
| Connections | Manage database connection settings and local file paths. |
| Monitoring | Inspect ClickHouse query activity, slow queries, errors, and operational signals. |
| Privileges | Manage ClickHouse users, roles, permissions, and cluster-aware grants. |
Common Tasks
- Explore an unfamiliar table: Explore Unknown Tables
- Draft SQL with Ask AI: Generate SQL with Ask AI
- Build a chart from results: Build Charts from SQL
How is this guide?