DataPROPRO REQUIREDFC-DAT-008
Data Modeling Claw
data-modeling-claw
v0.1.0May 28, 2026ERD, schemas & data architecture
Designs entity relationship diagrams, database schemas, and data architectures. Uses diagram-maker for ERD generation, normalization validation, and migration planning.
PRIMARY ACTION
Unlock with ProCOMPATIBLE WITH
OpenClawHermesClaude CodeCodex+4
8 compatible tools5 output formats
When to Use
- Design clean data workflows
- Plan reliable ETL and quality checks
- Track metrics and pipeline health
- Deliver maintainable data outputs
Compatible Frameworks
8 TOOLS
Quality Gates
- All relationships mapped
- Normalization level defined
- Index strategy documented
- Growth projections included
4 GATES DEFINED
Expected Outputs
Entity Relationship DiagramSchema Design DocumentNormalization ReportPerformance Optimization PlanMigration Script Template
Native exports per tool
OpenClaw10 files
openclaw/AGENTS.mdopenclaw/SOUL.mdopenclaw/TOOLS.md+7 moreHermes5 files
hermes/skills/flickclaw/data-modeling-claw/SKILL.mdhermes/skills/flickclaw/data-modeling-claw/references/workflow.mdhermes/skills/flickclaw/data-modeling-claw/references/quality-gates.md+2 moreClaude Code6 files
claude-code/CLAUDE.mdclaude-code/.claude/skills/data-modeling-claw/SKILL.mdclaude-code/.claude/skills/data-modeling-claw/references/workflow.md+3 moreCodex5 files
codex/AGENTS.mdcodex/.flickclaw/agents/data-modeling-claw/codex.mdcodex/.flickclaw/agents/data-modeling-claw/workflow.md+2 moreCursor3 files
cursor/.cursor/rules/flickclaw-data-modeling-claw.mdccursor/.cursor/rules/flickclaw-data-modeling-claw-workflow.mdccursor/.cursor/rules/flickclaw-data-modeling-claw-quality-gates.mdcWindsurf3 files
windsurf/.windsurf/rules/flickclaw-data-modeling-claw.mdwindsurf/.windsurf/rules/flickclaw-data-modeling-claw-workflow.mdwindsurf/.windsurf/rules/flickclaw-data-modeling-claw-quality-gates.mdAider3 files
aider/CONVENTIONS.mdaider/aider.mdaider/.aider.conf.ymlOllama4 files
ollama/Modelfileollama/system-prompt.mdollama/template.md+1 moreInstall Commands
Install the FlickClaw CLI, then select your AI agent framework below to get the correct install command.
Step 1: Install CLI (one-time)
npm install -g @flickclaw/cli@latestStep 2: Select Framework
OpenClaw
npm exec --yes @flickclaw/cli@latest -- install data-modeling-claw --target openclawDownload as ZIP
Example Prompt
Try this prompt with Data Modeling Claw to see what it can do:
Analyze the data pipeline for quality issues. Review schema design, ETL processes, and monitoring. Produce Entity Relationship Diagram, Schema Design Document, Normalization Report.Example Output
IllustrativeWhat a typical Data Modeling Claw report looks like:
# Data Modeling Claw — Assessment Report **Project**: analytics-warehouse **Context**: a Snowflake data warehouse with 15 source integrations and daily ETL **Generated**: 2026-06-10 ## Executive Summary The Data Modeling Claw completed its review of analytics-warehouse (a Snowflake data warehouse with 15 source integrations and daily ETL). 3 findings were identified with concrete remediation steps. All quality gates were verified before delivery. ## Findings | # | Severity | Area | Finding | Recommended Action | |---|----------|------|---------|-------------------| | 1 | **P1** | Schema | Slowly changing dimensions not tracked for customer table | Add SCD Type 2 with effective_date and is_current | | 2 | **P2** | Quality | 5% null rate in revenue column across 3 sources | Add NOT NULL constraint and source-level validation | | 3 | **P2** | Performance | Materialized view refresh blocks reads for 12min | Switch to incremental refresh with partition pruning | ## Quality Gates - [✓] All relationships mapped - [✓] Normalization level defined - [✓] Index strategy documented ## Outputs Generated - **Entity Relationship Diagram**: Included in the report above. - **Schema Design Document**: Included in the report above. - **Normalization Report**: Included in the report above. - **Performance Optimization Plan**: Included in the report above. - **Migration Script Template**: Included in the report above. ## Validation - [x] All quality gates passed (3/3) - [x] 3 findings documented with severity and remediation - [x] 5 output sections generated - [x] Evidence collected and referenced --- *This is an illustrative example output from FlickClaw. Results vary based on project context.*
RELATED AGENTS