Connect Cdc Sqlserver

Streams change data capture from Microsoft SQL Server into Redpanda or Kafka using Redpanda Connect's microsoft_sql_server_cdc input, which reads native CDC change tables in LSN order. Use when enabling SQL Server CDC capture instances, configuring microsoft_sql_server_cdc, setting up an initial snapshot alongside live streaming, tuning LSN checkpoint storage, or troubleshooting LSN gaps and missing Agent jobs. Also covers Redpanda Enterprise destination features such as Iceberg Topics, Tiered Storage, and server-side Schema ID Validation, since microsoft_sql_server_cdc itself requires a Redpa

9 stars 4 forksDatabases Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add redpanda-data/skills

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add redpanda-data/skills --skill connect-cdc-sqlserver
Manual install
git clone --depth 1 https://github.com/redpanda-data/skills.git /tmp/skills
mkdir -p ~/.claude/skills
cp -r /tmp/skills/skills/connect-cdc-sqlserver ~/.claude/skills/connect-cdc-sqlserver

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# Redpanda Connect CDC: Microsoft SQL Server

The `microsoft_sql_server_cdc` input in Redpanda Connect streams change events from Microsoft SQL Server's native CDC change tables directly into Redpanda or any Kafka-compatible output. It reads SQL Server's built-in change tables (`cdc.<schema>_<tablename>_CT`) using LSN (Log Sequence Number) ordering, optionally precedes streaming with a consistent point-in-time snapshot of existing rows, and durably checkpoints the last-delivered LSN so the pipeline can resume after a restart without re-consuming stale data.

This is an **Enterprise** component — it requires a valid Redpanda Enterprise license. The component name registered in Connect is `microsoft_sql_server_cdc`.

## Quickstart

**Step 1–3: Run the following T-SQL in SSMS or `sqlcmd` (as a sysadmin user):**

```sql
-- 1. Enable CDC on the database
USE MyDatabase;
EXEC sys.sp_cdc_enable_db;
GO

-- 2. Enable CDC on each table you want to capture
EXEC sys.sp_cdc_enable_table
  @source_schema = N'dbo',
  @source_name   = N'orders',
  @role_name     = NULL;
GO

EXEC sys.sp_cdc_enable_table
  @source_schema = N'dbo',
  @source_name   = N'customers',
  @role_name     = NULL;
GO

-- 3. Create the rpcn schema for the built-in checkpoint cache
--    and grant the Connect user rights to create objects in it
CREATE SCHEMA rpcn;
GO

GRANT CREATE TABLE TO connect_user;
GRANT CREATE PROCEDURE TO connect_user;
GRANT ALTER ON SCHEMA::rpcn TO connect_user;
GO
```
Read the full skill on GitHub

Details

Skill name
connect-cdc-sqlserver
Path
skills/connect-cdc-sqlserver/SKILL.md
License
Apache-2.0
Repo updated
16 November 2026

FAQ

What does the Connect Cdc Sqlserver skill do?

Streams change data capture from Microsoft SQL Server into Redpanda or Kafka using Redpanda Connect's microsoft_sql_server_cdc input, which reads native CDC change tables in LSN order. Use when enabling SQL Server CDC capture instances, configuring microsoft_sql_server_cdc, setting up an initial snapshot alongside live streaming, tuning LSN checkpoint storage, or troubleshooting LSN gaps and missing Agent jobs. Also covers Redpanda Enterprise destination features such as Iceberg Topics, Tiered Storage, and server-side Schema ID Validation, since microsoft_sql_server_cdc itself requires a Redpa

How do I install the Connect Cdc Sqlserver skill?

Claude Code plugin: /plugin marketplace add redpanda-data/skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Connect Cdc Sqlserver popular?

It lives in redpanda-data/skills, which has 9 GitHub stars and 4 forks.

Related skills

Adp

9

redpanda-data/skills

Redpanda's Agentic Data Plane: governance infrastructure for building, running, and governing AI agents and MCP servers behind a credential-injecting AI Gateway for LLM providers, operated through the `rpk ai` CLI and the ADP UI at ai.redpanda.com. Use when installing `rpk ai`, signing in to an environment, checking setup with `rpk ai doctor`, managing managed or self-managed AI agents and their triggers with `rpk ai agent` and `rpk ai trigger`, configuring remote or managed MCP servers with `rpk ai mcp-server` (including code mode and user-delegated OAuth), setting up LLM providers and models

AI, LLMs & Agents

Adp Governance

9

redpanda-data/skills

Govern what Agentic Data Plane agents may do, spend, and expose, through the `rpk ai` CLI and the ADP UI at ai.redpanda.com, and look up governance features in the Redpanda docs. Use when writing or debugging a Cedar access policy with `rpk ai policy`, giving a new agent access, capping agent spend with `rpk ai budget`, analyzing cost, attaching a guardrail to a provider, containing or releasing an agent with the kill switch, storing or deleting a credential with `rpk ai secret`, minting an API key, masking MCP tool data with data policies, or setting up inbound or outbound OAuth. For signing

AI, LLMs & Agents

Adp Observability

9

redpanda-data/skills

Read what Agentic Data Plane agents did and why, through traces, conversation transcripts, the audit log, and the monitoring views in the ADP UI at ai.redpanda.com and the `rpk ai` CLI. Use when finding which call made an agent run slow, failed, or expensive with `rpk ai trace`, reading or filtering a conversation with `rpk ai agent transcript`, finding conversations with a failed tool call, investigating a denied or masked call with `rpk ai auditlog`, working out on whose behalf an agent acted, or reading the Agent network or Home views. For budgets, cost, and access policies, see `/redpanda:

DevOps & Cloud

Connect Cdc Tigerbeetle

9

redpanda-data/skills

Guides setup and operation of the tigerbeetle_cdc input in Redpanda Connect, which streams change data capture from a TigerBeetle financial transactions database into Redpanda or Kafka. Use when configuring tigerbeetle_cdc, connecting to a TigerBeetle cluster, choosing a persistent progress_cache for checkpointing, filtering settled vs pending transfers, routing by ledger, or resolving cgo-build or duplicate-event issues. Unlike the other CDC inputs, tigerbeetle_cdc is a certified community connector and does not require an Enterprise license, though it can still land data on Enterprise destin

Databases

Connect Cdc Postgres

9

redpanda-data/skills

Streams change data capture from PostgreSQL into Redpanda or Kafka with the Redpanda Connect postgres_cdc input, which reads the WAL through logical replication. Use when configuring or troubleshooting postgres_cdc (formerly pg_stream), its replication slot and publication, an initial or incremental snapshot, control signals, or WAL that PostgreSQL cannot reclaim.

Databases

SQL

9

redpanda-data/skills

Writes and runs read-only Redpanda SQL queries on Redpanda Cloud and manages which SQL users can read which topics. Use when a user wants to connect to Redpanda SQL with psql, a PostgreSQL driver, or SQL Studio, query topic-backed tables, create views, export results with COPY TO, grant or revoke access to topics or views, fix a user who lost SQL access, or check how Redpanda SQL differs from PostgreSQL. For enabling SQL, the SQL Manage and SQL Access roles, and the access model, see `/redpanda:sql-admin-api`. For catalogs, mapping topics with CREATE TABLE, and Iceberg-enabled topics, see `/re

Databases

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.