Workflows
Dory Workflow Guides
Workflows document the most common analysis tasks in Dory. Each guide connects Connections, Explorer, SQL Console, AI Chat, Charts & Results, and Saved Queries into a repeatable process.
Recommended Workflows
| Workflow | Use case | Main features |
|---|---|---|
| Explore Unknown Tables | Understand unfamiliar schemas | Explorer, table preview, AI Chat |
| Generate SQL with AI | Turn business questions into SQL | AI Chat, SQL Console, schema context |
| Debug Slow Queries | Investigate expensive SQL | SQL Console, AI Chat, ClickHouse Monitoring |
| Build Charts from SQL | Shape query output for visualization | SQL Console, Charts & Results, AI |
| Save & Reuse Analysis | Preserve useful queries and team knowledge | Saved Queries, folders, descriptions |
Suggested Learning Path
- Explore schema with Explore Unknown Tables.
- Generate a first query with Generate SQL with AI.
- Run and refine the query in SQL Console.
- Debug performance with Debug Slow Queries.
- Visualize stable output with Build Charts from SQL.
- Save reusable work with Save & Reuse Analysis.
Quick Answer
Dory workflows help you move from unfamiliar data to reviewed SQL, chart-ready results, reusable analysis, and slow-query debugging without leaving the same workspace.