Connect Generic SQL to the Knowledge Base

With the Generic SQL connector, you can connect to Snowflake, Postgres, Redshift, and other SQL databases using a connection string. Use this connector when there is no dedicated connector tile for your database.

Connecting to Generic 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 Generic SQL tile under Databases.

3. Open the Generic SQL popup

   Click the Generic SQL tile. A popup appears with the option to connect to Snowflake or other SQL 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. My Generic Connection).
   Connect String	Yes	The connection string for your database (e.g. sqlite:///:memory:).

   Database

   Field	Required	Description
   Tables	Yes	The tables to index. Enter each table name separated by a comma.

5. Save the connection

   Click Save. EKB will authenticate using the details provided. If successful, the Generic SQL tile on the Connections page will display a green dot and a count of your active Generic SQL connections.

✓You're now ready to use your database in the Knowledge Base!