data-model-designer

What problem does it solve?

Addresses challenges in construction data management, including fragmented data, inconsistent structures, and difficulties in data integration by providing a systematic approach to data model design.

Core Features & Use Cases

• Entity & Relationship Definition: Define entities, fields, data types, and relationships between them.
• Schema Generation: Generate SQL DDL statements for various dialects and JSON Schema representations.
• ER Diagramming: Create visual Entity-Relationship diagrams using Mermaid syntax.
• Model Validation: Validate the data model for common issues like missing primary keys or undefined entities.
• Use Case: Design a comprehensive data model for a new construction project, including entities for projects, activities, cost items, and change orders, then generate the corresponding PostgreSQL schema.

Quick Start

Use the data-model-designer skill to create a PostgreSQL schema for a new construction project.