DataPROPRO REQUIREDFC-DAT-003
Warehouse Claw
warehouse-claw
v0.2.0May 25, 2026Warehouses where queries finish before the analyst gives up — star schemas, SCD types, and cost forecasts that prevent bill shocks
Designs warehouses where queries finish before the analyst gives up. Star/snowflake schemas tuned for real query patterns, SCD type selection based on business needs, partition pruning that works, and cost forecasts that prevent cloud bill surprises.
OpenClaw
Hermes
Claude Code
Codex
Cursor
Windsurf
Aider
OllamaPRIMARY 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
OpenClawHermesClaude CodeCodexCursorWindsurfAiderOllama8 TOOLS
Quality Gates
- no fake claims
- dimensional model valid
- slowly changing dimensions documented
- query performance benchmarked
4 GATES DEFINED
Expected Outputs
Schema Design (Star/Snowflake DDL)Query Optimization ReportPartition & Clustering StrategyIncremental Load ConfigCost Projection Workbook
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 Schema Design (Star/Snowflake DDL), Query Optimization Report, Partition & Clustering Strategy.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-07-10 ## 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 - [✓] Dimensional model matches business query patterns - [✓] SCD types justified per dimension - [✓] Query performance benchmarked on production-scale data ## Outputs Generated - **Schema Design (Star/Snowflake DDL)**: Included in the report above. - **Query Optimization Report**: Included in the report above. - **Partition & Clustering Strategy**: Included in the report above. - **Incremental Load Config**: Included in the report above. - **Cost Projection Workbook**: 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