Skip to main content

​
Database Connector

The Database Connector allows you to securely connect a shared database to a Project, making its data available to all project members through chat.
Important change: Database connectors are no longer added directly inside a chat. They are now project-level shared connectors, managed from the Project sidebar.
Ask your IT administrator to enable the Database Connector in your system configuration with the Operator Manual.

​
Creating a Database Connector

To create a database connector:
  1. Open your Project Sidebar
  2. Click Connectors
  3. Click Create connector
  4. Select Database
  5. Enter the required connection details
  6. Establish the connection
Once the connection is successful, additional configuration options become available.

​
Connection strings made simple

A connection string is like an address that tells the system where to find your database and how to access it. Your IT team can help you build the right connection string for your database.

​
Supported database types

  • Microsoft SQL Server
  • PostgreSQL
  • MySQL

​
Connection string

Security Notes:
  • Never share your connection strings with others
  • Use only the databases your IT team has approved
  • Make sure the user is read-only
Here’s what each part means (ask your IT team for the correct values): 
SQL Server: mssql+pyodbc://username:password@server:1433/database
PostgreSQL: postgresql://username:password@server:5432/database
MySQL: mysql+mysqldb://username:password@server:3306/database
Examples 
mssql+pyodbc://sa:password123@server.company.com:1433/SalesDatabase

mssql+pyodbc://dbuser:mypassword@192.168.1.50:1433/CustomerData

mssql+pyodbc://localhost:1433/TestDB?TrustServerCertificate=yes

​
Advanced Configuration

After the database connection has been established, you can configure advanced parameters to control how the database is used.

​
Table and Schema Restrictions

You can limit the connector’s access to:
  • Specific schemas
  • Specific tables
This helps:
  • Reduce unnecessary data exposure
  • Improve query accuracy
  • Prevent the LLM from querying irrelevant data

​
Connector Description

You can define a description for the database connector. This description is provided to the LLM and should explain:
  • What the database contains
  • How the data is structured
  • Any important rules or conventions
A good description significantly improves the quality of queries generated by the LLM.

​
Using the Database Connector in Chat

Once created, the database connector can be used in chats:
  1. Open or create a chat within the project
  2. Use the Connectors selector in the chat input
  3. Enable the database connector
When enabled, the LLM can query the database as part of the conversation.

​
Pre-Selected Connectors

Project administrators can configure database connectors to be pre-selected for every new chat in the project. This is especially useful when:
  • The database is a core part of the project workflow
  • Non-technical users need access to MCPs or databases without having to deal with complex configuration
  • Consistent data access is required across all conversations

​
Personal and Private Usage

If a user wants to configure their own database connectors without sharing them:
  1. Create a private project
  2. Create database connectors using the same process
  3. Use them exclusively within that private project
Private projects allow experimentation or personal integrations without affecting shared environments.

​
Requirements and Considerations

  • The database must be reachable from the connector environment
  • Network access, firewalls, and IP allowlists may need configuration
  • Queries generated by the LLM respect the connector’s configured scope

​
Security

  • Credentials are stored securely
  • The LLM can only access data allowed by the connector configuration
  • Schema and table restrictions are enforced at query time