Free · No sign-up · Nothing installed

MySQL to ER Diagram

Paste CREATE TABLE statements or raw mysqldump -d output — backticks, AUTO_INCREMENT and ENGINE clauses handled.

SQL input — CREATE TABLE · DDL · dumpmysql

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `display_name` varchar(120),
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_users_email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `posts` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `author_id` bigint UNSIGNED NOT NULL,
  `title` varchar(200) NOT NULL,
  `body` mediumtext,
  `status` enum('draft','published') NOT NULL DEFAULT 'draft',
  PRIMARY KEY (`id`),
  KEY `idx_posts_author` (`author_id`)
) ENGINE=InnoDB;

CREATE TABLE `comments` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `post_id` bigint UNSIGNED NOT NULL,
  `commenter_id` bigint UNSIGNED NOT NULL,
  `body` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

CREATE TABLE `tags` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `slug` varchar(80) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

CREATE TABLE `post_tags` (
  `post_id` bigint UNSIGNED NOT NULL,
  `tag_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`post_id`, `tag_id`)
) ENGINE=InnoDB;

ALTER TABLE `posts` ADD CONSTRAINT `fk_posts_author` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT;
ALTER TABLE `comments` ADD CONSTRAINT `fk_comments_post` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE;
ALTER TABLE `comments` ADD CONSTRAINT `fk_comments_user` FOREIGN KEY (`commenter_id`) REFERENCES `users` (`id`);
ALTER TABLE `post_tags` ADD CONSTRAINT `fk_pt_post` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE;
ALTER TABLE `post_tags` ADD CONSTRAINT `fk_pt_tag` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE;

mysqlSample: · ·

Diagram—

Your diagram renders here.

Parser coverage

What we parse in mysql

AUTO_INCREMENT — detected and folded into the PK column
Backtick identifiers — stripped for display, kept unambiguous
ENGINE / CHARSET clauses — dropped as noise
InnoDB FKs — inline FOREIGN KEY … REFERENCES and ALTER TABLE forms both parsed

From your database

Get just the schema

mysqldump -d --no-tablespaces dbname > schema.sql

-d means structure only. INSERT rows and session noise are stripped automatically.

FAQ

Questions, answered

How do I generate an ER diagram from a MySQL database?

Run mysqldump -d dbname to export structure only, then paste the output above.

Does it handle backticks and ENGINE= clauses?

Yes — dialect noise is stripped so the diagram shows tables, types and keys only.

Are enum columns supported?

Yes, enum('draft','published') renders verbatim in the column's type slot.

More converters

MySQL to ER Diagram

What we parse in mysql

Get just the schema

Questions, answered

Also available