With the MySQL connector, you can connect your MySQL or MariaDB 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 MySQL
Open the MySQL popup
Click the MySQL tile. A popup appears with the option to connect to MySQL 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 MySQL Connection). |
| Host | Yes | The hostname or IP address of your MySQL server (e.g. localhost). |
| Port | Yes | The port your MySQL server is listening on. Default is 3306. |
| Database | Yes | The name of the database to connect to (e.g. mydb). |
| Field | Required | Description |
|---|---|---|
| Username | Yes | The MySQL user (e.g. root). |
| Password | Yes | The password for the MySQL user. |
| Field | Required | Description |
|---|---|---|
| Tables | Yes | The tables to index. Enter each table name separated by a comma. |
You’re now ready to use your MySQL data in the Knowledge Base!