Foreign Key DetectorFind undeclared foreign keys in PostgreSQL DDL, with confidence scores and ready ALTER TABLE statements.Columns like user_id that reference another table but carry no FOREIGN KEY constraint are invisible to your ER diagram and unenforced by PostgreSQL. SchemaIQ detects these implied relationships by name pattern and semantic match, checks type compatibility, and gives each candidate a confidence score plus the exact ALTER TABLE ... ADD CONSTRAINT statement to declare it.

Name-pattern and semantic detection passes

HIGH / MEDIUM confidence with type-compatibility checks

High-confidence candidates shown as dashed ERD edges

One-click FK declaration into your SQL

Rejected suggestions never resurface or affect your score

Explore SchemaIQ