← Back to Skills Marketplace
Data Model Designer
by
datadrivenconstruction
· GitHub ↗
· v2.1.0
5882
Downloads
0
Stars
0
Active Installs
2
Versions
Install in OpenClaw
/install data-model-designer
Description
Design data models for construction projects. Create entity-relationship diagrams, define schemas, and generate database structures.
Usage Guidance
Install only if you are comfortable granting file access for project data workflows. Treat generated SQL as draft output: validate table, column, and relationship names, review it manually, and run it only in an appropriate database environment with limited privileges.
Capability Analysis
Type: OpenClaw Skill
Name: data-model-designer
Version: 2.1.0
The skill is classified as suspicious primarily due to a significant SQL injection vulnerability in the `generate_sql_schema` method within `SKILL.md`. Entity and field names, which can be user-controlled inputs, are directly concatenated into SQL DDL statements without sanitization, posing a risk for arbitrary SQL execution. Additionally, the `claw.json` grants broad `filesystem` permissions, which, while potentially justified for export functionality, amplifies the risk when combined with the SQL injection vulnerability. Although `instructions.md` advises the agent to 'Validate inputs before processing,' the underlying skill code itself does not implement this validation, making it inherently vulnerable.
Capability Assessment
Credentials
Filesystem permission is disclosed and fits CSV/Excel/JSON file workflows, though users should provide only intended project files and review exports.
Install Mechanism
The package contains markdown/json artifacts only, declares instructions.md as the entry point, requires python3, and has no bundled executable scripts, remote payload retrieval, or dependency installation steps.
Instruction Scope
The instructions broaden slightly into reports, analytics, file inputs, and exports, but this is user-directed and adjacent to construction data processing rather than hidden or unrelated behavior.
Persistence & Privilege
No persistence, background execution, privilege escalation, credential access, memory writes, or automatic database execution is present in the inspected artifacts.
Purpose & Capability
The artifacts consistently describe construction data model design, schema generation, ER diagrams, validation, and related structured reporting using user-provided project data.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install data-model-designer - After installation, invoke the skill by name or use
/data-model-designer - Provide required inputs per the skill's parameter spec and get structured output
Version History
v2.1.0
- Added detailed business case and technical documentation to SKILL.md.
- Included Python class definitions, enums, and methods for systematic data model design, schema generation, ER diagrams, and validation.
- Expanded skill description and metadata for clarity and compatibility.
v1.0.0
Initial release of Data Model Designer.
- Design data models for construction projects with entities and relationships.
- Generate SQL schemas, JSON schemas, and Mermaid entity-relationship diagrams.
- Includes validation for primary keys and relationships.
- Supports multiple data types, field constraints, and schema exports.
Metadata
Frequently Asked Questions
What is Data Model Designer?
Design data models for construction projects. Create entity-relationship diagrams, define schemas, and generate database structures. It is an AI Agent Skill for Claude Code / OpenClaw, with 5882 downloads so far.
How do I install Data Model Designer?
Run "/install data-model-designer" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Data Model Designer free?
Yes, Data Model Designer is completely free (open-source). You can download, install and use it at no cost.
Which platforms does Data Model Designer support?
Data Model Designer is cross-platform and runs anywhere OpenClaw / Claude Code is available (darwin, linux, win32).
Who created Data Model Designer?
It is built and maintained by datadrivenconstruction (@datadrivenconstruction); the current version is v2.1.0.
More Skills