AI Assistant settings

Use this page to configure the general behavior of AI in Team Edition.

AI Assistant setup

Note

AI Assistant is turned on by default. If it was disabled earlier, you can re-enable it in Window -> Preferences -> General -> AI by selecting Enable AI integration.

To activate AI Assistant, open Window -> Preferences -> General -> AI and select your provider from the Service dropdown menu. Next, set up your provider.

Chat Settings

For configuring AI Chat settings, navigate to Window -> Preferences -> General -> AI -> Chat Settings.

Setting	Description	Default
Use stream mode	Enables data to load and display progressively as it’s received from the server, instead of waiting for the entire response. This improves responsiveness and reduces memory usage when working with large result sets. Available only if supported by the selected AI provider.	on
Days to keep chats	Sets how many days chat history is stored locally. Older chats will be deleted automatically.	7
Silence threshold	Defines the minimum sound level that’s considered speech. Lower values make recognition more sensitive to quiet voices, but may include background noise.	0.3%
Silence timeout	Sets how long to wait (in seconds) after silence before ending the transcription.	20 sec
Audio max duration	Limits the maximum length of recorded audio for transcription. Longer recordings are automatically trimmed.	60 sec

Important

If you add filters in the Database Navigator, only the filtered tables are sent to the AI. The same applies in the Data Editor — if you filter tables, they won’t appear in completion or be validated correctly in queries, because if they’re not in the navigator, there’s no metadata about them.

AI Configuration

For configuring specific settings, navigate to Window -> Preferences -> General -> AI -> Configuration.

General

Setting	Description	Default
Language	Choose the language for AI responses. This affects the language used in answers, explanations, and code comments.	English

Info

Besides the listed options, you can also type in a language that's not included in the dropdown menu.

SQL Completion

Setting	Description	Default
Include source in query comment	Shows your original request above the AI-generated query in the SQL Editor.	Off
Execute SQL immediately	Runs the translated SQL query immediately after generation.	Off

AI query execution

These settings control how AI-generated SQL queries are executed. You can choose to run them immediately, show a confirmation prompt, or disable autocommit so changes must be committed manually.

Setting	Description	Options	Default
Select	Controls execution of SELECT queries.	- Execute immediately - run SELECT queries without confirmation. - Show confirmation - ask for confirmation before executing.	Execute immediately
Modify	Controls execution of data modification queries (INSERT, DELETE, UPDATE).	- Execute immediately - run modification queries without confirmation. - Show confirmation - ask for confirmation before executing. - Disable autocommit - turn off autocommit so changes require manual commit.	Show confirmation
Schema	Controls execution of schema modification queries (CREATE, DROP, ALTER, etc.).	- Execute immediately - run schema modification queries without confirmation. - Show confirmation - ask for confirmation before executing.	Show confirmation
Other	Controls execution of queries Team Edition cannot classify as valid SQL (including NoSQL queries).	- Execute immediately - run unknown or unclassified queries without confirmation. - Show confirmation - ask before executing queries not recognized as SQL.	Show confirmation

Tip

For the AI command, using Show confirmation is strongly recommended. It lets you preview the generated SQL in a dialog before execution, so you can review or cancel risky changes.

Send database structure

Setting	Description	Default
Send column data type information	Sends column data types (like INT, VARCHAR, etc.) to the AI provider. Improves completion quality, but consumes more tokens.	On
Send object description	Sends object description to the AI provider. Improves completion, but may consume significant amount of tokens.	Off

Automatic prompt reduction

When sending database metadata and sample data to the AI provider, the amount of information is limited by the selected context size. If the content exceeds this limit, Team Edition automatically shortens the prompt in two steps:

1. Removes extra details (data types, keys, constraints, sample data) if all are enabled and the size is too large.
2. If it’s still too large, trims the snapshot until it fits the context limit.

Functions

Available since 25.3

Configure callable AI functions in Window -> Preferences -> General -> AI -> Functions.

Use this page to control which actions the AI Assistant can perform automatically. When a function is enabled, the assistant can trigger internal operations like exporting data, comparing schemas, opening editors, or navigating the interface.

Available functions

Enable or disable individual functions within each category. Disabled functions are ignored even if your prompt matches the action.

Data transfer actions

These functions let AI Assistant work with data movement, comparison, and export.

Function	Description
Compare data	Opens the Data Compare wizard to analyze differences between tables or databases.
Compare schemas	Opens the Schema Compare wizard to compare database structures.
Export query results to a file	Exports query results to a file using the Data Transfer wizard.
Export table data to a file	Exports selected tables to a file using the Data Transfer wizard.
Import data	Opens the Data Transfer wizard to import data from external files into selected tables.
Transfer data between tables	Copies data from one table to another using the Data Transfer wizard.

Advanced metadata read

This function lets AI Assistant read a small amount of table metadata or sample rows to improve query generation and mapping.

Function	Description
Read table sample rows	Reads several rows from a table so the assistant can understand the structure and generate more accurate queries or mappings.

Note

If you don’t enable these functions, Team Edition won’t send any table data (sample rows) to the AI. To share only structure metadata (table and column names), see Send database structure.

View and editor actions

These functions let AI Assistant interact with the interface, open and close views, and manage editors or connections.

Function	Description
Close editor	Closes the selected editor tab.
Close view	Closes the selected view panel.
Create new connection	Opens the New Connection wizard.
Open database object editor	Opens an editor for a supported database object.
Open SQL Editor	Opens a new SQL Editor tab.
Open view	Opens a specific view by its identifier (For example, Bookmarks).

Prompts

Available since 26.0

Use this page to customize the built-in instructions that Team Edition sends to the AI provider for specific features. These instructions are applied automatically when you use the related AI feature.

Open it in Window -> Preferences -> General -> AI -> Prompts.

Note

User-defined instructions are added on top of default instructions. Default instructions can’t be changed.

Prompt	What it affects
Analyze Data Compare results	Explains differences found in Data Compare results.
Describe database objects	Returns detailed database object description and its role in the database schema.
Explain SQL queries	Explains the structure and business value of the SQL query, including involved entities and relationships.
Explain SQL query execution plan	Explains the SQL query execution plan and helps understand how the database runs the query.
Fix SQL query errors	Fixes SQL query errors using the query text, the error message, and environment information.
SQL query completion	Performs SQL query completion based on the query, comments, and surrounding queries.
SQL query generation	Generates SQL queries from a natural language description.
Smart mapping	Finds the closest matching data types when converting columns between source and target databases.