data-flow-model

Build ER diagrams and data flow diagrams with scenario-specific analysis for technical design.

2|Updated Jun 8, 2026
One-click install
npx skills add https://github.com/HACK-WU/skills --skill data-flow-model-hack-wu
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-flow-model
Source: https://github.com/HACK-WU/skills/tree/main/skills/data-flow-model
Command: npx skills add https://github.com/HACK-WU/skills --skill data-flow-model-hack-wu

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Before technical design, teams often lack a clear picture of what the data looks like and how it flows through the system, leading to inconsistent schemas, missed concurrency issues, and rework during implementation. ## Core Features & Use Cases - Entity and ER Modeling: Extract core entities from requirements and produce mermaid ER diagrams with cardinality, key fields, and constraints. - Data Flow Diagrams: Map how data moves between components with CRUD annotations and trigger conditions. - Scenario-Adaptive Analysis: Layer concurrency, distributed, real-time streaming, or batch-processing analysis (transactions, locking, consistency, idempotency, checkpoints) on top of the base model. - Use Case: When designing an order system, use this Skill to identify entities like User and Order, draw the ER diagram, trace order creation data flows, and define optimistic locking and isolation levels for concurrent inventory deduction before handing off to technical design. ## Quick Start Ask the AI to build a data model and data flow diagram for your feature, for example: help me design the data model and show how data flows for the order placement feature.

Frequently Asked Questions about data-flow-model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create an ER diagram from a requirements description?

Extract core entities from the requirement text using noun extraction, operation inference, or event sourcing, then define relationships with cardinality in a mermaid erDiagram. List only key fields with PK, FK, required, and unique constraints rather than every column.

How to draw a data flow diagram for a system design?

Use a mermaid flowchart where nodes represent entities, components, users, or external systems, and edges show data direction with trigger conditions. Annotate each flow with CRUD operations (Create, Read, Update, Delete) to describe how data changes as it moves.

What should a data model include for concurrent scenarios?

Concurrent scenario analysis must define transaction boundaries, lock strategy (optimistic vs pessimistic), isolation level, and conflict handling for each operation. For example, inventory deduction might use optimistic locking with version numbers and retry on conflict.

When should data modeling happen in the design workflow?

Data modeling happens after requirement mining, interaction design, and work breakdown, but before technical design. It clarifies what the data looks like and how it flows so the technical design phase can reference the ER diagram and flow definitions directly.

What are the limitations of this data modeling approach?

It deliberately avoids implementation decisions like database or message queue selection, covering only data structure and flow direction. Detailed field lists and physical schema design are deferred to the technical design phase.