AI assistant

The AI assistant is a conversational helper inside the query editor. It can answer questions about the schema, write and refine SQL from a plain-language request, and offer to run what is in the editor.

When to use

Use it while you are composing a query, to generate SQL from a description, improve a query you have, or understand an unfamiliar schema.

Using it

1. Open the assistant from the editor's view toggle (Ask AI to write SQL). You can dock it to the side or the bottom.
2. Type a request in Message the assistant… and press Enter (Shift+Enter for a new line).
3. When the assistant proposes a query, it goes straight into the editor (or appears read-only if you cannot edit the query). When it wants to run something, a Run this query? bar appears. Nothing runs until you confirm through the normal run flow.

Setup and access

• Enable it (admin). Under Admin → AI settings, save an Anthropic API key (write-only, never shown again once saved). The model in use is displayed for reference.
• Plan gating. The assistant is a paid feature gated on the AI assistant entitlement. Without it, the editor still shows the entry point but locked, and opening it shows an upgrade prompt, The AI query assistant is a paid feature, with a View plans button.
• Per-user access. Even when the feature is on, a user only sees the assistant if an admin has granted them May use the AI assistant.