🗺️ Schema Visualizer

Generate ERD summaries and Mermaid diagrams from SQL DDL

SQL DDL input

users

idINT PRIMARY KEYPK

emailVARCHAR(255) NOT NULL

created_atTIMESTAMP

projects

idINT PRIMARY KEYPK

owner_idINT

nameVARCHAR(120)

created_atTIMESTAMP

Foreign Keys

owner_id → users.id

project_members

idINT PRIMARY KEYPK

project_idINT

user_idINT

roleVARCHAR(40)

Foreign Keys

project_id → projects.id
user_id → users.id

Mermaid output

erDiagram
  USERS {
INT PRIMARY KEY id PK
VARCHAR(255) NOT NULL email
TIMESTAMP created_at
  }
  PROJECTS {
INT PRIMARY KEY id PK
INT owner_id
VARCHAR(120) name
TIMESTAMP created_at
  }
  PROJECT_MEMBERS {
INT PRIMARY KEY id PK
INT project_id
INT user_id
VARCHAR(40) role
  }
  PROJECTS }o--|| USERS : "owner_id"
  PROJECT_MEMBERS }o--|| PROJECTS : "project_id"
  PROJECT_MEMBERS }o--|| USERS : "user_id"

🗺️ Schema Visualizer

関連ツール