MySQLFreeNo Sign-Up

Free MySQL Schema Visualizer

Upload a .sql MySQL dump or paste your DDL directly and get an interactive ER diagram in seconds. No database server needed, no sign-up required, and your schema never leaves your browser.

What MySQL syntax is supported?

GraphMyDB parses all standard MySQL DDL. Here is what the parser handles:

CREATE TABLE

Full support including inline column definitions, data types (INT, VARCHAR, TEXT, DATETIME, ENUM, SET, etc.), and table options.

AUTO_INCREMENT

Detected automatically and displayed as a constraint badge on the column.

FOREIGN KEY

Inline REFERENCES, standalone CONSTRAINT ... FOREIGN KEY, and ALTER TABLE ADD FOREIGN KEY are all parsed into visual edges.

ALTER TABLE

ADD COLUMN, ADD INDEX, ADD FOREIGN KEY, MODIFY COLUMN, and CHANGE COLUMN all update the diagram.

Indexes

PRIMARY KEY, UNIQUE, INDEX, KEY — both inline and standalone — are shown in each table node.

ENGINE & Options

ENGINE=InnoDB, DEFAULT CHARSET, and other table options are parsed and ignored without errors.

Example MySQL schema

Paste this into the tool or upload your own .sql file:

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(50) NOT NULL UNIQUE,
  email VARCHAR(100) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE posts (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_id INT NOT NULL,
  title VARCHAR(200) NOT NULL,
  body TEXT,
  published_at DATETIME,
  FOREIGN KEY (user_id) REFERENCES users(id)
);

CREATE TABLE comments (
  id INT AUTO_INCREMENT PRIMARY KEY,
  post_id INT NOT NULL,
  user_id INT NOT NULL,
  content TEXT NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (post_id) REFERENCES posts(id),
  FOREIGN KEY (user_id) REFERENCES users(id)
);

How it works

1

Upload or paste

Drop a .sql file or paste MySQL DDL directly into the code editor.

2

See the diagram

Tables, columns, data types, constraints, and foreign key relationships appear as an interactive ER diagram.

3

Explore and export

Click a table to focus its relationships, click a column to trace a specific link, then export as PNG, SVG, SQL, or Excel.