DataPROPRO REQUIREDFC-DAT-014
Data Lake Claw
data-lake-claw
v0.2.0May 28, 2026Data lakes that do not become swamps — medallion architecture, Iceberg/Delta formats, and predictable query costs
Architects data lakes that don not become data swamps. Medallion layers (bronze → silver → gold), Iceberg/Delta table formats, compaction cadences, and tiered storage that keeps query costs predictable. Every table gets a contract, not a prayer.
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
- Medallion architecture layers defined
- Table format configured (Iceberg/Delta)
- Partition and compaction strategy in place
- Storage tiering policy documented
- Access control and catalog integration verified
5 GATEs DEFINED
Expected Outputs
Data Lake Architecture (Medallion)Table Format & Partitioning SpecCompaction & Optimization CadenceStorage Tiering PolicyCost Projection Workbook
Native exports per tool
OpenClaw10 files
openclaw/AGENTS.mdopenclaw/SOUL.mdopenclaw/TOOLS.md+7 moreHermes5 files
hermes/skills/flickclaw/data-lake-claw/SKILL.mdhermes/skills/flickclaw/data-lake-claw/references/workflow.mdhermes/skills/flickclaw/data-lake-claw/references/quality-gates.md+2 moreClaude Code6 files
claude-code/CLAUDE.mdclaude-code/.claude/skills/data-lake-claw/SKILL.mdclaude-code/.claude/skills/data-lake-claw/references/workflow.md+3 moreCodex5 files
codex/AGENTS.mdcodex/.flickclaw/agents/data-lake-claw/codex.mdcodex/.flickclaw/agents/data-lake-claw/workflow.md+2 moreCursor3 files
cursor/.cursor/rules/flickclaw-data-lake-claw.mdccursor/.cursor/rules/flickclaw-data-lake-claw-workflow.mdccursor/.cursor/rules/flickclaw-data-lake-claw-quality-gates.mdcWindsurf3 files
windsurf/.windsurf/rules/flickclaw-data-lake-claw.mdwindsurf/.windsurf/rules/flickclaw-data-lake-claw-workflow.mdwindsurf/.windsurf/rules/flickclaw-data-lake-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-lake-claw --target openclawDownload as ZIP
Example Prompt
Try this prompt with Data Lake Claw to see what it can do:
Analyze the data pipeline for quality issues. Review schema design, ETL processes, and monitoring. Produce Data Lake Architecture (Medallion), Table Format & Partitioning Spec, Compaction & Optimization Cadence.Example Output
IllustrativeWhat a typical Data Lake Claw report looks like:
# Data Lake Claw — Assessment Report **Project**: analytics-warehouse **Context**: a Snowflake data warehouse with 15 source integrations and daily ETL **Example type**: Illustrative output ## Executive Summary The Data Lake 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 - [✓] Bronze/silver/gold layers with clear contracts - [✓] Table format (Iceberg or Delta) selected and justified - [✓] Compaction and partition strategy benchmarked ## Outputs Generated - **Data Lake Architecture (Medallion)**: Included in the report above. - **Table Format & Partitioning Spec**: Included in the report above. - **Compaction & Optimization Cadence**: Included in the report above. - **Storage Tiering Policy**: 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