SingleStore

Connect a SingleStore database to Lakehousecat using a connection URI.

Connection Fields

Field	Required	Description
Connection URI	Yes	Full connection string. Example: singlestoredb://user:password@host:3306/database
Use SSH	No	Enable if the database is behind an SSH bastion host. See SSH Tunneling.

Prerequisites

• Admin or Builder role in Lakehousecat
• A SingleStore user with SELECT access to the target database and tables
• Default port: 3306 (MySQL-compatible wire protocol)

Notes

• SingleStore uses the MySQL wire protocol — use the singlestoredb:// URI scheme in Lakehousecat.
• In SingleStore, a database name is equivalent to a schema.
• Incremental Load is supported; use a timestamp column (e.g., updated_at) as the merge key.

Next Steps

After creating the datasource, go to the Operations tab to trigger semantic extraction.