Microsoft SQLをナレッジベースに接続する

Microsoft SQL コネクタを使用すると、SQL Server データベースをナレッジ ベースに直接接続できます。接続すると、EKB は指定したテーブルにインデックスを作成し、データベースのコンテンツを検索可能にし、AI エージェントがアクセスできるようにして、根拠のあるデータ駆動型の応答を実現します。

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:

   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 SQL Server (e.g. PLACEHOLDER_1).
   Port	Yes	The port your SQL Server is listening on. Default is PLACEHOLDER_2.

   Authentication

   Field	Required	Description
   Username	Yes	The SQL Server user (e.g. PLACEHOLDER_3).
   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. PLACEHOLDER_4).
   Schema	Yes	The schema to use (e.g. PLACEHOLDER_5).
   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.

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!