AI Assistant
The assistant is a chat interface backed by a language model with access to your connected DuckDB database. It can run SQL queries, render results as tables or charts, and update open relation tabs.
Open the Assistant tab from the sidebar to start a conversation.
Capabilities
SQL execution
The assistant executes SQL against your DuckDB database as a tool call. It will query information_schema to find relevant tables and columns before writing a query. Results over 200 rows are truncated; use LIMIT/OFFSET to page if needed.
Tables and charts
Results can be rendered as a table or a chart (bar, line, pie) directly in the chat. You can ask it to adjust the chart type, axes, or row limit after the fact.
Targeting open tabs
By default output appears inline in the chat. You can also point the assistant at an open relation tab by name — it will read the tab's current query and view state first, then update it in place.
Providers
Configure the active provider and model in Settings → Assistant. The status indicator shows whether the current configuration can reach the model.
OpenAI
Requires an API key. Configurable via NEXT_PUBLIC_OPENAI_API_KEY or in Settings.
| Model | |
|---|---|
| GPT-4.1 | Default |
| GPT-4.1 Nano | |
| GPT-4 | |
| GPT-3.5 Turbo | |
| Custom | Any model ID |
Ollama
Runs locally. No API key required. Requires Ollama running at the configured endpoint (default: http://localhost:11434/api).
| Model | |
|---|---|
| Qwen3 8B | Default |
| Llama3 8B | |
| Llama3 70B | |
| Mistral 7B | |
| Custom | Any pulled model |
Download a model with ollama pull <model-name> before use.
Deepseek
Requires an API key. Configurable via NEXT_PUBLIC_DEEPSEEK_API_KEY or in Settings. The API endpoint can be overridden (e.g. for a proxy).
| Model | |
|---|---|
| deepseek-chat | Default |
| deepseek-reasoner | |
| Custom | Any model ID |
Canvas nodes (planned)
Canvas node support is not yet implemented. When added, the assistant will be able to create and update nodes on the canvas directly — including setting the SQL query, view type, and node connections.