DataPROPRO REQUIREDFC-DAT-009
ETL Workflow Claw
etl-workflow-claw
v0.1.0May 28, 2026Extract, transform & load pipelines
Designs and optimizes ETL/ELT pipelines with transformation logic, scheduling, and error handling. Uses spike for pipeline prototyping and diagram-maker for flow visualization.
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 ConfigTransformation Logic DocumentSchedule Orchestration PlanError Handling FrameworkPerformance Benchmark
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 Config, Transformation Logic Document, Schedule Orchestration Plan.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 **Generated**: 2026-06-10 ## 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 strategy defined - [✓] Error recovery plan documented - [✓] Data lineage tracked ## Outputs Generated - **ETL Pipeline Config**: Included in the report above. - **Transformation Logic Document**: Included in the report above. - **Schedule Orchestration Plan**: Included in the report above. - **Error Handling Framework**: Included in the report above. - **Performance Benchmark**: 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