What SQL do I need to provide?

Paste one or more CREATE TABLE statements, including PRIMARY KEY and FOREIGN KEY constraints. The tool parses column names, types, nullability, and relationships to lay out the diagram automatically.

How are relationships detected?

Foreign key constraints in your CREATE TABLE statements are parsed and drawn as connecting edges between tables, labelled with the source and target column names.

Which SQL dialect is supported?

Standard ANSI SQL DDL is supported, including common MySQL and PostgreSQL conventions such as AUTO_INCREMENT, SERIAL, ENUM, and inline or trailing FOREIGN KEY definitions.

Is my schema sent to a server?

No. Parsing and diagram generation both run entirely in your browser — your SQL never leaves your machine.

ER Diagram Generator | ProDevTools

SQL SchemaPaste CREATE TABLE statements — processed locally

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(100) NOT NULL,
  email VARCHAR(255) NOT NULL UNIQUE,
  password_hash VARCHAR(255) NOT NULL,
  role ENUM('admin','user','guest') DEFAULT 'user',
  is_active TINYINT(1) DEFAULT 1,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE categories (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  slug VARCHAR(100) NOT NULL UNIQUE,
  parent_id INT,
  FOREIGN KEY (parent_id) REFERENCES categories(id)
);

CREATE TABLE products (
  id INT AUTO_INCREMENT PRIMARY KEY,
  category_id INT NOT NULL,
  name VARCHAR(255) NOT NULL,
  description TEXT,
  price DECIMAL(10,2) NOT NULL,
  stock_qty INT DEFAULT 0,
  created_by INT NOT NULL,
  FOREIGN KEY (category_id) REFERENCES categories(id),
  FOREIGN KEY (created_by) REFERENCES users(id)
);

CREATE TABLE orders (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_id INT NOT NULL,
  status ENUM('pending','processing','shipped','delivered','cancelled') DEFAULT 'pending',
  total_amount DECIMAL(10,2) NOT NULL,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (user_id) REFERENCES users(id)
);

CREATE TABLE order_items (
  id INT AUTO_INCREMENT PRIMARY KEY,
  order_id INT NOT NULL,
  product_id INT NOT NULL,
  quantity INT NOT NULL,
  unit_price DECIMAL(10,2) NOT NULL,
  FOREIGN KEY (order_id) REFERENCES orders(id),
  FOREIGN KEY (product_id) REFERENCES products(id)
);

Paste your SQL schema above to generate a diagram

Or click Load Sample to see a demo

Visualize your database schema instantly

Turn raw CREATE TABLE statements into a clear, interactive entity-relationship diagram. See every table's columns, types, and keys at a glance, with foreign key relationships drawn as labelled connections — all rendered locally in your browser.

Frequently Asked Questions

What SQL do I need to provide?: Paste one or more CREATE TABLE statements, including PRIMARY KEY and FOREIGN KEY constraints. The tool parses column names, types, nullability, and relationships to lay out the diagram automatically.
How are relationships detected?: Foreign key constraints in your CREATE TABLE statements are parsed and drawn as connecting edges between tables, labelled with the source and target column names.
Which SQL dialect is supported?: Standard ANSI SQL DDL is supported, including common MySQL and PostgreSQL conventions such as AUTO_INCREMENT, SERIAL, ENUM, and inline or trailing FOREIGN KEY definitions.
Is my schema sent to a server?: No. Parsing and diagram generation both run entirely in your browser — your SQL never leaves your machine.

Visualize your database schema instantly

Frequently Asked Questions

Related Tools