ERD Studio

Design Your Database,
Visually and Instantly

Create professional ERD diagrams with drag-and-drop simplicity. Generate SQL for MySQL, PostgreSQL, Oracle, and MSSQL in seconds.

Get Started FreeView Features
ERD Studio
users
User accounts
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
+
id
bigint
Primary key
−
email
varchar(255)
Login email
−
username
varchar(50)
Display name
−
password_hash
varchar(255)
Bcrypt hashed
−
created_at
timestamp
now()
Registration date
−
SQL / Menu ▼
IXUQ💬
categories
Product categories
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
+
id
bigint
Primary key
−
name
varchar(100)
Category name
−
slug
varchar(100)
URL identifier
−
sort_order
int
0
Display order
−
SQL / Menu ▼
IXUQ💬
orders
Customer orders
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
+
id
bigint
Primary key
−
user_id
bigint
FK → users
−
total_amount
decimal(12,2)
0.00
Order total
−
status
varchar(20)
'pending'
Order status
−
ordered_at
timestamp
now()
Order placed
−
SQL / Menu ▼
IXUQ💬
products
Product catalog
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
+
id
bigint
Primary key
−
category_id
bigint
FK → categories
−
name
varchar(200)
Product title
−
price
decimal(10,2)
0.00
Selling price
−
stock
int
0
Available qty
−
is_active
boolean
true
Published
−
SQL / Menu ▼
IXUQ💬
order_items
Order line items
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
+
id
bigint
Primary key
−
order_id
bigint
FK → orders
−
product_id
bigint
FK → products
−
quantity
int
1
Item count
−
unit_price
decimal(10,2)
Price snapshot
−
SQL / Menu ▼
IXUQ💬
reviews
Product reviews
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
+
id
bigint
Primary key
−
user_id
bigint
FK → users
−
product_id
bigint
FK → products
−
rating
tinyint
1-5 stars
−
content
text
Review body
−
created_at
timestamp
now()
Posted date
−
SQL / Menu ▼
IXUQ💬
Secure by Default
Fast & Responsive
4 DB Engines
Free to Start

Everything You Need for Database Design

Powerful tools to design, generate, and manage your database schemas — all in one place.

Visual ERD Editor

Drag-and-drop table design with auto-layout, column editing, and real-time relationship visualization.

Multi-DB SQL Generation

Generate production-ready DDL for MySQL, PostgreSQL, Oracle, and MSSQL with a single click.

SQL Import & Reverse Engineering

Paste your CREATE TABLE SQL and instantly generate an ERD diagram. Supports ALTER SQL too.

Data Dictionary

Manage term, type, and word dictionaries to keep naming consistent across your entire schema.

Share & Collaborate

Generate secure read-only share links with expiration. No account needed for viewers.

Version Management

Create schema snapshots, compare versions side-by-side, and restore any previous state.

Simple, Transparent Pricing

Start for free. Upgrade when you need more.

Free

$0

For students and hobby projects

  • Up to 3 projects
  • Up to 10 tables per project
  • SQL export
Get Started Free

Plus

$9/mo

For individual developers

  • Up to 10 projects
  • Up to 30 tables per project
  • SQL export
  • Excel export
  • Up to 1 team member(s)
Most Popular

Pro

$19/mo

For power users and freelancers

  • Unlimited projects
  • Unlimited tables per project
  • SQL export
  • Excel export
  • Image export
  • Up to 3 team member(s)

Team

$49/mo

For teams and organizations

  • Unlimited projects
  • Unlimited tables per project
  • SQL export
  • Excel export
  • Image export
  • Unlimited team members

All prices include tax.

Frequently Asked Questions

Got questions? We have answers.

Start Designing Your Database Today

Join developers who use ERD Studio to design better databases, faster.

Get Started FreeView Features