AI Chat
Dory includes a conversational AI assistant that is intended to understand your connected database, not just a blank text prompt.
What AI Chat is good for
- Generate SQL from natural language.
- Explain existing queries.
- Clarify table and field meaning.
- Suggest query directions when you are exploring unfamiliar data.
Why it is different from generic chat
The product messaging and codebase both emphasize schema grounding. That means the assistant is designed to work with real table and column context from the active connection.
Practical usage pattern
- Connect the database first.
- Keep the relevant connection active while chatting.
- Treat AI output as a draft that should be reviewed before running in production.
Current limitation
AI quality depends on:
- The selected provider and model.
- The available schema metadata.
- The clarity of your prompt and current query context.
Provider setup is covered in AI Providers.