DataPROPRO REQUIREDFC-DAT-009
ETL Workflow Claw
etl-workflow-claw
v0.2.0May 28, 2026ETL pipelines idempotent by default, not by luck — incremental loads, Airflow scheduling, and alerts before SLA breaches
Builds ETL/ELT pipelines that are idempotent by default, not by luck. Incremental loads, idempotent transforms, Airflow/dbt scheduling, and error handling that alerts before the SLA breach — not after.
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
- Incremental load strategy defined
- Error recovery plan documented
- Data lineage tracked
- SLA targets met
4 GATEs DEFINED
Expected Outputs
ETL Pipeline DAGTransform Logic (dbt models)Orchestration ScheduleError Handling & DLQ ConfigSLA Monitoring Dashboard
Native exports per tool
OpenClaw10 files
openclaw/AGENTS.mdopenclaw/SOUL.mdopenclaw/TOOLS.md+7 moreHermes5 files
hermes/skills/flickclaw/etl-workflow-claw/SKILL.mdhermes/skills/flickclaw/etl-workflow-claw/references/workflow.mdhermes/skills/flickclaw/etl-workflow-claw/references/quality-gates.md+2 moreClaude Code6 files
claude-code/CLAUDE.mdclaude-code/.claude/skills/etl-workflow-claw/SKILL.mdclaude-code/.claude/skills/etl-workflow-claw/references/workflow.md+3 moreCodex5 files
codex/AGENTS.mdcodex/.flickclaw/agents/etl-workflow-claw/codex.mdcodex/.flickclaw/agents/etl-workflow-claw/workflow.md+2 moreCursor3 files
cursor/.cursor/rules/flickclaw-etl-workflow-claw.mdccursor/.cursor/rules/flickclaw-etl-workflow-claw-workflow.mdccursor/.cursor/rules/flickclaw-etl-workflow-claw-quality-gates.mdcWindsurf3 files
windsurf/.windsurf/rules/flickclaw-etl-workflow-claw.mdwindsurf/.windsurf/rules/flickclaw-etl-workflow-claw-workflow.mdwindsurf/.windsurf/rules/flickclaw-etl-workflow-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 etl-workflow-claw --target openclawDownload as ZIP
Example Prompt
Try this prompt with ETL Workflow Claw to see what it can do:
Analyze the data pipeline for quality issues. Review schema design, ETL processes, and monitoring. Produce ETL Pipeline DAG, Transform Logic (dbt models), Orchestration Schedule.Example Output
IllustrativeWhat a typical ETL Workflow Claw report looks like:
# ETL Workflow 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 ETL Workflow 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 - [✓] Incremental load with idempotent upserts - [✓] Error recovery with dead-letter routing - [✓] Lineage from source to destination per column ## Outputs Generated - **ETL Pipeline DAG**: Included in the report above. - **Transform Logic (dbt models)**: Included in the report above. - **Orchestration Schedule**: Included in the report above. - **Error Handling & DLQ Config**: Included in the report above. - **SLA Monitoring Dashboard**: 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