​
What is the database connector?

The Database Connector lets you connect to your company’s databases and ask questions about your data directly in chat. Instead of writing complex database queries, you can simply ask “How many customers do we have?” or “Show me last month’s sales figures.”
Ask your IT administrator to enable the Database Connector in your system configuration with the Operator Manual

​
Connect to your database

  1. Open any chat where you want to use database information
  2. Click the tool selector
  3. Select “Add connection to database”
  4. Enter your connection details in the popup window
Connection popup window

​
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

​
What you can do once connected

After connecting, you can ask questions about your data:
  • How much revenue did we generate last month?
  • Which products are selling best?
  • Show me our top 10 customers
Limitations:
  • Queries automatically stop after 10 minutes
  • Due to context window limitations LLM final output could be returned in CSV
  • Some advanced database operations may not be available

​
Troubleshooting