SCHEMA VISUALIZER + ANALYSIS

See what your
schema is hiding.

Paste your CREATE TABLE statements. Get an instant ER map, flagged gaps, and AI fixes you can apply with one click — before they become production incidents.

Paste your DDL →Watch 90s demo
free to use · your schemas stay private to you
erdfactory.app / Untitled Schema
READSPostgreSQLMySQLSQLiteSQL ServerPrisma / Drizzle
HOW IT WORKS

Paste. Map. Fix.

01
Paste your DDL

Drop in CREATE TABLE statements or a schema dump. Parsed instantly, entirely in the browser.

02
See the map

An interactive ER diagram with PK/FK icons and relationship lines — real constraints and the ones you only meant to add.

03
Fix the gaps

Every missing index, orphan table, and anti-pattern flagged with severity. Select what matters and let Gemini rewrite the DDL for you — reviewed as a diff before anything lands.

RELATIONSHIPS

Real constraints vs.
wishful thinking.

ERD Factory separates FK relationships you actually defined from the ones your naming convention implies — so you can tell a guarantee from a guess at a glance.

Solid green — defined foreign key
Amber dashed — inferred by naming, no constraint
Red ring — flagged gap on the table
orders
id · user_id
products
no FK constraint
order_items
order_id · product_id
GAP DETECTION

The issues you'd
find in code review.

Missing indexes on foreign keys, orphan tables, absent constraints — each detected automatically and ranked by severity so you fix what matters first.

HIGHMEDIUMLOW
No formal FK constraintHIGH
order_items.product_id → products.id
Missing index on FKMED
orders.user_id
Orphan table (no relations)LOW
sessions
AI ANALYSIS

A senior data engineer
who ships the patch too.

Structural gaps and Gemini's own findings — normalization issues, anti-patterns, naming inconsistencies — land in one selectable checklist. Pick what to fix and Gemini rewrites the DDL to address just those, nothing else touched.

reviewed as a diff before it lands ↗
Add FK constraint: order_items.product_id → products.idHIGHSTRUCTURAL
Composite index on (customer_id, status)MEDAI INSIGHT
Split repeated address fields into a tableLOWAI INSIGHT
2 of 3 selectedImplement Selected Fixes
DISCOVERY MODE

Every column, in one
searchable list.

Skip the canvas when you just need answers: every table and column in full, filterable by any token. A naming-similarity inspector flags likely misspellings and duplicate names — the sloppy, inconsistent stuff convention-based matching alone can't catch.

usr_id3 of 41 columns
usr_idorderspossible misspelling of user_id
emailcustomerssame name elsewhere
statusshipmentsno relationship
PROJECTS & REVIEW

From draft to reviewed,
without a spreadsheet.

Organize schemas into Projects and Collections, mark one ready for review, and it shows up on your dashboard with a one-line summary of everything that's changed since it was created. Full version history and side-by-side compare mean nothing gets lost between drafts.

READYStorefront v2
+3 -0 ~2 tables
READYBilling
+1 -1 ~0 tables
DRAFTInternal Admin
not submitted

Find the gaps before
production does.

Paste a schema and see your first analysis in under ten seconds.

ERD Factory

Schema visualization & analysis for people who ship databases.

© 2026 ERD Factory