Relationship Discovery

Find the relationships your team forgot to document

Your databases have more relationships than anyone documented. Squish scans your schemas and actual data patterns to surface connections that exist only as tribal knowledge.

users
id
email
name
orders
id
user_id
total
products
id
name
price
order_items
order_id
product_id
qty
Scanning schema...0%

What makes Squish different

Not another ERD tool

Traditional tools show you what you already know. Squish discovers what nobody documented.

SQL and NoSQL

Cross-Database Discovery

Find relationships that span PostgreSQL, Snowflake, BigQuery, MongoDB, and more. When user_id in your orders service connects to user_id in billing, we find it -- across SQL and NoSQL.

80%+ configurable confidence

Statistical Analysis

We analyze actual data patterns, not just column names. UUID matching, cardinality analysis, and value overlap detection surface hidden connections.

Not a black box

Explainable Results

Every relationship comes with evidence: why we think this connection exists, what data supported it, and how confident we are.

Four levels of discovery

How we find relationships others miss

Level 1

Constraint Extraction

Extract declared foreign keys, primary keys, unique constraints, and indexes from your database metadata.

Level 2

Column Inference

Match columns by naming patterns. When user_id appears in multiple tables, we infer the relationship across snake_case variants.

Level 3

Statistical Analysis

Sample actual data values, compute overlap statistics, detect UUID patterns, and analyze cardinality to find hidden connections.

Level 4

NoSQL Pattern Analysis

Detect MongoDB embedding patterns, DynamoDB GSI relationships, Cassandra partition key structures, and cross-reference them with your SQL schemas.

Squish vs. the status quo

Current approach
The problem
With Squish
Manual ERD tools
Stale the day after creation
Continuously updated from live schemas
Data catalogs
Require manual documentation
Auto-discover relationships from data patterns
Database metadata
Only shows declared foreign keys
Finds undeclared relationships statistically
NoSQL databases
No relationship concept at all
Detect embedding patterns, key hierarchies, and cross-references

Stop sending Slack messages asking which tables connect

Connect your databases and see relationships in minutes. Read-only access, configurable confidence thresholds, explainable results.