Database federation on Gyri connects tenant PostgreSQL, MySQL, and MongoDB via live introspection — previewDbConnectorSchema discovers schema, installDbConnectorGraph wires db_operation bridges, and agents multihop across SQL rows and CRM in one cited session.
Live schema introspection → storage:remote types → db_operation bridges. Query Postgres, SQLite, Redis, Elasticsearch, and cloud warehouses in the same multihop GraphQL session as CRM, docs, and public data.
Related: Graph infrastructure · Federated search · Integrations
information_schema introspection, FK-aware bridges, parameterized SELECT templates.
INFORMATION_SCHEMA columns and foreign keys mapped to remote graph types.
Embedded SQL — sqlite_master and PRAGMA introspection.
INFORMATION_SCHEMA for enterprise SQL Server databases.
Collection sampling and BSON type inference for document stores.
Partition/sort key discovery and safe GetItem/Scan/Query ops.
Cloud warehouse tables via INFORMATION_SCHEMA.
Dataset table discovery with service-account auth.
Index mapping introspection and term/match_all reads.
Keyspace prefix discovery via SCAN — GET and hash field reads.
query {
previewDbConnectorSchema(connectorId: "wdbc_…", typeKeyPrefix: "postgres")
}
previewDbConnectorSchema discovers tables, columns, primary keys, and foreign keys — agents configure exposure, not column shapes.
get_by_pk, list_rows, and filter_eq operations only. No raw SQL from GraphQL or agents. Read-only connectors with entity allowlists.
Join CRM deals, Slack threads, and Postgres rows in one cited GraphQL query — results land on custom records and insights.
federation-db-*-starter module packs for all 10 dialects with anchor types and FK bridges where supported.
Dashboards and SQL clients return tables — not cited, traversable nodes agents can join with CRM and docs.
One-off sync jobs break when schemas change. Introspection keeps the graph aligned with the source of truth.
Agents with raw SQL access are a liability. Gyri uses allowlisted tables and parameterized operation templates.
PostgreSQL, MySQL/MariaDB, and MongoDB in v1. The adapter framework is extensible to SQL Server, Snowflake, BigQuery, and other stores.
No. Only parameterized get_by_pk, list_rows, and filter_eq operations against allowlisted tables or collections.
previewDbConnectorSchema reads information_schema (SQL) or samples Mongo collections, then suggests remote types and FK bridges for installDbConnectorGraph.