Database federation

Connect 10 database engines
to your federated graph.

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

Supported engines

PostgreSQL, MySQL, MongoDB

PostgreSQL

information_schema introspection, FK-aware bridges, parameterized SELECT templates.

MySQL / MariaDB

INFORMATION_SCHEMA columns and foreign keys mapped to remote graph types.

SQLite

Embedded SQL — sqlite_master and PRAGMA introspection.

SQL Server

INFORMATION_SCHEMA for enterprise SQL Server databases.

MongoDB

Collection sampling and BSON type inference for document stores.

DynamoDB

Partition/sort key discovery and safe GetItem/Scan/Query ops.

Snowflake

Cloud warehouse tables via INFORMATION_SCHEMA.

BigQuery

Dataset table discovery with service-account auth.

Elasticsearch

Index mapping introspection and term/match_all reads.

Redis

Keyspace prefix discovery via SCAN — GET and hash field reads.

How it works

Introspect → install → multihop

Connect
Introspect
Install graph
Multihop query
query {
  previewDbConnectorSchema(connectorId: "wdbc_…", typeKeyPrefix: "postgres")
}
Capabilities
Introspection-first

Schema from the live database

previewDbConnectorSchema discovers tables, columns, primary keys, and foreign keys — agents configure exposure, not column shapes.

db_operation bridges

Safe parameterized reads

get_by_pk, list_rows, and filter_eq operations only. No raw SQL from GraphQL or agents. Read-only connectors with entity allowlists.

Graph-native

Same multihop session

Join CRM deals, Slack threads, and Postgres rows in one cited GraphQL query — results land on custom records and insights.

Starter modules

Ship in minutes

federation-db-*-starter module packs for all 10 dialects with anchor types and FK bridges where supported.

Why teams switch
01

BI tools sit outside the agent graph

Dashboards and SQL clients return tables — not cited, traversable nodes agents can join with CRM and docs.

02

Hand-wired ETL rots

One-off sync jobs break when schemas change. Introspection keeps the graph aligned with the source of truth.

03

Unsafe ad-hoc SQL

Agents with raw SQL access are a liability. Gyri uses allowlisted tables and parameterized operation templates.

Federate your databases

Graph infrastructure Federated search Native integrations

Frequently asked questions

Which databases does Gyri support?

PostgreSQL, MySQL/MariaDB, and MongoDB in v1. The adapter framework is extensible to SQL Server, Snowflake, BigQuery, and other stores.

Can agents run arbitrary SQL?

No. Only parameterized get_by_pk, list_rows, and filter_eq operations against allowlisted tables or collections.

How does introspection work?

previewDbConnectorSchema reads information_schema (SQL) or samples Mongo collections, then suggests remote types and FK bridges for installDbConnectorGraph.