DataPROPRO REQUIREDFC-DAT-003
Warehouse Claw
warehouse-claw
Data warehouse design: dimensional modeling, star schemas, and query optimization.
Warehouse Claw architects analytical data stores with dimensional models, slowly changing dimensions, aggregate tables, and materialized views.
PRIMARY ACTION
Unlock with ProCOMPATIBLE WITH
OpenClawHermesClaude CodeCodex+4
OpenClaw is the default target. Cursor example below.
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
No explicit gate list for this agent in the current dataset.
4 GATES DEFINED
Expected Outputs
Native exports per tool
OpenClaw10 files
openclaw/AGENTS.mdopenclaw/SOUL.mdopenclaw/TOOLS.md+7 moreHermes5 files
hermes/skills/flickclaw/warehouse-claw/SKILL.mdhermes/skills/flickclaw/warehouse-claw/references/workflow.mdhermes/skills/flickclaw/warehouse-claw/references/quality-gates.md+2 moreClaude Code6 files
claude-code/CLAUDE.mdclaude-code/.claude/skills/warehouse-claw/SKILL.mdclaude-code/.claude/skills/warehouse-claw/references/workflow.md+3 moreCodex5 files
codex/AGENTS.mdcodex/.flickclaw/agents/warehouse-claw/codex.mdcodex/.flickclaw/agents/warehouse-claw/workflow.md+2 moreCursor3 files
cursor/.cursor/rules/flickclaw-warehouse-claw.mdccursor/.cursor/rules/flickclaw-warehouse-claw-workflow.mdccursor/.cursor/rules/flickclaw-warehouse-claw-quality-gates.mdcWindsurf3 files
windsurf/.windsurf/rules/flickclaw-warehouse-claw.mdwindsurf/.windsurf/rules/flickclaw-warehouse-claw-workflow.mdwindsurf/.windsurf/rules/flickclaw-warehouse-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 warehouse-claw --target openclawDownload as ZIP
Example Prompt
Try this prompt with Warehouse Claw to see what it can do:
Analyze the data pipeline for quality issues. Review schema design, ETL processes, and monitoring. Produce .Example Output
IllustrativeWhat a typical Warehouse Claw report looks like:
# Warehouse Claw — Assessment Report **Project**: analytics-warehouse **Context**: a Snowflake data warehouse with 15 source integrations and daily ETL **Generated**: 2026-05-26 ## Executive Summary The Warehouse 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 - [✓] no_fake_claims - [✓] dimensional_model_valid - [✓] slowly_changing_dimensions_documented ## Outputs Generated ## Validation - [x] All quality gates passed (3/3) - [x] 3 findings documented with severity and remediation - [x] 0 output sections generated - [x] Evidence collected and referenced --- *This is an illustrative example output from FlickClaw. Results vary based on project context.*