Software engineering template

Data model (ERD) template

An online shop’s tables and how they relate, drawn with crow’s-foot ends.

Free · Editable · Works with Claude and ChatGPT · Also in Diagramming

Preview of the Data model (ERD) template: its layout as it lands on the board
The template as it lands on your board, drawn from the template itself. Every part is editable.

How to use the Data model (ERD) template

  1. Start a board from it

    Use this template opens a new Freero board with the Data model (ERD) template on it (sign up free first). On a board you already have, open Templates in the toolbar and search for “Data model (ERD)”.

  2. Follow the instruction on the board

    “One box per table, primary (PK) and foreign (FK) keys first. Read each line’s ends as “how many on this side”.”

  3. Fill in each part

    • customer PK id email name created_at
    • order PK id FK customer_id placed_at status
    • payment PK id FK order_id amount paid_at
    • address PK id FK customer_id street city postcode
    • order_line PK id FK order_id FK product_id quantity unit_price
    • product PK id FK category_id name price
    • category PK id name
    • Reading the ends
  4. Bring your team and your agents

    Invite people to the board or share a link, and work on it together live. The timer is in the top bar, private mode and voting in the board menu, and Claude or ChatGPT can join through Freero’s MCP server.

Use this template

Work on it with an AI agent

Connect an assistant once and it works on the board with you, with your permissions: by default it reads and proposes, and people decide.

  1. You ask: “Fill in the Data model (ERD) board from these notes.”

    What happens It reads the board, then proposes sticky notes for it. Nothing changes until someone on the board accepts them.

  2. You ask: “Group what we wrote into themes and list the actions.”

    What happens It proposes clusters with a title each and task cards for the actions, labelled with its name and yours.

Set it up for Claude, ChatGPT or any MCP client.

Bring your team and your agents to one board

Free to use, open source, and yours to host. No credit card, no seat count.