- Generate a new query using natural language instructions.
- Edit an existing query using natural language instructions.
- Explain an existing query and add comments.
- Fix errors in an existing query.
Generate a query
When your query is empty, the AI operates in generate mode and can write you a query using plain English.
Click Ask AI to open a text field and make your request.
Edit a query
If you have a query already, Retool's AI operates in edit mode and can modify the existing query. Click the Ask AI icon to open a text field and make your request.
Explain a query
For existing queries, you can also set Retool's AI to operate in explain mode, which describes the functionality of the existing query by adding a comment.
Click the Ask AI icon and select Edit > Explain to add a comment to the query.
Fix a query
If a query fails to run, click Run error detected. Debug? to have Ask AI debug the query and suggest a fix. Ask AI uses context about the query, schema, and the error message. It can then explain the problem and provide a possible fix.