Overview

The MariaDB connector syncs database schema and table data into PipesHub, so AI assistants can answer questions over structured records alongside the rest of your knowledge sources.

How it works

PipesHub connects with a read-only MariaDB user and reads structure from information_schema table names, columns, data types, and primary and foreign keys. Row data is indexed up to a configurable per-table limit (default 1,000), or you can sync schema only.

Configure

• Create a dedicated user: CREATE USER 'pipeshub_user'@'%' IDENTIFIED BY 'password'

• Grant read access: GRANT SELECT ON database.* TO 'pipeshub_user'@'%'

• Enter host, port, database, username, and password in Connector Settings

• Select tables to sync (leave empty for all) and set the max row limit

• Toggle table content indexing, then choose sync strategy and interval (default 60 minutes)