TakeSix

Example

A data model you can click into

A data model drawn as one big ER diagram shows every column of every table at once. Here the first screen shows only the tables and how they relate: the order in the middle, everything it touches around it. Open a table to read its columns, or the order to see the tables it is made of.

Open in the editor

Shop data model

Orders in the middle, the tables they touch above and below; open a table for its columns

👤

Customer

Accounts and their addresses

📦

Product

Name, price and stock

🧾

Order

Who bought what, paid how, shipped where

💳

Payment

Charges and refunds per order

🚚

Shipment

Parcels, carrier and tracking

Get one like it from your agent

With the TakeSix MCP server or skill connected (see the guide), ask in plain words:

Prompt
Explain the data model of this project as a TakeSix diagram: the central table in the middle, the tables it relates to around it with labelled arrows, and the columns of each table inside it.
Read this diagram as text
  • Customer: Accounts and their addresses

    ## Columns - `id` uuid, primary key - `email` text, unique - `name` text - `created_at` timestamp ## Relations One customer places many orders. Addresses live in a separate table, so an old order keeps the address it was shipped to.

  • Product: Name, price and stock

    ## Columns - `id` uuid, primary key - `sku` text, unique - `name` text - `price` integer, in cents - `stock` integer ## Relations Order lines point to a product, but copy its price: changing a price never changes an old order.

  • Order: Who bought what, paid how, shipped where
    • Order: One purchase: customer, status and total

      ## Columns - `id` uuid, primary key - `customer_id` → Customer - `status` new · paid · shipped · cancelled - `total` integer, in cents - `placed_at` timestamp

    • Order line: One product in an order, with quantity and price

      ## Columns - `order_id` → Order - `product_id` → Product - `quantity` integer - `unit_price` integer, copied from the product

    • Discount: A code that lowers the price of some lines

      ## Columns - `code` text, primary key - `percent` integer - `valid_until` date

  • Payment: Charges and refunds per order

    ## Columns - `id` uuid, primary key - `order_id` → Order - `amount` integer, in cents; negative for a refund - `provider_ref` text - `status` pending · succeeded · failed

  • Shipment: Parcels, carrier and tracking

    ## Columns - `id` uuid, primary key - `order_id` → Order - `carrier` text - `tracking` text - `shipped_at` timestamp A large order can leave in several parcels.

More examples