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.Documentation Index
Fetch the complete documentation index at: https://ai-kb.automationanywhere.com/llms.txt
Use this file to discover all available pages before exploring further.
Connecting to Microsoft SQL
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
Authentication
Database
| 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. |
| Field | Required | Description |
|---|---|---|
| Username | Yes | The SQL Server user (e.g. root). |
| Password | Yes | The password for the SQL Server user. |
| 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. |
You’re now ready to use your Microsoft SQL data in the Knowledge Base!