Menu
PDF Tools
Image Tools
Converters & Utilities
Seller & Print Tools
Accounting & Business
Calculators
Text & Writing Tools
Developer & Web Tools
Creator & Social Tools
Browser Utilities & Games
Document & Design Makers
Text & Developer Tools
Exam & Form Tools

ER Diagram Maker

Paste the CREATE TABLE statements of your database and the page draws each table as a box with its columns, marks primary and foreign keys, and draws a line for every relation between the tables.

How to use ER Diagram Maker online

  1. Paste the SQL. The CREATE TABLE statements.
  2. Check the table list. Keys and relations.
  3. Read the picture. PK, FK and lines.
  4. Download SVG or PNG. Use the buttons below.

Why use this free ER Diagram Maker

  • Reads CREATE TABLE
  • Primary and foreign keys
  • Relation lines
  • Summary table
  • SVG and PNG download
  • SQL stays in your browser

From SQL to a picture

An entity relationship diagram shows the tables of a database and how they link. Drawing it by hand is slow, and the SQL already holds the facts. This page reads your CREATE TABLE statements and draws a box for each table, with the column names and types, laid out in a grid.

What it reads

It reads column names and types, primary keys written on a column or as a table rule, and foreign keys written as a table rule or inline with a references clause. Quotes and backticks around names are accepted, and comments, unique keys and indexes are skipped. The syntax of MySQL and MariaDB, and of Postgres in its common forms, is understood.

Keys and lines

A column in the primary key is shown in bold with the letters PK, and a column that points to another table shows FK. A curved line joins the foreign key column to the key it refers to, with a dot at the referenced end. A relation to a table that is not in your text is not drawn, and the summary counts the lines that were.

Table of tables

Under the picture, a table lists each table with its number of columns, its primary key and its foreign keys, which is a quick way to check that the SQL was read as you meant. Download the drawing as SVG for documents and vector editors, or as PNG for slides.

Limits

Boxes are placed in a grid and cannot be dragged, and long schemas make a large picture, so the page accepts up to thirty tables. Many-to-many links through a join table show as two relations. Views, triggers and other statements are ignored. The SQL is read in your browser and never sent anywhere.

Using the tool

As you type in the ER Diagram Maker, the result appears at once. Open a text file into the box, or drop one on it.

ER Diagram Maker: frequently asked questions

Does the page log in to a database?
No. You paste the SQL text, and the page reads it in your browser.
Why is a relation missing?
The table it points to is not in the pasted text, or the foreign key could not be read.
Can it read a dump with data?
It reads the CREATE TABLE parts and ignores the rest, though a very large dump is slow to paste.
How are composite keys shown?
Every column of the key is marked PK.
Can I drag the boxes around?
No, the boxes sit in a fixed grid.
Can anyone see the text I put into the ER Diagram Maker?
No copy is made on a server; the ER Diagram Maker runs in your browser.
Can I save what the ER Diagram Maker gives me?
Copy the ER Diagram Maker result, or save it as a text file from the result box.

Related searches for ER Diagram Maker

  • ER Diagram Maker online
  • free ER Diagram Maker
  • ER Diagram Maker online free
  • ER Diagram Maker for mobile
  • ER Diagram Maker without sign up
  • ER Diagram Maker – Developer & Web Tools

ER Diagram Maker is a free online tool on MAITBOX, in the Developer & Web Tools group. It runs in your browser, so what you type is not sent to a server. It works on Android and iPhone, and on Windows, Mac and Linux, with no download and no account.

More tools in Developer & Web Tools →

Search tools