Stream

Design batch, streaming, and hybrid data pipelines with quality gates and recovery paths.

68|14|Updated Jan 7, 2026
One-click install
npx skills add https://github.com/simota/agent-skills --skill stream-simota
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Stream
Source: https://github.com/simota/agent-skills/tree/main/stream
Command: npx skills add https://github.com/simota/agent-skills --skill stream-simota

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the complexity of designing, building, and maintaining robust data pipelines, ensuring data quality, reliability, and efficient flow across various systems.

Core Features & Use Cases

  • Pipeline Architecture: Designs ETL/ELT pipelines, choosing between batch, streaming, or hybrid modes.
  • Data Quality & Reliability: Implements quality gates, idempotency, schema evolution, and recovery strategies.
  • Orchestration & Modeling: Plans workflows using tools like Airflow, Kafka, and dbt.
  • Use Case: When you need to build a new data pipeline to ingest real-time user activity data, process it, and load it into a data warehouse for analytics, this Skill will design the architecture, select the right tools, and define the quality checks.

Quick Start

Use the Stream skill to design a hybrid data pipeline for processing user clickstream data with sub-minute latency requirements.

Frequently Asked Questions about Stream

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

FAQPage Schema
How do I design a data pipeline that handles both batch processing and streaming data?

Designing a hybrid data pipeline combines batch processing for bulk loads with streaming architectures like Kafka for real-time ingestion. This approach uses explicit quality gates and schema evolution to manage data flow efficiently across both modes.

What is the best way to ensure data quality and idempotency in an ETL pipeline?

Ensuring data quality in an ETL pipeline requires implementing explicit quality gates and idempotency checks during data flow. Defining clear recovery paths and schema evolution strategies guarantees reliable processing and prevents duplicate records.

Can I use dbt and Airflow together for ELT pipeline orchestration?

You can use dbt for data modeling and Airflow for workflow orchestration within an ELT pipeline. This combination allows you to schedule transformations, visualize data lineage, and enforce quality management across your data systems.

When do I need schema evolution and recovery paths in a data pipeline?

Schema evolution and recovery paths are needed when your data pipeline handles changing data structures or requires high reliability. They ensure your ETL or streaming processes adapt to schema modifications and recover gracefully from failures.

How to choose between batch processing and streaming for user clickstream data?

Choosing between batch processing and streaming for clickstream data depends on your latency requirements. If you need sub-minute insights, a streaming pipeline using Kafka is optimal, whereas batch processing suits scheduled, less time-sensitive analytics workloads.