data-pipeline

Design ETL/ELT pipelines with idempotent processing and restartable checkpoints.

1|Updated Mar 4, 2026
One-click install
npx skills add https://github.com/Prathmesh2000/cursor_agent-orchestrator --skill data-pipeline-prathmesh2000
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-pipeline
Source: https://github.com/Prathmesh2000/cursor_agent-orchestrator/tree/main/agent-system/skills/data-pipeline
Command: npx skills add https://github.com/Prathmesh2000/cursor_agent-orchestrator --skill data-pipeline-prathmesh2000

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Data teams need a repeatable, observable architecture to design and implement robust pipelines (ETL/ELT, streaming, batch) across systems to ensure reliability and correctness.

Core Features & Use Cases

  • Design and implement ETL/ELT pipelines with idempotent upserts and restartable checkpoints.
  • Build event streaming or batch processing workflows with observability, validation, and error handling.
  • Use case: ingest data from source systems into a data warehouse with retries, deduplication, and monitoring.

Quick Start

Provide source and destination details and I will generate a reproducible data-pipeline skeleton with idempotent processing and checkpointing.

Frequently Asked Questions about data-pipeline

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design an ETL pipeline with idempotent upserts and restartable checkpoints?

To design an ETL pipeline with idempotent upserts, provide your source and destination details to generate a reproducible data pipeline skeleton. This skeleton enforces idempotent processing and restartable checkpoints, ensuring reliable data flows.

What is the best way to ensure observability and data validation in event streaming pipelines?

Ensuring observability and data validation in event streaming pipelines requires implementing core principles like schema versioning and error handling throughout the lifecycle. This approach guarantees observable, restartable, and idempotent data flows.

How do I handle retries and deduplication when ingesting data into a data warehouse?

Handling retries and deduplication during warehouse ingestion involves building workflows with restartable checkpoints and idempotent upserts. This ensures data correctness and prevents duplicate records during pipeline failures.

Does this data pipeline approach work for both batch processing and streaming workloads?

Yes, this data pipeline approach works for both batch processing and event streaming workloads. It coordinates reliable data flows across both paradigms, providing restartable checkpoints and validation for real-world analytics scenarios.

Why does my batch processing workflow need schema versioning and idempotence?

Batch processing workflows need schema versioning and idempotence to ensure restartability and correctness. These principles prevent data corruption and allow pipelines to resume safely from checkpoints after interruptions.