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.
AI Chat configuration¶
For configuring AI Chat settings, navigate to Window -> Preferences -> General -> AI -> AI Chat.
| Setting | Description | Default |
|---|---|---|
| Send previous AI chat answers | Sends the assistant’s previous answers to the AI vendor. This can improve the quality of completions but consumes more tokens. Can be disabled unless the AI requires the full conversation context. | Off |
| Days to keep chats | Sets how many days chat history is stored locally. Older chats will be deleted automatically. | 7 |
| Use experimental web-based renderer for AI chat | Switches to a new experimental renderer for AI Chat, based on web technologies. This renderer may offer better performance and additional features, but it’s still under development and may have some issues. | Off |
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 -> 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 |
| Format SQL query | Adds formatting to the generated SQL. Uses database-default case. | Off |
| Table join rule | Choose between explicit JOIN or JOIN with sub-queries. | Default |
| Execute SQL immediately | Runs the translated SQL query immediately after generation. | Off |
| Enable AI query suggestion | Triggers smart SQL text suggestions using a shortcut. Suggestions are based on the current query and comments. | On |
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 |
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 |
| Send foreign keys information | Helps AI understand table relationships. | Off |
| Send unique and primary keys information | Sends unique and primary key metadata to the AI provider. Improves the quality of query generation, especially for joins and constraints, but uses more tokens. | Off |
Sample data¶
You can send a few rows of real data to the AI provider. This helps the AI understand your table structure and content better, so it can generate more accurate queries.
| Setting | Description | Default |
|---|---|---|
| Send sample data | Sends sample data to the AI provider. Improves completion quality, but increases token usage. | Off |
| Number of rows | Sets how many rows to include when sending sample data. Used only if Send sample data is enabled. | 3 |
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:
- Removes extra details (data types, keys, constraints, sample data) if all are enabled and the size is too large.
- If it’s still too large, trims the snapshot until it fits the context limit.