Tool for Making ER Diagrams: 8 Free Options (2026)
November 11, 2026 · 11 min read
Tool for Making ER Diagrams: 8 Free Options Compared
The right tool for making ER diagrams depends on one choice: do you want to drag boxes around a canvas, or type text and let the tool draw? draw.io is the strongest free canvas and needs no account. dbdiagram.io and Mermaid turn a few typed lines into a diagram. Below, we compare eight free options and pick one per use case.
Drag-and-Drop vs Diagram-as-Code: Two Kinds of ER Diagram Tools
Every ER diagram tool in this list falls into one of two camps. Canvas tools give you a shape library and a blank page. You place each table, draw each connector and decide exactly where everything sits.
Diagram-as-code tools work the other way round. You type tables and relationships in a small text syntax, and the tool lays out the picture for you. Changing a column means editing one line, not nudging boxes.
The trade-off is control versus speed. A canvas suits people who think visually, classmates who don't code, and posters where layout matters. Text suits developers, because the source is short, diffable and can sit in Git next to the schema it describes.
This post assumes you already know what entities and relationships are. It compares tools, not notation.
draw.io (diagrams.net): Free Drag-and-Drop With an Entity Relation Library
draw.io is the free canvas we'd try first. Its homepage promises no account and no credit card, and the source code is Apache 2.0 licensed. It runs in the browser at app.diagrams.net and as a desktop app.
For ER work, open More Shapes and enable the Entity Relation library in the Software section. It adds table shapes with key rows plus crow's foot connectors. You can save to your device, your browser, Google Drive, OneDrive, GitHub or GitLab, and export PNG, SVG, JPEG, PDF, HTML or the editable .drawio XML.
There's a shortcut for existing schemas too. Per the draw.io SQL docs, Arrange > Insert > Advanced > SQL turns pasted CREATE TABLE code into table shapes.
- Strength: completely free, your files stay wherever you choose to store them, and you get every export format you're likely to need.
- Weakness: the SQL insert creates tables but not the lines between them, so you still connect every relationship by hand.
Lucidchart and ERDPlus: Browser Diagramming for Classes and Teams
Lucidchart is a polished commercial canvas with an Entity Relationship shape library. You need a free account to start. Its ERD page describes a data import that places database tables on the canvas and SQL generation for MySQL, PostgreSQL, SQL Server and Oracle. It doesn't say which plans include them, and free plan limits change, so check the pricing page before you rely on either.
Lucidchart's real strength is real-time co-editing, which suits a team mapping a schema in a meeting. The weakness is the account wall: it's the only tool here you can't try before signing up.
ERDPlus is the opposite: a plain web modeller that says it has no paid features. It supports Chen and crow's foot notation, star schemas, and a one-click conversion from an ER diagram to a relational schema. You can export PNG images and SQL scripts, and save diagrams to its server.
That conversion step mirrors what many database courses ask for, which makes ERDPlus a solid free ER diagram tool for assignments. Its weakness is the other direction: its site lists no SQL import, so you can't start from a schema you already have.
dbdiagram.io and QuickDBD: Write Text, Get an ER Diagram
These two are the classic text-first options. You type the schema, and the diagram redraws as you go.
dbdiagram.io reads DBML, an open-source language for describing database structure. Here's a three-table event ticketing schema, using the syntax from the DBML docs:
Table attendees {
id integer [pk]
name varchar
email varchar [unique]
}
Table events {
id integer [pk]
title varchar
starts_at timestamp
}
Table tickets {
id integer [pk]
attendee_id integer [ref: > attendees.id]
event_id integer [ref: > events.id]
seat varchar
}
dbdiagram draws three table cards with their columns and links each foreign key to the id it points at. The > means many-to-one: many tickets belong to one attendee. Its pricing page lists up to 10 diagrams on the free plan, with PDF, PNG and SVG export plus SQL import and export.
QuickDBD uses its own plain-text syntax and needs no registration to try. The free Basic plan allows one diagram of up to 10 tables, and exports cover images, SQL and PDF. That's fine for a homework schema and tight for anything real.
How Do You Make an ER Diagram With Mermaid?
Mermaid is a free, MIT-licensed diagram language, and erDiagram is one of its built-in types. You write it inside a fenced code block tagged mermaid. Here's the same ticketing schema:
```mermaid
erDiagram
ATTENDEE ||--o{ TICKET : buys
EVENT ||--o{ TICKET : issues
ATTENDEE {
int id PK
string name
string email
}
EVENT {
int id PK
string title
datetime starts_at
}
TICKET {
int id PK
int attendee_id FK
int event_id FK
string seat
}
```
It renders as three boxes, each listing its columns with PK and FK markers. ATTENDEE and EVENT each connect to TICKET with a crow's foot line: exactly one on the parent side, zero or more on the ticket side. The full marker set is in the Mermaid ER syntax reference, and our guide to Mermaid diagrams in Markdown covers the basics. Our Mermaid ER diagram syntax guide goes deeper on keys, quoting and line styles.
Because it's plain Markdown, the diagram works wherever Mermaid does. Per GitHub's diagram docs, a mermaid block draws as a diagram in your repository's .md files and in comments on issues and pull requests. It also renders live in our Markdown editor, with the source on the left and the preview on the right. Try it in the live demo below.
Need an image file instead of a Markdown page? Our Mermaid editor runs in your browser with sample templates and themes, and exports the diagram as PNG or SVG.
Open-Source ER Diagram Tools You Can Self-Host: drawDB and ChartDB
Two newer canvas tools are worth knowing if you'd rather not hand your schema to a hosted service. Both are AGPL-3.0 licensed, run in the browser, and ship Docker instructions in their READMEs.
drawDB is a drag-and-drop ER diagram design tool that works without an account. Its site lists import and export for MySQL, PostgreSQL, SQLite, MariaDB, SQL Server, Oracle and a generic dialect, so you can draw a schema and download working DDL. Sign-in only matters for its Pro features, such as cloud sync and team collaboration. To self-host, its README builds an image with docker build -t drawdb . and serves it on port 3000.
ChartDB starts from a database that already exists. You pick your engine, run one "Smart Query" it gives you, and paste the JSON result back. The README lists PostgreSQL, MySQL, SQL Server, MariaDB, SQLite, CockroachDB and ClickHouse, and its tagline says no database password is required. It's still marked as a public beta, and its AI-assisted DDL export needs an OpenAI key or your own model endpoint when you self-host.
Can You Generate an ER Diagram From an Existing Database?
Yes, and you've already met most of the routes. ChartDB reads your live schema through its query. dbdiagram.io, drawDB and draw.io accept pasted CREATE TABLE scripts.
Database clients do it too. DBeaver builds diagrams for existing tables and schemas, and MySQL Workbench can reverse-engineer a database from a create script or a live MySQL server. Our ER diagram SQL guide walks through those steps for DBeaver, Workbench and SSMS.
Pick the route by access: a pasted script works offline, while ChartDB and the database clients need a connection or a query run against your server.
Free ER Diagram Tools Compared Side by Side
Every value below comes from each tool's own docs, README or pricing page as of November 2026. "Not listed" means we couldn't confirm it, not that the feature is missing.
| Tool | Input | Account to start | Price and licence | Export | SQL import |
|---|---|---|---|---|---|
| draw.io | Canvas | No | Free, Apache 2.0 | PNG, SVG, JPEG, PDF, HTML, XML | Yes, as table shapes |
| Lucidchart | Canvas | Yes | Free plan, paid tiers | SQL per its ERD page | Data import, plan not stated |
| ERDPlus | Canvas | No, to try it | Free, no paid features | PNG, SQL | Not listed |
| dbdiagram.io | DBML text | No, for its quick generator | Free plan of 10 diagrams | PDF, PNG, SVG, SQL | Yes |
| QuickDBD | Plain text | No, to try it | Free plan of 1 diagram | Images, SQL, PDF | Not listed |
| Mermaid | Markdown text | No | Free, MIT | Depends on the renderer | No |
| drawDB | Canvas | No | Free, AGPL-3.0 | SQL in 7 dialects, JSON, image | Yes |
| ChartDB | Canvas plus query | No | Free, AGPL-3.0 | SQL, image | Yes, via its query |
Two patterns stand out. The open-source tools give you the most for free, and the text tools produce the source files that are easiest to review in a pull request.
Which Tool for Making ER Diagrams Should You Pick?
Match the tool to the job rather than chasing the longest feature list:
- Student assignment in Chen notation: ERDPlus, or draw.io if you want full layout control.
- Developer designing a new schema: dbdiagram.io for fast typing, drawDB if you'd rather draw and export DDL.
- Diagram that lives in a README or docs site: Mermaid, reviewed in pull requests like any other text.
- Team whiteboarding a schema live: Lucidchart, for its co-editing.
- Mapping a database you inherited: ChartDB.
We prefer Mermaid for any diagram that sits in documentation. The diagram is plain text, so it changes in the same commit as the schema and is far less likely to drift out of date. Our guide to writing documentation in Markdown shows how that fits into a docs folder.
Mermaid has a real limit, though. Its automatic layout gives you little say over where entities land. In our experience, once a schema passes about 15 tables, the lines start crossing and the result gets hard to read. At that size, a canvas tool like draw.io or drawDB is the better fit.
Any tool for making ER diagrams on this list will draw a clean schema, so pick by where the diagram has to live. Use a canvas when layout matters and a text syntax when the diagram belongs next to your code. For Markdown docs, write an erDiagram block in our editor and watch it render as you type, or open the Mermaid editor to export a PNG or SVG.