⚠️ Troubleshooting

Query Playground

Why are my SQL query results inaccurate?

This can be a number of things. Let's take a look at some of them:

• The proper database has not been selected. Selecting the database the query prompt is related to will help generate accurate results.
• The query type selected is incorrect. Selecting the query type for the query prompt as Create Query / Optimize Query / Suggest Indexes will help generate accurate results.
• The query prompt wording is not accurate. Using key action words and referring to the tables/fields the query prompt is related to will help generate accurate results.

Databases

Why do I get an error when importing my database schema?

The most common reason for an error when using the Import From Script option is due to the SQL code that has been pasted into the input being incorrectly formatted. AI Query looks for CREATE TABLE statements in the SQL code to decide how to create the tables and fields for the selected Database Type.

Ask the Community

If you didn't find a solution in any of the above mentioned sections or if you prefer to troubleshoot with the community, feel free to join our User Community (opens in a new tab). Other users might have come across the same issues, and the AI Query Community on Slack is very active and helpful.