Ask questions about your data in plain English and the assistant writes the SQL for you-right inside the Data Preview panel, using the file you already have open.
Open any file in the Data Preview workspace and click AI SQL Assistant in the toolbar to bring up a prompt box. Describe what you want in plain language-for example, "Show me the top 10 products by sales"-and the assistant generates a SQL query against the table you have open. You can either create a brand new table from the result or modify the one you're currently viewing.
The assistant lives in the same toolbar as Apply Template and Charts, so it's always one click away while you're reviewing a file.
Before you write a prompt, choose whether the result should become a separate table or update the one you're already viewing.
If you're not sure which to pick, start with Create New. You can always delete the extra table afterward, but Modify Current changes your working table right away.
The model selector in the top-right of the assistant panel controls which AI model generates the SQL for you.
If a generated query doesn't look right, try switching models before rewriting your prompt-different models can interpret the same request differently.
Type your request in the prompt box and click Generate to turn it into SQL.
The assistant only queries tables listed under Available Tables at the bottom of the panel-usually the file you currently have open.
If you need help writing prompts, choosing a model, or troubleshooting a generated query, our support team is here to help.
Contact Support