A specialized Python-based data modeling engine for Chinese construction engineering that generates SQL schemas and ER diagrams compliant with GB/T standards.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install cn-construction-data-model
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install cn-construction-data-model using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is CN Construction Data Model Designer?
The CN Construction Data Model Designer is a technical framework designed to bridge the gap between fragmented construction data systems and unified digital management. By utilizing Openclaw Skills, developers can programmatically define entities, relationships, and constraints that strictly adhere to Chinese national standards like GB/T 50500-2024. This tool is essential for managing the full lifecycle of construction data, from initial cost estimation to final project completion.
Built for high-precision engineering environments, it provides a structured way to handle complex construction metadata such as bill of quantities (BOQ), WBS schedules, and cost control records. Integrating this tool into your development pipeline ensures that your database architecture is both semantically correct for the Chinese market and technically robust for modern database engines.
CN Construction Data Model Designer Use Cases
- Creating standardized database schemas for BIM and project management software.
- Generating Mermaid ER diagrams for technical documentation and stakeholder reviews.
- Synchronizing data structures between cost estimation, scheduling, and site inspection systems.
- Exporting JSON Schemas for API validation in construction-tech microservices.
How CN Construction Data Model Designer Works
- Initialize the CNConstructionDataModel with specific project metadata.
- Define entities using the Field and Entity classes or load pre-configured standard entities from the library.
- Configure relationships (One-to-One, One-to-Many, or Many-to-Many) between entities to build the data lineage.
- Execute the validation engine to check for primary key integrity and relational consistency.
- Generate output artifacts including SQL DDL for various dialects, JSON Schemas, or Mermaid ER code.
CN Construction Data Model Designer Setup
To start using this skill within your environment, ensure you have a Python runtime available. You can instantiate the core model and add standard entities as follows:
# No external pip dependencies required beyond standard Python 3.7+
from cn_construction_model import CNConstructionDataModel, CNConstructionEntities
# Initialize the project model
model = CNConstructionDataModel("Project_Alpha")
# Add GB/T standard entities
model.add_entity(CNConstructionEntities.project_entity())
model.add_entity(CNConstructionEntities.bill_item_entity())
CN Construction Data Model Designer Data Schema & Taxonomy
The skill organizes data into a strict hierarchy of Entities, Fields, and Relationships. It supports the following standard engineering tables:
| Entity Name | Description | Key Fields |
|---|---|---|
| engineering_projects | Main project metadata | project_code, total_investment, start_date |
| bill_items | BOQ and pricing data | bill_no, item_code, quantity, unit_price |
| cost_control | Financial tracking | target_cost, actual_cost, cost_stage |
| schedule_activities | WBS and progress | wbs_code, planned_start, progress_percent |
| change_orders | Engineering changes | change_no, original_amount, approval_status |
CN Construction Data Model Designer Advanced Features
- Multi-dialect SQL Support: Generate optimized DDL for MySQL, PostgreSQL, SQL Server, and SQLite using Openclaw Skills.
- Automated ER Visualization: Output Mermaid.js compatible code for instant diagram rendering.
- Integrity Validation: Built-in checks for missing primary keys and dangling foreign key references.
- Compliance Presets: Pre-loaded with schemas for GB/T 50500-2024 (Pricing Standards) and GB/T 50328 (Archiving Norms).
SKILL.md
Loading
Related Openclaw Skills
China Engineering Consultant (cn-engineering)
A professional engineering consulting skill providing precise technical guidance and Chinese construction standard compliance for every level of expertise.
Zhang Yiming Perspective
A sophisticated mental model framework based on the decision-making logic and strategic philosophy of ByteDance founder Zhang Yiming.
Seek Alliance - Marriage Matching Backend
An automated Vedic astrology platform that generates horoscopes and marriage compatibility reports in multiple languages and chart styles.
Remindy - Smart Reminder Service
A cross-platform notification engine that delivers email and browser push reminders exactly 15 minutes before scheduled events.
picture-it
A powerful CLI tool designed for AI agents to generate, edit, and composite images through a chainable, multi-pass workflow.
doc_xls2docx_xlsx
A specialized automation tool for batch converting legacy Microsoft Office files into modern XML-based formats.
Featured*
