elefcode

Mermaid diagram

ER Diagram — free online editor

Mermaid ER diagrams model database schemas — tables, columns, and the relationships between them using crow's-foot cardinality.

What is a Mermaid er diagram?

Entity-relationship diagrams are the standard way to document relational database schemas before (or while) writing migrations. Mermaid renders each entity as a table with typed columns and PK/FK markers, and uses crow's-foot notation for cardinality between entities.

When to use it

  • Design a new database schema
  • Document an existing schema for onboarding
  • Plan migrations and refactors
  • Discuss schema changes in a PR review

Syntax in one paragraph

Entity block: `USER { int id PK ; string name }`. Cardinality: `||--o{` (1 to 0..N), `||--|{` (1 to 1..N), `}o--o{` (N to N), `||--||` (exactly one).

Example: Customer → Order → Product schema

erDiagram
    CUSTOMER {
        int    id         PK
        string name
        string email
        date   created_at
    }
    ORDER {
        int     id          PK
        int     customer_id FK
        decimal total
        string  status
    }
    PRODUCT {
        int     id    PK
        string  name
        decimal price
    }
    ORDER_ITEM {
        int id         PK
        int order_id   FK
        int product_id FK
        int quantity
    }
    CUSTOMER ||--o{ ORDER      : places
    ORDER    ||--|{ ORDER_ITEM : contains
    PRODUCT  ||--o{ ORDER_ITEM : "included in"

More Mermaid diagrams