AI Assistant settings

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

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
Use web browser view	Enables modern renderer for AI Chat, based on web technologies. Otherwise oses old renderer in OS-native widgets.	On
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.	Off
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 -> 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
Other	Controls execution of queries DBeaver 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
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

Scope settings

Setting	Description	Default
Send only relevant objects to AI	This option enables Retrieval-Augmented Generation behavior (RAG). When it’s on, DBeaver looks at your request and sends only the tables, columns, or other objects that are actually needed for the answer. This keeps responses faster, reduces token usage, and helps the assistant build replies based on real, relevant data instead of your full schema.	Off

Note

RAG works only with the OpenAI provider.

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, DBeaver 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.

Tip

For information on enabling AI Assistant, see AI Assistant settings.

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 sample data or metadata to improve query generation and mapping.

Function	Description
Read table sample rows	Reads several rows from a table to understand its structure and suggest better queries or mappings.

Note

If you don’t enable these functions, DBeaver won’t send any database data to the AI. To send only structure metadata, 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.