SkillAgentSearch skills...

data-engineering-data-pipeline

Design scalable, reliable, and cost-effective data pipelines for batch and streaming processing

Install / Use

npx skills add rmyndharis/antigravity-skills --skill data-engineering-data-pipeline

Installs into whichever agent you are using.

About this skill
📄

SKILL.md

Installable skill definition

Quality Score

81/100

Category

Automation

Supported Platforms

Universal

Our assessment of data-engineering-data-pipeline

data-engineering-data-pipeline scores 81/100 on our quality scale, 2392nd of 2,790 Automation skills we index.

Its SKILL.md is 6.7 KB long, well organised into 27 sections with 1 code example: a thorough specification that gives an agent plenty to work with.

With 1,621 GitHub stars, it is one of the more widely adopted skills in the catalogue.

Substance
29/30
Structure
17/20
Description
12/15
Adoption
14/20
Freshness
11/15

Maintenance, license and trust

  • The repository was last updated about 4 months ago. That is recent enough to be usable, but agent tooling moves fast, so check the instructions against your agent's current version.
  • Our last check on 2026-11-08 found the source still online.
  • It is released under the MIT license, a permissive license that allows use, modification and commercial use with attribution.
  • Its trust signals score 98/100, with no cautions. These come from repository metadata, not a code audit — read the skill file before letting an agent act on it.

Safety scan

No issues found

Our scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful.

AI review by kimi-k2.7-code on 2026-10-03. Automated pattern scan on 2026-10-03. It catches known dangerous patterns, not every risk — read a skill before letting an agent act on it.

data-engineering-data-pipeline compared with similar skills

All 4 of these similar skills score higher than data-engineering-data-pipeline; compare them before choosing.

SkillScoreStarsUpdatedFormat
data-engineering-data-pipeline (this skill)by rmyndharis811.6k4mo agoSKILL.md
taste-skillby Leonxlnx100116.8k8d agoCLAUDE.md
Agent-Reachby Panniantong100112.3k8d agoCLAUDE.md
rufloby ruvnet10081.9ktodayCLAUDE.md
Claude-Code-Game-Studiosby Donchitos10039.7k7d agoCLAUDE.md

Frequently asked questions

How do I install data-engineering-data-pipeline?
Run npx skills add rmyndharis/antigravity-skills --skill data-engineering-data-pipeline. The install tabs above show the steps for each supported agent.
Which AI agents does data-engineering-data-pipeline work with?
It is written for Universal, as a SKILL.md file. Other agents that read the same format can often use it too.
Is data-engineering-data-pipeline safe to use?
Our scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful. It is MIT-licensed and scores 98/100 on trust signals. Skills are instructions an agent will follow, so read the file before installing it and do not approve commands you do not understand.
Is data-engineering-data-pipeline still maintained?
The repository was last updated about 4 months ago. That is recent enough to be usable, but agent tooling moves fast, so check the instructions against your agent's current version.

name: data-engineering-data-pipeline description: "You are a data pipeline architecture expert specializing in scalable, reliable, and cost-effective data pipelines for batch and streaming data processing."

Data Pipeline Architecture

You are a data pipeline architecture expert specializing in scalable, reliable, and cost-effective data pipelines for batch and streaming data processing.

Use this skill when

  • Working on data pipeline architecture tasks or workflows
  • Needing guidance, best practices, or checklists for data pipeline architecture

Do not use this skill when

  • The task is unrelated to data pipeline architecture
  • You need a different domain or tool outside this scope

Requirements

$ARGUMENTS

Core Capabilities

  • Design ETL/ELT, Lambda, Kappa, and Lakehouse architectures
  • Implement batch and streaming data ingestion
  • Build workflow orchestration with Airflow/Prefect
  • Transform data using dbt and Spark
  • Manage Delta Lake/Iceberg storage with ACID transactions
  • Implement data quality frameworks (Great Expectations, dbt tests)
  • Monitor pipelines with CloudWatch/Prometheus/Grafana
  • Optimize costs through partitioning, lifecycle policies, and compute optimization

Instructions

1. Architecture Design

  • Assess: sources, volume, latency requirements, targets
  • Select pattern: ETL (transform before load), ELT (load then transform), Lambda (batch + speed layers), Kappa (stream-only), Lakehouse (unified)
  • Design flow: sources → ingestion → processing → storage → serving
  • Add observability touchpoints

2. Ingestion Implementation

Batch

  • Incremental loading with watermark columns
  • Retry logic with exponential backoff
  • Schema validation and dead letter queue for invalid records
  • Metadata tracking (_extracted_at, _source)

Streaming

  • Kafka consumers with exactly-once semantics
  • Manual offset commits within transactions
  • Windowing for time-based aggregations
  • Error handling and replay capability

3. Orchestration

Airflow

  • Task groups for logical organization
  • XCom for inter-task communication
  • SLA monitoring and email alerts
  • Incremental execution with execution_date
  • Retry with exponential backoff

