MySQL schema diagrams from mysqldump output

Drop in a mysqldump file. Backticked identifiers, version-gated comments, inline keys and foreign keys to tables the file never defines are all handled.

Open the app

What the parser makes of it

• 2 tables
• 12 columns
• 2 relations

• backticked identifiers everywhere, including inside REFERENCES
• version-gated /*!40101 … */ comments, which are executable SQL to MySQL and noise here
• inline PRIMARY KEY, UNIQUE KEY, KEY and FULLTEXT KEY clauses
• named CONSTRAINT … FOREIGN KEY with ON DELETE and ON UPDATE actions
• column COMMENT text containing semicolons, double dashes and brackets, none of which split the statement
• a foreign key pointing at store, a table this dump does not contain — drawn as a stub rather than dropped

The diagram

The file

This is the project's MySQL test fixture, in full and unedited. Everything above was produced from it.

-- MySQL dump 10.13  Distrib 8.0.36, for macos14.2 (arm64)
--
-- Shaped like mysqldump output: backticks, version-gated /*! */ comments,
-- inline keys, and a foreign key to a table this file does not define.
--
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8mb4 */;

DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
  `customer_id` smallint unsigned NOT NULL AUTO_INCREMENT,
  `store_id` tinyint unsigned NOT NULL,
  `first_name` varchar(45) NOT NULL,
  `last_name` varchar(45) NOT NULL,
  `email` varchar(50) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `notes` text COMMENT 'free text, may contain ; and -- and even ) characters',
  `create_date` datetime NOT NULL,
  PRIMARY KEY (`customer_id`),
  UNIQUE KEY `idx_email` (`email`),
  KEY `idx_fk_store_id` (`store_id`),
  FULLTEXT KEY `idx_names` (`first_name`,`last_name`),
  CONSTRAINT `fk_customer_store` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS `payment`;
CREATE TABLE `payment` (
  `payment_id` smallint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` smallint unsigned NOT NULL,
  `amount` decimal(5, 2) NOT NULL,
  `payment_date` datetime NOT NULL,
  PRIMARY KEY (`payment_id`),
  CONSTRAINT `fk_payment_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`customer_id`)
) ENGINE=InnoDB;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;