Skip to content

AI smart assistance

Team Edition provides AI assistance for working with databases in natural language. You can ask questions, create and edit queries, troubleshoot errors, or explore database objects. This capability is powered by integrations with the following AI services:

Team Edition isn’t affiliated with these providers. Integration with AI assistance is achieved through the public APIs. To use AI assistance, register with the respective service provider and get a secret key.

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 setup

To activate the AI features in Team Edition, configure the API token:

  1. Navigate to Settings -> Administration -> Server Configuration
  2. Ensure the AI option is activated.
  3. Navigate to AI Settings tab -> Choose an engine
  4. Insert credentials.
  5. Save the changes.

AI assistant features

Create and edit queries

  • AI Chat. Chat naturally with AI to ask questions and get queries.
  • AI command. Use AI command directly in the SQL Editor. Type commands like @ai show films in which Grace Mostel starred, and AI will generate the SQL for you.

Understand and troubleshoot queries

Get insights about database objects

Best practices for prompt formulation

  • Language: While AI supports multiple languages, it's recommended to use English for best results.
  • Database knowledge: Familiarity with your database structure enhances the accuracy of generated queries.
  • Iterative refinement: Start with a general request and refine iteratively. As you provide more specific details, the AI's output will become more relevant.
  • Explicit details: If you know certain tables or columns that should be part of the query, include them in your request for better accuracy.

Data privacy

We prioritize data safety and user privacy. In this section, we outline how data is managed and the measures taken to protect user privacy when using the AI features.

To enable AI features capabilities, metadata such as table and column names from the current database schema are transmitted to third-party AI services. This step is crucial for accurately translating user requests into SQL queries.

  • No table data: Only metadata like table and column names are shared with OpenAI. Actual table data is not transmitted.
  • Log transparency: The entire request can be logged for your review. To enable this, navigate to AI Settings tab and check the Write GPT queries to debug log option.

Privacy policy

In addition to these general principles, each AI provider applies its own privacy policy:

Provider Privacy policy
OpenAI Requests are processed under the OpenAI privacy policy.
GitHub Copilot Copilot follows the GitHub privacy statement.
Azure OpenAI Operates under its own privacy policy. It's recommended to review their terms.
Google Gemini Data is handled according to Gemini privacy measures.
Ollama Ollama follows a local-first design: all AI processing happens on your machine, and prompts, code, or documents never leave your computer.
Anthropic Claude Requests are processed according to Anthropic’s privacy policy. Review their terms to understand how your data is handled.

Disable AI assistance

Learn more about disabling AI assistance.