Skills
.Work. You
Rest

Enable SQL Server CDC

Community

Enable CDC on SQL Server databases and tables.

Data & Analytics#verification#etl#sql-server#cdc#change-data-capture#database-audit
Authorbillynewport
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill enables Change Data Capture (CDC) on a SQL Server database and its tables, allowing automatic tracking of data changes (inserts, updates, and deletes) for downstream ingestion, auditing, and real-time analytics.

Core Features & Use Cases

  • Database-level CDC enablement: Enable CDC on a database to start capturing changes.
  • Table-level CDC enablement: Enable CDC selectively on specific tables as needed.
  • Verification & monitoring: Validate CDC status, capture jobs, and ensure data is available for ETL/streaming pipelines.
  • Use Case: Ensure near real-time data flow into a data warehouse by capturing changes as they occur.

Quick Start

Connect to the SQL Server host using your preferred client, verify that SQL Server Agent is running, enable CDC on the database with sp_cdc_enable_db, enable CDC on required tables with sp_cdc_enable_table, then verify capture instances and jobs and perform a test insert/update to confirm data changes appear in the CDC.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: Enable SQL Server CDC
Download link: https://github.com/billynewport/demo_cokub_model/archive/main.zip#enable-sql-server-cdc

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.