connect-cdc-sqlserver

Name: connect-cdc-sqlserver
Availability: InStock
Author: redpanda-data

Stream SQL Server CDC events into Redpanda or Kafka with per-table routing.

6|3|Updated May 31, 2026

Search Tags:#streaming #checkpoint #sql-server #cdc #connect #change-data-capture #lsn

Ready to run

npx skills add https://github.com/redpanda-data/skills --skill connect-cdc-sqlserver

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: connect-cdc-sqlserver
Source: https://github.com/redpanda-data/skills/tree/main/skills/connect-cdc-sqlserver
Command: npx skills add https://github.com/redpanda-data/skills --skill connect-cdc-sqlserver

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

SQL Server CDC data must be captured and delivered to modern data platforms in real time; this skill enables seamless streaming of SQL Server CDC events into Redpanda or Kafka, enabling continuous data pipelines from SQL Server to downstream systems.

Core Features & Use Cases

Enterprise CDC input for SQL Server that streams changes in real time and supports per-table routing to topics.
Snapshot-then-stream lifecycle with optional checkpointing and the ability to use built-in or external caches for LSN checkpoints.
Flexible configuration for including tables, batching, and backoff control to balance latency and load.

Quick Start

Configure input microsoft_sql_server_cdc with your connection_string and include patterns, then start the pipeline using rpk connect run.

Frequently Asked Questions about connect-cdc-sqlserver

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

FAQPage Schema

How do I stream SQL Server CDC changes to Kafka?▼

You can stream SQL Server CDC changes to Kafka by configuring a CDC input with your database connection string and table include patterns, then running the pipeline to capture and route events to topics in real time.

What is the snapshot-then-stream lifecycle for SQL Server change data capture?▼

Snapshot-then-stream lifecycle captures an initial snapshot of your SQL Server data before continuously streaming incremental CDC events, ensuring downstream systems have the full table state before applying real-time changes.

Can I route SQL Server CDC changes to individual topics per table?▼

Yes, per-table routing allows you to stream SQL Server CDC changes from multiple tables into separate dedicated Kafka or Redpanda topics, keeping downstream data pipelines organized by source table.

How does checkpointing work for SQL Server CDC LSN positions?▼

Checkpointing tracks SQL Server CDC LSN positions using either built-in or external caches, allowing the pipeline to resume streaming from the last captured log sequence number without data loss after interruptions.

Do I need enterprise licensing to use SQL Server CDC with Redpanda Connect?▼

Yes, the SQL Server CDC input satisfies enterprise licensing requirements, enabling you to capture and stream change data capture events into Redpanda or Kafka for continuous enterprise data pipelines.

Can I configure batching and backoff for SQL Server CDC pipelines?▼

Yes, SQL Server CDC pipelines support configurable batching and backoff control settings to balance latency and database load, preventing overwhelming source systems during high-volume change data capture streaming.