← Back to Skills Marketplace
Data Model Designer
by
datadrivenconstruction
· GitHub ↗
· v2.1.0
5366
Downloads
0
Stars
45
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 filesystem access for the project files and export paths you choose. Review and validate generated SQL identifiers before running the DDL against any real database.
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
Purpose & Capability
The artifacts consistently describe construction data modeling: entities, relationships, ER diagrams, JSON schemas, SQL DDL, validation, and related project-data outputs.
Instruction Scope
The instructions mention reports, summary statistics, and export options, but these are adjacent to presenting user-provided data-modeling outputs rather than hidden or unrelated behavior.
Install Mechanism
The artifact contains only SKILL.md, instructions.md, and claw.json; there are no install scripts, executable files, package hooks, or dependency-install commands.
Credentials
The manifest requests filesystem permission, which is proportionate for reading user-selected CSV/Excel/JSON files and exporting results, but users should keep access limited to intended project files.
Persistence & Privilege
No credentials, background workers, startup hooks, persistent services, network calls, account access, privilege escalation, or destructive actions are present.
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 5366 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