Skip to main content
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

1

Open Project Settings

In your EKB project, navigate to Settings in the sidebar.
2

Go to Connections

Select the Connections tab and find the Microsoft SQL tile under Databases.
3

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.
4

Fill in the connection form

Enter the following details:ServerAuthenticationDatabase
5

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.
You’re now ready to use your Microsoft SQL data in the Knowledge Base!