A specialized tool for designing construction project data models, generating SQL schemas, and creating entity-relationship diagrams.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install data-model-designer
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 data-model-designer 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 Data Model Designer?
The Data Model Designer is a technical framework designed to address the challenges of fragmented and inconsistent data structures within the construction industry. As a key component of the Openclaw Skills ecosystem, it allows developers to define complex entities, relationships, and schemas in a systematic way. This ensures that data integration remains seamless and that all project entities—from activities to cost items—maintain strict relational integrity.
By leveraging this tool, engineering teams can move away from manual database configuration toward an automated, model-driven approach. It provides a standardized method for architectural design, making it easier to manage data across diverse systems and project lifecycle stages.
Data Model Designer Use Cases
- Creating standardized database schemas for construction project management platforms.
- Generating visual Entity-Relationship diagrams to communicate data architecture to project stakeholders.
- Automating the generation of PostgreSQL DDL statements for rapid environment setup.
- Validating data models to ensure primary key consistency and foreign key integrity across complex project datasets.
How Data Model Designer Works
- Initialize the data model by defining a project context and name.
- Define entities using pre-built construction templates (like projects or activities) or custom field definitions.
- Configure relationships between entities, specifying relation types such as one-to-many or many-to-many.
- Run the validation engine to identify missing keys, orphaned relationships, or inconsistent data types.
- Export the model into desired formats including SQL DDL, JSON Schema, or Mermaid ER diagrams.
Data Model Designer Setup
This skill requires Python 3 for execution. You can integrate it into your development environment by ensuring the core classes are accessible to your agent within the Openclaw Skills directory.
# Verify your Python environment
python3 --version
# No external pip dependencies are required for the core logic
Data Model Designer Data Schema & Taxonomy
The Data Model Designer organizes data through a hierarchy of classes that define the structure of a construction database. The following table highlights the primary metadata taxonomy:
| Object | Description | Key Attributes |
|---|---|---|
| Entity | Represents a data table | name, fields, primary_key |
| Field | Represents a table column | data_type, nullable, constraints |
| Relationship | Connects two entities | from_entity, to_entity, relation_type |
| DataType | Defines variable types | STRING, INTEGER, FLOAT, JSON, etc. |
Data Model Designer Advanced Features
- Multi-dialect SQL support with specific optimizations for PostgreSQL JSONB types.
- Mermaid.js integration for generating live-rendering ER diagrams directly from code.
- Pre-defined construction entity library for industry-standard objects like WBS codes and budget items.
- Integrated model validator that prevents common database architectural errors before deployment.
- Native JSON Schema export for seamless integration with web APIs and Openclaw Skills workflows.
SKILL.md
Loading
Related Openclaw Skills
Data Lineage Tracker
A technical tool for tracking data origin, transformations, and logical flow across construction management systems.
Data Evolution Analysis
A specialized technical skill for analyzing data evolution patterns and assessing the digital maturity of construction organizations based on DDC methodology.
Data Anomaly Detector for Construction
An AI-ready analytical tool that identifies statistical outliers and logical errors in construction project datasets.
CWICR Cost Calculator
A professional tool for calculating construction costs with total transparency using the resource-based CWICR methodology.
Data Profiler for Construction
A comprehensive Python-based profiling engine designed to assess the quality, patterns, and distributions of construction industry datasets.
Construction Data Quality Checker
A Python-powered quality assessment engine designed to validate construction data against industry-standard metrics like completeness and accuracy.
METADATA
Featured*