Prefect

  • Task caching for idempotency
  • Parallel execution with .submit()
  • Artifacts for visibility
  • Automatic retries with configurable delays

4. Transformation with dbt

  • Staging layer: incremental materialization, deduplication, late-arriving data handling
  • Marts layer: dimensional models, aggregations, business logic
  • Tests: unique, not_null, relationships, accepted_values, custom data quality tests
  • Sources: freshness checks, loaded_at_field tracking
  • Incremental strategy: merge or delete+insert

5. Data Quality Framework

Great Expectations

  • Table-level: row count, column count
  • Column-level: uniqueness, nullability, type validation, value sets, ranges
  • Checkpoints for validation execution
  • Data docs for documentation
  • Failure notifications

dbt Tests

  • Schema tests in YAML
  • Custom data quality tests with dbt-expectations
  • Test results tracked in metadata

6. Storage Strategy

Delta Lake

  • ACID transactions with append/overwrite/merge modes
  • Upsert with predicate-based matching
  • Time travel for historical queries
  • Optimize: compact small files, Z-order clustering
  • Vacuum to remove old files

Apache Iceberg

  • Partitioning and sort order optimization
  • MERGE INTO for upserts
  • Snapshot isolation and time travel
  • File compaction with binpack strategy
  • Snapshot expiration for cleanup

7. Monitoring & Cost Optimization

Monitoring

  • Track: records processed/failed, data size, execution time, success/failure rates
  • CloudWatch metrics and custom namespaces
  • SNS alerts for critical/warning/info events
  • Data freshness checks
  • Performance trend analysis

Cost Optimization

  • Partitioning: date/entity-based, avoid over-partitioning (keep >1GB)
  • File sizes: 512MB-1GB for Parquet
  • Lifecycle policies: hot (Standard) → warm (IA) → cold (Glacier)
  • Compute: spot instances for batch, on-demand for streaming, serverless for adhoc
  • Query optimization: partition pruning, clustering, predicate pushdown

Example: Minimal Batch Pipeline

# Batch ingestion with validation
from batch_ingestion import BatchDataIngester
from storage.delta_lake_manager import DeltaLakeManager
from data_quality.expectations_suite import DataQualityFramework

ingester = BatchDataIngester(config={})

# Extract with incremental loading
df = ingester.extract_from_database(
    connection_string='postgresql://host:5432/db',
    query='SELECT * FROM orders',
    watermark_column='updated_at',
    last_watermark=last_run_timestamp
)

# Validate
schema = {'required_fields': ['id', 'user_id'], 'dtypes': {'id': 'int64'}}
df = ingester.validate_and_clean(df, schema)

# Data quality checks
dq = DataQualityFramework()
result = dq.validate_dataframe(df, suite_name='orders_suite', data_asset_name='orders')

# Write to Delta Lake
delta_mgr = DeltaLakeManager(storage_path='s3://lake')
delta_mgr.create_or_update_table(
    df=df,
    table_name='orders',
    partition_columns=['order_date'],
    mode='append'
)

# Save failed records
ingester.save_dead_letter_queue('s3://lake/dlq/orders')

Output Deliverables

1. Architecture Documentation

  • Architecture diagram with data flow
  • Technology stack with justification
  • Scalability analysis and growth patterns
  • Failure modes and recovery strategies

2. Implementation Code

  • Ingestion: batch/streaming with error handling
  • Transformation: dbt models (staging → marts) or Spark jobs
  • Orchestration: Airflow/Prefect DAGs with dependencies
  • Storage: Delta/Iceberg table management
  • Data quality: Great Expectations suites and dbt tests

3. Configuration Files

  • Orchestration: DAG definitions, schedules, retry policies
  • dbt: models, sources, tests, project config
  • Infrastructure: Docker Compose, K8s manifests, Terraform
  • Environment: dev/staging/prod configs

4. Monitoring & Observability

  • Metrics: execution time, records processed, quality scores
  • Alerts: failures, performance degradation, data freshness
  • Dashboards: Grafana/CloudWatch for pipeline health
  • Logging: structured logs with correlation IDs

5. Operations Guide

  • Deployment procedures and rollback strategy
  • Troubleshooting guide for common issues
  • Scaling guide for increased volume
  • Cost optimization strategies and savings
  • Disaster recovery and backup procedures

Success Criteria

  • Pipeline meets defined SLA (latency, throughput)
  • Data quality checks pass with >99% success rate
  • Automatic retry and alerting on failures
  • Comprehensive monitoring shows health and performance
  • Documentation enables team maintenance
  • Cost optimization reduces infrastructure costs by 30-50%
  • Schema evolution without downtime
  • End-to-end data lineage tracked

Related Skills

View on GitHub
GitHub Stars1.6k
CategoryAutomation
Updated3mo ago
Forks268

Languages

JavaScript

Trust signals

98/100

From repository metadata: license, adoption, age and documentation. Not a code audit — see the Safety scan above for what the skill file itself contains.

1 info