SQL Console

The SQL Console is where most analysis starts. Dory uses live schema information to improve autocomplete, reduce query mistakes, and speed up iteration.

What it is good for

• Writing ad hoc analysis queries.
• Validating table and column names with autocomplete.
• Iterating quickly between edits and result checks.
• Working with AI on the current query context.

Typical workflow

1. Choose the active connection.
2. Open a new query tab.
3. Write or paste SQL.
4. Run the query and inspect results.
5. Save the query if it is worth reusing.