Dory Docs
Workflows

Generate SQL with AI

AI is strongest when you provide a concrete question, relevant tables, and the output shape you expect.

Prompt template

  • Goal: what question are you answering?
  • Tables: which objects should be used?
  • Filters: what time range or conditions matter?
  • Output: what columns should be returned?

Explore Unknown Tables

A practical workflow for understanding unfamiliar schemas.

Debug Slow Queries

A repeatable workflow for isolating expensive SQL patterns.

On this page

Generate SQL with AIPrompt template