Design construction data models and generate PostgreSQL schemas.
npx skills add https://github.com/zangxin75/openclaw-skills --skill data-model-designer
Please help me install this Agent Skill. Skill: data-model-designer Source: https://github.com/zangxin75/openclaw-skills/tree/main/data-model-designer Command: npx skills add https://github.com/zangxin75/openclaw-skills --skill data-model-designer
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.
Use the data-model-designer skill to create a PostgreSQL schema for a new construction project.
High-intent search queries and answers about installing and using this skill.
Schema generation for construction data produces SQL DDL statements for PostgreSQL and JSON Schema representations. It also generates visual Entity-Relationship diagrams using Mermaid syntax to map out project entities and their relationships.
To generate a PostgreSQL schema, you define your construction entities and relationships, then produce the corresponding SQL DDL statements. This skill automates DDL generation specifically for PostgreSQL dialects based on your defined construction project model.
Yes, construction data models can be validated for common structural issues like missing primary keys or undefined entities. Model validation checks your defined entities and relationships to ensure schema integrity before generating SQL DDL or JSON Schema outputs.
The best way to visualize construction entity relationships is by generating ER diagrams using Mermaid syntax. This skill creates visual Entity-Relationship diagrams that map projects, activities, cost items, and change orders within your data model.
Yes, this data modeling approach supports both JSON Schema creation and SQL DDL generation. You can define your construction entities once and output both PostgreSQL schemas and JSON Schema representations for integrated data management.
musujDefine project terminology, entities, relationships, and data structures.
Impertio-StudioValidate PostgreSQL DML and DDL statements for correct syntax and efficiency.
mahidalhanGenerate Mermaid diagrams for flowcharts, ER diagrams, sequence diagrams, and state machines.
wfukatsuGenerate Mermaid ER diagrams and entity catalogs from codebases or database models.
