DIAGRAM → REVIEW → FIX

Every schema change,
reviewed before it ships.

Paste your CREATE TABLE statements. Get an instant ER map, flagged issues, and AI-proposed fixes — reviewed as a diff before anything touches your schema.

free, no signup · create an account to save schemas & get AI fixes
erdfactory.app / Untitled Schema
READSPostgreSQLMySQLSQLiteSQL Server
HOW IT WORKS

Paste. Map. Review.

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
Review the fix

Every missing index, orphan table, and anti-pattern flagged with severity. Select what matters, let Gemini rewrite the DDL — then review the 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
WHAT GETS CHECKED

The issues you'd
find in code review.

Missing indexes on foreign keys, orphan tables, absent constraints — each detected automatically, ranked by severity, and queued for the same diff review as every other fix.

HIGHMEDIUMLOW
No formal FK constraintHIGH
order_items.product_id → products.id
Missing index on FKMED
orders.user_id
Orphan table (no relations)LOW
sessions
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
DIFF-GATED FIXES

A senior data engineer
whose patches you review first.

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
AI DESIGNER

Describe the feature.
Watch the tables appear.

Where AI Engineer patches what's broken, AI Designer builds what's missing. Describe a feature in plain language and Gemini proposes the tables, columns, and relationships to support it — revealed right on the canvas, highlighted alongside your existing schema instead of buried in a wall of SQL.

keep refining, or confirm when it's right ↗
add a module for tracking production costs per project
projects
id · name
production_costsNEW
id · project_id · category · amount
Added production_costs, linked to projectsConfirm
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 means 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