Cdc pattern implementer

Skill a5c-ai/babysitter/library/specializations/data-engineering-analytics/skills/cdc-pattern-implementer

Implements Change Data Capture patterns for real-time data integrationFrom its SKILL.md

Install

npx -y skills add a5c-ai/babysitter --skill cdc-pattern-implementer

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

SKILL.md

2.1 KB, 346 tokens by cl100k_base, as published. Nobody here has run it

CDC Pattern Implementer

Overview

Implements Change Data Capture patterns for real-time data integration. This skill provides expertise in CDC configuration and implementation across various database and streaming platforms.

Capabilities

Debezium connector configuration
CDC pattern selection (log-based, trigger-based, timestamp-based)
Initial snapshot strategy
Schema change handling
Exactly-once delivery configuration
Sink connector setup
Tombstone handling
CDC monitoring setup

Input Schema

{
  "sourceDatabase": {
    "type": "postgres|mysql|oracle|sqlserver",
    "connection": "object"
  },
  "tables": ["string"],
  "targetSystem": "kafka|kinesis|pubsub",
  "requirements": {
    "latencyMs": "number",
    "exactlyOnce": "boolean"
  }
}

Output Schema

{
  "connectorConfig": "object",
  "snapshotStrategy": "object",
  "schemaConfig": "object",
  "monitoringConfig": "object",
  "documentation": "string"
}

Target Processes

ETL/ELT Pipeline
Streaming Pipeline
Data Warehouse Setup

Usage Guidelines

Identify source database and tables for CDC
Define target streaming system
Specify latency and delivery guarantees
Configure appropriate snapshot strategy for initial load

Best Practices

Use log-based CDC when possible for minimal source impact
Plan initial snapshot strategy carefully for large tables
Implement proper error handling and dead letter queues
Monitor replication lag and connector health
Test schema evolution handling before production

What ships with it: 1 file

473 B alongside SKILL.md

README.md473 B