SQL Console
The SQL Console is Dory's core workspace for writing and running queries.
What it includes
- Multi-tab SQL editing.
- Schema-aware autocomplete.
- Support for multiple result sets.
- AI actions for generating, rewriting, and explaining SQL.
- Built-in chart generation from query results.
Why it matters
Dory is not just a query runner. The editor is designed to keep schema context, results, and AI-assisted iteration in one place so you do not have to bounce between separate tools.
Typical workflow
- Open a connection.
- Start from natural language with AI, or write SQL directly.
- Inspect the result grid.
- Save the query if it will be reused.
- Turn the result into a chart when the output is easier to read visually.
Current expectations
The public copy emphasizes read-heavy analytics and SQL authoring workflows. Do not assume AI actions will safely generate operational DML for you without review.