Connect Microsoft SQL to the Knowledge Base
With the Microsoft SQL connector, you can connect your SQL Server databases directly to the Knowledge Base. Once connected, EKB indexes the tables you specify, making your database content searchable and accessible to your AI agents for grounded, data-driven responses.
Connecting to Microsoft SQL
- Open Project Settings
In your EKB project, navigate to Settings in the sidebar.
- Go to Connections
Select the Connections tab and find the Microsoft SQL tile under Databases.
- Open the Microsoft SQL popup
Click the Microsoft SQL tile. A popup appears with the option to connect to SQL Server databases. Click + Add Connection.
- Fill in the connection form
Enter the following details:
Server
Field Required Description Connection Name Yes A display name for this connection (e.g. My MsSQL Connection).Host Yes The hostname or IP address of your SQL Server (e.g. localhost).Port Yes The port your SQL Server is listening on. Default is 3306.Authentication
Field Required Description Username Yes The SQL Server user (e.g. root).Password Yes The password for the SQL Server user. Database
Field Required Description Database Yes The name of the database to connect to (e.g. mydb).Schema Yes The schema to use (e.g. dbo).Tables Yes The tables to index. Enter each table name separated by a comma. Always Trust Server No Enable this toggle to bypass SSL certificate validation for the server. - Save the connection
Click Save. EKB will authenticate using the details provided. If successful, the Microsoft SQL tile on the Connections page will display a green dot and a count of your active Microsoft SQL connections.