MySQL コネクタを使用すると、MySQL または MariaDB データベースをナレッジ ベースに直接接続できます。接続すると、EKB は指定したテーブルにインデックスを作成し、データベースのコンテンツを検索可能にし、AI エージェントがアクセスできるようにして、根拠のあるデータ駆動型の応答を実現します。
MySQL への接続
Open Project Settings
In your EKB project, navigate to Settings in the sidebar.
Go to Connections
Select the Connections tab and find the MySQL tile under Databases.
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| Field | Required | Description |
|---|
| Connection Name | Yes | A display name for this connection (e.g. PLACEHOLDER_0). |
| Host | Yes | The hostname or IP address of your MySQL server (e.g. PLACEHOLDER_1). |
| Port | Yes | The port your MySQL server is listening on. Default is PLACEHOLDER_2. |
| Database | Yes | The name of the database to connect to (e.g. PLACEHOLDER_3). |
| Field | Required | Description |
|---|
| Username | Yes | The MySQL user (e.g. PLACEHOLDER_4). |
| 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. |
Save the connection
Click Save. EKB will authenticate using the details provided. If successful, the MySQL tile on the Connections page will display a green dot and a count of your active MySQL connections.
You’re now ready to use your MySQL data in the Knowledge Base!
