Tessera DB Tutorial: Discover Schema and Auto-Derive Graph Endpoints from Foreign Keys

Let Tessera read your Postgres schema and turn every foreign key into a real graph relationship — no manual mapping.

PAR2 Labs

August 29, 2026

2 min

Tessera DB Tutorial: Discover Schema and Auto-Derive Graph Endpoints from Foreign Keys

This is the feature that turns "ingest a table" into "build a queryable graph." Schema discovery reads your Postgres catalogue and surfaces every foreign key as a candidate graph relationship.

Before you start

Tier

Schema discovery ships with the Enterprise PostgreSQL connector.

Step 1: Open the wizard

In the admin dashboard, go to Data Sources, add a PostgreSQL source, and fill in read-only credentials.

Step 2: Discover the schema

Instead of typing table names, click Discover schema. Tessera connects, reads the database's own catalogue, and returns a list of tables annotated with their columns, primary keys, and foreign keys.

The foreign-key structure of your relational source is the graph.

Step 3: Read the FK annotations

Each foreign-key column is marked with an arrow to the table it references and an auto graph endpoints badge. That badge means: tick this table and Tessera will generate the endpoint mapping for you, turning the foreign key into a real graph edge.

Step 4: Apply and verify

Tick the tables you want and apply the selection. Tessera confirms the mappings it auto-derived — for example, orders linked to customers, shipments linked to addresses, line items linked to products.

Step 5: Save and query the graph

After saving and syncing once, you can immediately walk the auto-derived graph:

cypher

MATCH (o:Orders)-[:customers]-(c:Customers)
WHERE o.total > 1000
RETURN c.email, o.id, o.total

Step 5: Save and query the graph — no pipeline

No graph-loading pipeline. No separate graph database. The foreign-key structure of your relational source is the graph.

Key Takeaways

Added a PostgreSQL source with read-only credentials.

Used Discover schema to list tables with their columns, primary keys and foreign keys.

Applied a selection so Tessera auto-derived graph endpoints from the foreign keys.

Walked the resulting graph with Cypher after a single sync.

The product behind this

Tessera DB

A multi-model database that stores your data once and queries it five ways — relational, graph, vector, full-text and time-series — built for AI workloads and run on your own hardware.

See Tessera DB

PAR2 Labs · Technology

Work With Us