Skip to content

AI chat

DBeaver provides AI Chat for working with databases in natural language. You can enter requests in plain text to generate SQL queries, get explanations, or ask questions about your databases.

Work with AI Chat

  1. Click on the AI Chat icon located in the DBeaver toolbar.

    • Alternatively, open the SQL Editor and click on the AI Assistant icon located in the left toolbar.

    Note

    The toolbar is customizable. For further information, refer to Toolbar Customization article.

  2. In the chat window that opens, select a connection and, optionally, a scope.

  3. Enter your request in natural language.

  4. Press the Send button to get the SQL translation. You can then choose from the following options:

    • Execute to run the generated SQL query

    • Editor to open the query in the SQL Editor and continue working with it directly

      Tip

      If the cursor is on a query, clicking Editor will replace it. Move to a new line to keep the old query.

    • Copy to copy the query to your clipboard

Tip

To stop response generation, select the Stop button next to the input field.

Info

For information on AI Chat keyboard shortcuts, see Shortcuts.

AI Chat configuration

Connection field

To use a specific connection in AI Chat, select the connection from the toolbar at the top of the chat panel. The selected connection defines which database the AI will use when generating SQL queries.

Multiple conversations

You can create multiple chats for different connections.

The first chat is created automatically when you open AI Chat. Each chat is named based on your first prompt. Messages related to the same query or object in the same connection are kept together in one conversation.

Action Button/icon How to do it
Add a new chat Click the button to start a new conversation
Switch chats (Dropdown menu) Use the dropdown menu to switch between existing chats
Delete a chat Select the chat from the dropdown, then click the delete button

Important

Deleted conversations can’t be restored.

Resetting query context

AI Chat keeps the history of your questions so you can build on them. Sometimes you may want to start fresh. To reset the context or clear history up to a certain message, click the reset button () next to that message.

Example

You asked about the “orders” table and then want to switch to “customers”. Reset before your new question so AI doesn’t mix both topics.

Defining the scope

To improve accuracy, especially in databases with large schemas, you can limit what database context AI sees.

  1. In the AI Chat toolbar, click the Change scope button to open the context menu.

  2. Under Applies to, choose whether the scope below is remembered for the connection or just for this chat:

    Option Description
    This connection The scope is saved with the connection and reused across conversations
    This conversation The scope only applies to the current chat and resets when you start a new one

  3. Under Metadata sent to AI, choose how much database context AI sees:

    Scope option Description
    Current schema AI focuses only on the schema you’re currently using
    Current database AI is limited to the currently selected database
    All objects AI can access metadata for all schemas and objects in the current connection
    Custom Lets you define a more specific scope, such as a particular table or set of objects

Active configuration

tag-outline Available since 26.2

Each conversation uses the default AI profile unless you switch it. To use a different provider or model just for the current chat:

  1. In the AI Chat toolbar, click the Change scope button to open the context menu.

  2. Under Active configuration, pick a profile from the list.

Info

The switch only applies to the current conversation - it doesn’t change the default profile in Preferences.

Import files

You can upload files directly in AI Chat and use AI to import data or open files as tables.

To add files, do one of the following:

  • drag and drop file(s) into the AI Chat input area
  • click the Attach a file button () in the chat input and select file(s) manually

File handling in AI Chat is limited to the formats listed below:

Workflow Supported formats / drivers
Open as table - CSV
- JSON
- Parquet
- XML
- XLSX
- SQLite
Import data from file Supports all file formats available for data import.

Info

When importing data, you can upload multiple files of the same format and import them together.

Clarifying questions

tag-outline Available since 26.2

When your request can be read in more than one way, AI asks you to clarify it right in the chat instead of guessing. The question appears as a card with the options to pick from.

Info

For more details, see User interaction.

Message statistics and token usage

tag-outline Available since 26.0

You can show per-message statistics in AI Chat, including message time, time spent, and token usage.

  1. In the AI Chat toolbar, click the arrow next to the Settings button () to open the dropdown menu.

  2. Enable the stats you want to see:

    • Show message time
    • Show time spent
    • Show tokens spent
    • Show total tokens spent

Voice input

You can dictate your AI Chat requests using your operating system's voice input tools.

OS Tool
Windows Voice Typing (Win + H) or Voice Access
macOS Dictation

To use voice input in AI Chat:

  1. Click in the AI chat input field.
  2. Start your OS's voice input tool and speak your request.
  3. Review and edit the transcribed text, then press Send.

AI Chat settings

Adjust chat options to make AI Chat work the way you prefer.

Go to Window -> Preferences -> AI -> Chat Settings.

Info

For the full list of AI Chat options, see Chat Settings.