Skip to content

AI Assistant

Note

If you're using DBeaver Community, see the setup guide in GitHub Wiki. AI support in Community is limited compared to Lite, Enterprise and Ultimate editions.

Team Edition provides AI powered features for working with databases in natural language, using popular providers. It can create and edit queries, answer questions, troubleshoot errors, or explore database objects.

Supported providers

AI Assistant in Team Edition works with several AI providers.

Team Edition isn’t affiliated with these providers. Integration with AI assistance is achieved through the public APIs. To use AI Assistant, sign up with a provider and activate it in Team Edition.

Important

Some paid AI provider plans don’t allow access for use in third-party applications. Make sure your subscription includes this capability before connecting.

AI Assistant features

Chat

  • AI Chat. Chat naturally with AI to ask questions and get queries.
  • Speech recognition. Convert spoken input into text and use it to generate SQL queries.

Work with SQL

  • Query suggestion. See SQL suggestions as you type in the SQL Editor.
  • Explain query. Run AI to explain what a query does in plain language.
  • Fix SQL errors. See what went wrong and how to fix a failed query.
  • AI command. Run AI command directly in the SQL Editor. Type command like @ai show films in which Grace Mostel starred, and let AI generate the SQL for you.

Work with objects

Assist data transfer

  • Map with AI. Automatically map source tables and columns to target names and types. AI analyzes sample data and schema structure, then suggests mappings.

Best practices for prompt formulation

Follow these guidelines to get the most accurate results from AI:

  • Use English: While AI supports multiple languages, English works best.
  • Know your database: The more you understand your database structure, the more accurate the generated queries.
  • Refine iteratively: Start broad, then add details step by step to improve results.
  • Be explicit: Mention specific tables or columns if you know them - this helps AI generate precise queries.

Disable AI Assistant

Learn more about disabling AI Assistant.

Data privacy

Team Edition protect your data and privacy with strict safeguards. AI Assistant works with the minimum information required, and all processing follows provider privacy policies.

Info

Learn more in Data privacy.