Try DrawSQL
Features Pricing Templates
Log in Sign up

ER diagrams that know your SQL.

Paste SQL, describe it to AI, or draw from scratch.

Start drawing — free

600,000+ developers — including teams at

Storytel Instacart Cisco Accenture
DrawSQL editor showing a content platform schema with color-coded table groups (Core, Content, Social) and foreign key relationships

How it works

Three ways to build an ERD

Most ERD tools give you one way in. We give you three — pick whichever matches what you already have.

Paste SQL — see the diagram

Have existing CREATE TABLE statements? Paste them in. DrawSQL auto-detects MySQL, PostgreSQL, or SQL Server and renders your ERD in seconds.

Paste your SQL

Ask AI — get a schema

Describe your application in plain English. DrawSQL's AI designs the schema — tables, columns, relationships, constraints. Review and refine from there.

Describe your app

Design from scratch

Start with a blank canvas. Add tables, define columns, draw foreign keys. Drag to arrange, group by domain, annotate with sticky notes.

Open the editor

Templates

See what real schemas look like

200+ schemas from real apps — CMS, e-commerce, SaaS, business tools. Borrow one to start, or just browse for ideas.

Browse all 200+ templates
WordPress

WordPress

PHP Content Management System

 Django

Django

Python web framework

 Koel

Koel

Open source music streaming server

 Monica

Monica

Open source personal CRM

 Sylius

Sylius

eCommerce Platform

 Akaunting

Akaunting

Accounting and invoicing software

 BookStack

BookStack

Simple & Free Wiki Software

 Flarum

Flarum

Simple forum software

 Wagtail

Wagtail

Django CMS

 SaaS Pegasus

SaaS Pegasus

Django-powered SaaS template

 Snipe-IT

Snipe-IT

IT asset/license management system

 Laravel Spark (Stripe)

Laravel Spark (Stripe)

SaaS subscription billing boilerplate for Laravel

On a team?

Design schemas as a team

Real-time multiplayer, shared diagrams, sticky-note reviews, and AI chat — so the database doesn’t live in one person’s head.

See team plans

FAQ

Frequently asked questions

An ERD (Entity Relationship Diagram) shows database tables, their columns, and the foreign-key relationships between them — typically used for schema design, documentation, and onboarding. Also called a database relationship diagram.
Yes. Paste your CREATE TABLE statements into DrawSQL and the tool renders an interactive ERD automatically. It supports MySQL, PostgreSQL, and SQL Server syntax, with auto-detection of the SQL dialect.
DrawSQL supports MySQL, PostgreSQL, and SQL Server — each with its native column types, constraints, and syntax. You can also export your schema as Laravel or AdonisJS migrations.
Yes. You can design ERD diagrams with up to 20 tables, no signup required. Your work saves automatically in your browser. Create a free account to save diagrams permanently. Paid plans add real-time collaboration, AI chat, and unlimited diagrams.
Yes. DrawSQL's paid team plans include real-time multiplayer editing — see teammates' cursors, edits appear instantly, and leave sticky notes on tables.

Yes. AI can generate migrations quickly, but it does not give your team a shared mental model of the database.

The migration changes the schema. The ERD explains it: which tables belong together, which relationships are foundational, and which parts of the data model are safe to change.

That matters when you are onboarding a developer, reviewing an AI-generated change, or planning a feature across multiple tables.

Still reading?

Draw it. Then decide if it’s worth saving.

Up to 20 tables on the free tier. Save to an account when it becomes useful.

Create an account Try the editor