S
DesignSQL
Now with AI Schema Assistant

Code & Visualize Your Database Schemas in Real-Time

A DBML-based database schema editor that blends code and ER diagrams. Write schemas, see the diagram instantly, and collaborate seamlessly.

No credit cardFree forever plan< 10s setup
Section · 03 / Compatibility

Native support for top databases.

Plug straight into the engines your team already runs. No adapters. No translation layers. Schemas, types, and transactions stay exactly as you wrote them.

Engines · 3 supported

01 / 03
01 · Relationalv16.xPostgreSQL
Open Source SQL

PostgreSQL

147data types
99.99%uptime
02 · Relationalv8.xMySQL
Open Source SQL

MySQL

112data types
99.97%uptime
03 · Enterprise2022MSSQL
Enterprise SQL

MSSQL

134data types
99.95%uptime
100+ Data Types// JSONB, arrays, geo, vectors, intervals — all preserved end-to-end.
Zero-Config Sync// Detects schema. Maps types. Replays writes. No DDL rewrites.
ACID-Safe// Transactions remain transactional. Constraints stay constrained.
Bring Your Driver// Use existing client libs. We talk the wire protocol, not a wrapper.
How it works · 4 steps

From SQL soup to schema that works.

An empty canvas becomes a fully documented database in three steps. No setup, no config — just type and watch.

Step 01Write
schema.dbml
01 02 03 04 05 06 07 08
Table users {
id int [pk]
email varchar [unique]
name varchar
}
Ref: students.class_id > classes.id

Write or import

Type DBML in our editor, or drag in an existing SQL dump. We parse it instantly — no config, no migrations required.

Try it now
Step 02No-Code
Tables
+ Table+ Enum
▼students
idINTPK×
full_nameVARCHAR(100)×
birth_dateDATE×
class_idINT×
created_atTIMESTAMP×
+ Add column
▶teachers
▶classes
▶subjects
▶schedules

Or use Table Panel

Prefer a visual approach? Add tables, edit columns, pick types from a dropdown — all without writing a single line of code.

Try it now
Step 03Visualize
usersidintemailstrnamestrcreatedpostsidauthor_idfktitlestrbodytxttagsidintnamestrslugstrAUTO-LAYOUT

Auto-diagram

Watch your schema draw itself. Relationships snap into place, tables auto-layout, and every edit stays in sync.

Try it now
Step 04Ship
export → schema.sqldone
dbml push --prod
live
share → read-only linkqueued
team · 4 reviewers

Sync & share

Export back to SQL, push via CLI, or hand your team a read-only link. Everyone stays on the same schema.

Try it now
Try it free
Tables
students
teachers
classes
.No Code
.dbml
01
02
03
04
05
Table users {
  id int [pk]
  email str
  name str
}
“”

From code to diagram,
from click to schema
design your way,
in seconds.

THE DBML PHILOSOPHY
.diagramusersidintemailstrnamestrpostsidintauthorintbodystrtagsidintnamestr
type DBMLORclick table panelparserenderexportship in < 10s
Features · 13 tools

Design Databases Without Limits

app.designsql.cloud · auto
13/13
Auto

Save & Auto-Save

Manual save anytime, plus automatic saves every 5 minutes in the background. Visual indicators show unsaved, saving, and saved states so you always know where you stand.

Save Status
✓
schema_v3.dbml
just now
saved
↻
schema_v3.dbml
5 min ago
auto-saved
✓
schema_v2.dbml
1 hour ago
saved
Next auto-save in 4:32Active
app.designsql.cloud · cli
12/13
CLI

Sync CLI — Push & Pull

Use the @designsql/sync CLI to push and pull schemas between your database and DesignSQL. Keep your development database and visual documentation always in sync.

terminalzsh
$ npx @designsql/sync push
→ Connecting to prod_db...
→ Schema diff: +3 tables, -1 column
→ Migration generated ✓
→ Pushing changes...
──────────────────────
$ npx @designsql/sync pull
→ Up to date · last sync 2m ago
app.designsql.cloud · import
11/13
Import

Import from Databases

Already have a running database? Import schemas from PostgreSQL, MySQL, MSSQL or DBML using our CLI tool.

Import Sources
P
PostgreSQL
24 tables detected
imported
M
MySQL
18 tables detected
imported
O
Oracle
31 tables detected
pending
CLI connected · auto-detect on
app.designsql.cloud · export
10/13
Export

Export to Multiple Formats

Export your schema to PostgreSQL, MySQL, MSSQL, Oracle SQL, DBML, or JSON. Export diagrams as SVG, PNG, or JPG. Preview before downloading, or copy straight to clipboard.

export · multi-format
$ designsql export --all
PostgreSQL.sqldone
MySQL.sqldone
DBML.dbmldone
JSON.jsonqueued
SVG Diagram.svgqueued
3/5 completed · clipboard ready
app.designsql.cloud · settings
09/13
Settings

Customizable Editor

Choose from 9 editor themes, 4 diagram styles, 8 monospace fonts, and fine-tune font size, word wrap, line numbers, and tab size. Settings sync across all your devices.

Customizable Editor — DesignSQL database schema design feature
app.designsql.cloud · docs
08/13
Docs

Documentation

Write rich-text documentation linked directly to each table — no need for separate Notion or Confluence pages. Reference columns with @mentions that link back to the diagram.

Documentation — DesignSQL database schema design feature
app.designsql.cloud · sharing
07/13
Sharing

Share Read-Only Preview

Generate a read-only preview link in one click. Share with clients, reviewers, or stakeholders — no account required. The link always shows the latest version.

