Guides
Loading documentation…
Preparing this guide.
Loading page content
Generate, explain, and fix SQL with Groq, OpenAI, Anthropic, Gemini, or a local Ollama model, with your keys encrypted at rest.
Dora's AI assistant helps you write SQL from a description, explain an existing query, fix an error, or suggest indexes, with the connected schema as context. It works with a hosted provider (with an API key) or a fully local model.
| Provider | Needs an API key? | Runs locally? |
|---|---|---|
| Groq | Yes | No |
| OpenAI | Yes | No |
| Anthropic | Yes | No |
| Gemini | Yes | No |
| Ollama | No | Yes |
Groq is the default, using llama-3.3-70b-versatile, which is fast and has a generous
free tier.
Open Sidebar → AI keys, pick a provider, and add a key. You can name a key, Test it, and choose a model. Alternatively, set the matching environment variable before launching Dora and it is picked up automatically (a key saved in the app takes precedence):
| Provider | Environment variable |
|---|---|
| Groq | GROQ_API_KEY |
| OpenAI | OPENAI_API_KEY |
| Anthropic | ANTHROPIC_API_KEY |
| Gemini | GEMINI_API_KEY |
Ollama runs models on your machine: no API key, and no data leaves your computer.
ollama pull llama3.2.llama3.2.Dora's built-in Ollama manager shows whether the server is running, lists and pulls models with live progress, and removes models you no longer need.
From the SQL Console or Data Studio, open the assistant and ask it to: