Modelmaid | Spreadsheet interface for data modeling and generating Mermaid ERDs

[lukeSmth]

Why Modelmaid?

I've been using Mermaid ERDs as a lightweight data modeling tool. This works great for quickly iterating on models with other data engineers. Past initial whiteboarding, I switch over to spreadsheets for improved shareability with non-technical teams. This has its benefits but loses out on seamless diagram rendering. I built Modelmaid, a spreadsheet interface for data modeling and generating ERDs, to solve this.

What does it do?

The template supports defining tables, joins, and schemas and renders Mermaid ERDs to reflect the working model. E.g., joins defined on the EdgeList sheet are rendered on the ConciseERD sheet along with the Mermaid code.

EdgeList Sheet ☝️

ConciseERD Sheet ☝️

Check out the full example here.

Workflow

After copying the Modelmaid Template to your Google Drive, add one or more tables to the TableList sheet. Then move onto the EdgeList sheet to define joins or one of the auto-generated the table schema sheets to define table fields. Cycle between the TableList, EdgeList, and table schema sheets to define the domain tables. Use the ERD sheets to visualize the domain.

Interested?

Check out the README for more info.

Let me know if you have feedback!