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.
- Free, no sign-up
- Nothing is sent to a server
- Worldwide
How to use ER Diagram Maker online
- Paste the SQL. The CREATE TABLE statements.
- Check the table list. Keys and relations.
- Read the picture. PK, FK and lines.
- 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?
Why is a relation missing?
Can it read a dump with data?
How are composite keys shown?
Can I drag the boxes around?
Can anyone see the text I put into the ER Diagram Maker?
Can I save what the ER Diagram Maker gives me?
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.