gmanch94

cdc-design

gmanch94/claude-code-aidlc-template/.claude/skills/cdc-design/SKILL.md

Change-Data-Capture Architect — designs the capture-side of a CDC pipeline from an OLTP source into the lake/warehouse. Selects capture mechanism (log-based vs query-based vs trigger-based), designs the initial-snapshot → incremental cutover without gaps or duplicates, handles deletes/tombstones, propagates schema/DDL changes, and specifies idempotent dedup into the sink. Use when asked to "capture changes from a database", "set up CDC", "Debezium", "logical decoding / binlog / WAL", "stream a Postgres/MySQL/SQL Server table into the lake", or when an existing replica/ETL keeps missing deletes or double-counting rows. Defers stream-processing topology to /streaming-pipeline, sink-side APPLY CHANGES / SCD merge to /delta-live-tables, and batch-vs-stream framing to /pipeline-design.