SQL DDL to ER Diagram Generator
Paste any-dialect SQL DDL (CREATE TABLE / ALTER TABLE) and instantly render an ER diagram as Mermaid erDiagram code, ASCII crow's-foot diagram, and DBML. Detects PKs, UNIQUE, composite keys, inline and table-level foreign keys, ALTER TABLE ADD FOREIGN KEY, and self-referencing FKs. Auto-layout, topological ordering (handles circular FKs), naming-based relationship inference when FKs are absent. 100% client-side, no signup.
About SQL DDL to ER Diagram Generator
Paste any-dialect SQL DDL (CREATE TABLE / ALTER TABLE) and instantly render an ER diagram as Mermaid erDiagram code, ASCII crow's-foot diagram, and DBML. Detects PKs, UNIQUE, composite keys, inline and table-level foreign keys, ALTER TABLE ADD FOREIGN KEY, and self-referencing FKs. Auto-layout, topological ordering (handles circular FKs), naming-based relationship inference when FKs are absent. 100% client-side, no signup. Everything runs locally in your browser — your data never leaves your device.
How to use
- Enter your input in the tool above.
- Adjust any options to your preference.
- Use the Copy or Download buttons to save the result.
- Everything happens locally — your data never leaves your browser.
FAQ
How does the SQL DDL to ER Diagram Generator work?
Paste your CREATE TABLE / ALTER TABLE DDL (MySQL, PostgreSQL, SQLite, SQL Server, or ANSI-compatible) and the tool parses it into an in-memory schema model — tables, columns with types/nullability, primary keys, unique constraints, indexes, and foreign keys (inline REFERENCES, table-level FOREIGN KEY, or ALTER TABLE ADD FOREIGN KEY). From that model it emits a Mermaid erDiagram, an ASCII crow's-foot diagram, and DBML, plus a topologically-sorted creation order. Everything runs in your browser; no DDL is uploaded.
Which SQL features and edge cases are supported?
Composite primary keys, composite foreign keys, self-referencing FKs (categories.parent_id → categories.id), circular FK chains (topological sort falls back gracefully), inline and table-level FK declarations, ALTER TABLE ADD FOREIGN KEY, named and inline constraints, multi-word types (CHARACTER VARYING, DOUBLE PRECISION, TIMESTAMP WITHOUT TIME ZONE), and quoted identifiers (`backtick`, "double-quote", [bracket]). CHECK constraints are detected and flagged but not interpreted. Naming-based relationship inference (e.g. user_id → users.id) can be enabled to draw FK edges when explicit REFERENCES are missing.
What output formats can I export?
Mermaid erDiagram code (paste into any Mermaid renderer, GitHub, Notion, or the live editor), a plain-text ASCII crow's-foot diagram, DBML (for dbdiagram.io), and a JSON schema model that round-trips with our companion ER Diagram Designer (#268). You can copy or download any of these, and a shareable URL encodes the entire schema in the fragment so you can send the diagram to a colleague without uploading anything.
Does this work offline and without an account?
Yes. Parsing, layout, and all export formats are 100% client-side. There is no signup, no API key, and no upload — your DDL never leaves the browser. History (last 20 parses) is stored in localStorage on your device only. The tool is installable as a PWA.
What extras does this generator offer versus dbdiagram.io / drawDB / DrawSQL?
(1) Multi-dialect DDL parsing (MySQL, PostgreSQL, SQLite, SQL Server, ANSI). (2) Mermaid erDiagram + ASCII crow's-foot + DBML exports from one parse. (3) Composite PK / composite FK / self-ref FK / circular FK support. (4) Naming-based relationship inference (user_id → users.id) when explicit FKs are absent. (5) Auto-layout with table coordinates. (6) Topological sort with cycle detection. (7) Reserved-word detection per dialect. (8) Inline validation warnings (orphan FK targets, missing PK, etc.). (9) JSON schema model export that round-trips with the ER Diagram Designer. (10) Shareable URL with base64-encoded schema. (11) Three DDL presets (blog, e-commerce, m2m). (12) localStorage history (max 20). (13) Copy / download every format. (14) 100% offline, no signup.
Related tools
.bashrc / .zshrc Alias & Config Manager
Build shell aliases, functions, exports, and PATH edits in a visual editor, then export a clean, commented .aliases file sourced from both .bashrc and .zshrc — with shadowing detection against shell builtins and common CLI tools, function suggestions when args are needed, starter packs (git, docker, kubectl, navigation, safety, ls, dev, devops, data science), import of existing rc files, dedupe, history (localStorage), and shareable URL. 100% client-side.
Add / Subtract Date Calculator
Add or subtract years, months, weeks, days, hours, minutes and seconds from a starting date/time. Calendar-day or business-day mode with custom weekend + holiday list. Month-end policy toggle (clamp to last day vs overflow). Repeat/series mode (e.g. every 2 weeks x 10) with CSV export. Shareable URL. 100% client-side.
Age Calculator
Calculate exact age from a birth date in calendar years/months/days (no negative-day bugs) plus totals in months/weeks/days/hours/minutes/seconds. Next-birthday countdown with weekday. Feb-29 birthday policy toggle. Milestones (1,000 days, 10,000 days, 1 billion seconds). Zodiac sign + Chinese zodiac. Age gap comparison. Shareable URL. 100% client-side.