Share Read-Only Preview — DesignSQL database schema design feature
app.designsql.cloud · team
06/13
Team

Team Collaboration

Invite team members to work on schemas together. Assign Owner, Editor, or Viewer roles. Every change is tracked with the contributor's name in the history.

Team Collaboration — DesignSQL database schema design feature
app.designsql.cloud · versioning
05/13
Versioning

Versions & Change History

Create named version tags for milestones, compare two versions side-by-side with code diffs or visual diagram comparison, and revert to any point in your history with one click.

Versions & Change History — DesignSQL database schema design feature
app.designsql.cloud · panel
04/13
Panel

Table Panel — No Code

Prefer a visual interface? Add, edit, and delete columns from a structured panel. Choose from 100+ data types across standard databases — changes sync to code and diagram automatically.

Table Panel — No Code — DesignSQL database schema design feature
app.designsql.cloud · diagram
03/13
Diagram

Interactive Visual Diagram

More than just a picture. Drag tables anywhere, draw relationships between columns, change cardinality with a click, and auto-layout your entire schema in one step.

Interactive Visual Diagram — DesignSQL database schema design feature
app.designsql.cloud · ai
02/13
AI

AI Schema Assistant

Describe what you need in plain English. The AI assistant will understand your intent and write the perfect DBML code or directly layout relationships, turning your ideas into working databases instantly.

AI Schema Assistant — DesignSQL database schema design feature
app.designsql.cloud · editor
01/13
Editor

DBML Editor + Real-Time Diagram

Your diagram updates in real-time as you type. Syntax highlighting, error markers, smart autocomplete, and ready-to-use snippets included.

DBML Editor + Real-Time Diagram — DesignSQL database schema design feature
app.designsql.cloud · ~/projects/api/
Live

Backend Developers

For people who live in the editor

role · 01/05

Design and document your database schema before writing a single line of code. DBML, PostgreSQL, MySQL, and MSSQL — with schema versioning and SQL export built in.

DBMLPostgresMySQLMSSQL
schema.dbml
01
02
03
04
05
06
07
08
Table users {
id int [pk, increment]
email varchar [unique, not null]
role enum('admin', 'user')
created_at timestamp
}
// auto-save on 5 minutes
usersidintemailstrrolecreatedpostsidauthor_idfktitlebodytagsidnameslug
History↻
Manual Save
just nowSarah
Auto Save (5m)
2h agoSarah
Auto Save (5m)
2d agoJordan
Manual Save
3d agoAlex
Version
maindef.
Sarah Chen ...
tag-1
Alex Rivera...
Manage Collaboration
Invite
Search by name...
Editor
Invite
Members (2)
S
Sarah Chen
sarah@designsql.cloud
Owner
A
Alex Rivera
alex@designsql.cloud
Editor
designsql.cloud/preview?token=a1f165...
Read-only
studentsid INTnameemailenrollmentsidstudent_id FKclass_id FKstatuspaymentsamountpaid_at
Identity
Academic
+
-
Diagrami
+ Add Table
Add Group
familiesid INTaddress VARCHARcitizensid INTfamily_id FK
1:1
1:N
N:1
Delete
+
-
↺
Auto-save every 5 minutesExplore the editor
Testimonials · wall of love

Loved By
Developers

See how engineering teams are transforming their database design workflows and eliminating schema synchronization issues.

feedback / @backend_dev.md
>
Finally a tool that truly connects DBML code and visual diagrams. Previously we had to use two different tools and they were never perfectly in sync.

Backend Engineer

SaaS Startup
feedback / @data_architect.md
>
Version tags completely changed how we review database designs. Being able to compare two schema versions side-by-side before merging is a lifesaver.

Lead DBA

Fintech Corporation
feedback / @sql_wizard.md
>
The read-only preview link feature is amazing. My clients can view the latest diagram without needing an account or waiting for a PDF export.

Freelance Database Architect

Independent
Pricing · simple & clear

Pick Your Plan,
Your Rules.

Simple pricing, no drama. Choose the plan that fits your workflow. Start for free and upgrade when you need to.

plan / free.yml

Free

For individuals just getting started or working on small projects.

$0
  • Up to 10 projects
  • Up to 10 tables per project
  • Up to 3 versions per project
  • Export (SQL/DBML/JSON/Image)
  • Read-only preview links
  • Documentation
  • 100 change history
  • Team collaboration
Start for Free
Most Popular
plan / pro.yml

Pro🚀

For professional developers and database architects.

$8/mo
  • Unlimited projects
  • Unlimited tables
  • Unlimited versions
  • 100 change history
  • Export (SQL/DBML/JSON/Image)
  • Read-only preview links
  • Documentation
  • Team collaboration
Upgrade to Pro
plan / team.yml

Team

For engineering teams building a single source of truth.

$12/mo
  • Everything in Pro
  • Unlimited team members
  • Owner, Editor, Viewer roles
  • Contributor change history
  • Shared team workspaces
  • Priority support
Get Team Plan
Yes. The FREE plan is available forever without a credit card. You can create up to 10 projects with 10 tables per project.
Was this helpful?
getting-started
CTA · get started in 30s
— //product
v2.4
lang: DBML
engine: postgres · mysql . mssql
S
schema.dbml
DESIGNSQL© 2026 · v2.4.1
/ get-started / build

Start designing
your database
schema today.

Draft ER diagrams, write DBML in plain text, and collaborate with your team in real-time. No credit card, no install — open a tab, design a schema.

Start building now
No credit card10 projects freeExport SQL & PNG