SQL to ER Diagram
Home › MariaDB

MariaDB to ER Diagram

Paste your MariaDB CREATE TABLE statements (or a mysqldump) and get an interactive entity-relationship diagram — tables, columns, keys and foreign keys, drawn automatically.

Open the diagram tool →
No signup · nothing uploaded · export PNG / SVG / Mermaid / DBML · shareable link

How it works

  1. Dump your schema with mysqldump --no-data your_db (MariaDB ships the same client), or copy your CREATE TABLE statements.
  2. Paste it into the editor — the SQL is parsed automatically.
  3. Every table renders with its columns; FOREIGN KEY constraints become relations.
  4. Arrange, hide tables, then export PNG/SVG or share a link.

Example

A MariaDB schema like this:

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  email VARCHAR(255) NOT NULL UNIQUE
) ENGINE=InnoDB;

CREATE TABLE posts (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_id INT,
  FOREIGN KEY (user_id) REFERENCES users(id)
) ENGINE=InnoDB;

…renders two tables with a relation from posts.user_idusers.id. Try it with your own →

Why use it

MariaDBMySQLPostgreSQLSQLite

FAQ

Does it work with MariaDB dumps?

Yes — MariaDB uses the same CREATE TABLE / mysqldump syntax as MySQL. Paste the schema dump and tables + foreign keys are drawn instantly.

Is my schema uploaded anywhere?

No. Everything runs locally in your browser — your schema is never uploaded to or stored on any server.

Can I export the diagram?

Yes — export a high-resolution PNG or vector SVG, copy the schema as Mermaid, DBML or PlantUML, or share a link that encodes the whole diagram in the URL.

Is it free?

Yes. It is completely free and open source, with no account or sign-up required.

Related