AI chat

Note

This feature is available in Lite, Enterprise, Ultimate and Team editions only.

To use the AI Chat:

1. Activate the AI assistant.
2. Open the SQL Editor.
3. Click on the AI Chat tab , located on the right toolbar of the SQL Editor.
4. In the chat window that opens, input your request in natural language.
5. Press the Send button to get the SQL translation.
6. To execute the SQL query generated by AI, click the Execute SQL query button.

Info

The AI Chat logs your query history, enabling you to reference and expand on prior inputs. Each new or edited entry prompts the AI to generate a revised SQL query.

Resetting query context

To start a new conversation or to change the query context in the AI Chat, you can use one of the two reset options available:

• To clear the entire history, use the reset button located next to the Save button.
• To clear a portion of the conversation history up to a chosen point, use the reset option within the AI Chat itself, located at the end of each user's input prompt.

Defining the scope in AI Chat

For enhanced precision, especially in databases with extensive schemas, you can specify database objects in the Scope field to narrow down the context.

1. In the AI Chat interface, click on the arrow near the Change scope button to open the context menu.
2. Specify the area of your database that the AI should concentrate on.

3. You can choose from:

   • Current Schema: Focuses the AI on the schema you are currently using.
   • Current Database: Limits the AI to the database currently selected.
   • Connection: Sets the AI to consider all schemas within the current database connection.
   • Custom: Allows you to define a more specific scope, such as a particular table or schema.