Official agent skill

MSSQL CDC Bug Reproduction Harness

by airbytehq in airbytehq/airbyte

Reproduces change-data-capture bugs in the source-mssql Airbyte connector by enabling CDC on a local SQL Server backend and replaying per-bug SQL fixtures.

OfficialCustom licenceAuto-check passedTesting & QA

Install MSSQL CDC Bug Reproduction Harness

skills CLI
$ npx skills add airbytehq/airbyte --skill source-mssql-e2e-cdc-tests -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install airbytehq/airbyte source-mssql-e2e-cdc-tests --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/airbytehq/airbyte.git skills-src && mkdir -p .claude/skills && cp -r skills-src/airbyte-integrations/connectors/source-mssql/.agents/skills/source-mssql-e2e-cdc-tests .claude/skills/source-mssql-e2e-cdc-tests && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
source-mssql-e2e-cdc-tests
GitHub stars
22k
Token cost
~3.3k tokens
SKILL.md length
1,280 words
Files
11
Skills in repo
9
Repo updated
First seen
Licence
Custom licence

At a glance

Reproduces change-data-capture bugs in the source-mssql Airbyte connector by enabling CDC on a local SQL Server backend and replaying per-bug SQL fixtures.

  • Works in 4 steps: Applies its SQL fixtures (via… → Renders the config against the running… → Runs the target protocol command with… → …
  • Reproducing a reported CDC bug against the source-mssql connector locally
  • SKILL.md covers When to use this skill, Prerequisites, Layout and Conventions, plus 3 more sections
  • Runs Shell scripts from its folder

What it does

Builds on a generic engine-independent test harness and an MSSQL-specific skill that stands up the SQL Server backend and runs the connector, adding CDC enablement, CDC-aware config and catalog templates, and per-bug case scripts under `cases/` that call a shared `run.sh` with the right fixtures and `--expect-*` assertions. Existing cases cover specific reported issues such as LSN cleanup and schema-history handling.

Fixtures are re-applied at the start of every run, so each SQL fixture file must be idempotent, for example guarding table creation with an existence check; re-applying a fixture mid-case does not reset CDC state a previous phase already established. A new case for a customer-reported bug is authored by adding a SQL fixture under `fixtures/sql/` and a numbered case script that invokes `run.sh` with the matching fixtures and assertions.

When your agent uses it

  • Reproducing a reported CDC bug against the source-mssql connector locally
  • Verifying that a fix still rejects genuinely invalid CDC state
  • Authoring a new repro case for a customer-reported CDC issue
  • Re-running an existing CDC case against a development build of the connector

Example prompts

  • “Reproduce issue 12094's schema-history bug using the existing case script.”
  • “Add a new CDC repro case for the LSN gap reported in issue 13021.”
  • “Re-run case 11451 against the dev build and confirm it still fails correctly.”

Requirements

  • Docker
  • uv
  • jq
  • A clone of the airbytehq/airbyte repository

Workflow steps

4 steps, taken from the first numbered list in SKILL.md.

  1. Applies its SQL fixtures (via --fixture=…; run.sh calls
  2. Renders the config against the running backend (via
  3. Runs the target protocol command with any --catalog / --state.
  4. Gates its exit code on --expect-* flags — the runner enforces

What it can do on your machine

Read from SKILL.md and the folder at commit 38c668c. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Ships script files (Shell), which the agent can run.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Links to these hosts (documentation or services it may open):

    • github.com

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

MSSQL CDC Bug Reproduction Harness loads about 3.3k tokens when it runs. Until then it costs about 69 tokens; SKILL.md has 1,280 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~69
When it runs · the whole SKILL.md, loaded when a task matches
~3.3k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 1,280 words (~3,275 tokens).

“Local CDC bug-reproduction harness for source-mssql. Builds on the engine-independent orchestration in airbyte-integrations/db-harness-lib/ and the MSSQL engine skill (source-mssql-e2e-tests): generic skill stands up the SQL Server backend and runs the connector; this skill adds CDC enable, CDC-aware config / catalog…”

— opening of SKILL.md by airbytehq, Custom licence
name
source-mssql-e2e-cdc-tests

Read the full SKILL.md on GitHub

Files

SKILL.md and 10 other files in airbyte-integrations/connectors/source-mssql/.agents/skills/source-mssql-e2e-cdc-tests of airbytehq/airbyte.

  • SKILL.md
  • cases/11451.sh
  • cases/12094.sh
  • cases/12162.sh
  • fixtures/catalogs/order-items-cdc.json
  • fixtures/catalogs/users-cdc.json
  • fixtures/configs/cdc.template.json
  • fixtures/sql/00-init-cdc.sql
  • fixtures/sql/repro-11451-lsn-cleanup.sql
  • fixtures/sql/repro-12094-schema-history.sql
  • fixtures/sql/repro-12162-spaces-in-name.sql

Open the folder on GitHubat commit 38c668c

Compare with similar skills

MSSQL CDC Bug Reproduction Harness next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

MSSQL CDC Bug Reproduction Harness compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
MSSQL CDC Bug Reproduction Harness this skillairbytehq/airbyte22k—~3.3kAutomated safety check: PassCustom licence
Java SDK E2E Test with Replay Snapshotgithub/copilot-sdk11k—~1.8kAutomated safety check: PassMIT
Anti Cheatingelliothux/open-compute1.6k—~1.1kAutomated safety check: PassApache-2.0
ClickUp CLI Testingkrodak/clickup-cli120—~1.4kAutomated safety check: NotesMIT
Testingweb-infra-dev/rstest505—~2.1kAutomated safety check: PassMIT
Proxy Setupasmyshlyaev177/test-proxy-recorder112—~4.3kAutomated safety check: PassMIT

Similar skills

  • Official

    Creates a Java SDK end-to-end test for the Copilot SDK that runs against a recorded YAML snapshot through a replay proxy, so CI needs no real authentication.

    11k GitHub stars~1.8k tokensUpdated today
    Testing & QAAuto-check passed
  • Anti Cheating

    elliothux/open-compute

    Audit the current Lynx branch and working tree for test-, fixture-, demo-, page-, domain-, or scenario-tuned production logic.

    1.6k GitHub stars~1.1k tokensUpdated yesterday
    Testing & QAAuto-check passed
  • ClickUp CLI Testing

    krodak/clickup-cli

    Explains how to run and extend the clickup-cli tests: unit tests with a mocked client, e2e tests against a real ClickUp workspace, and the fixture data they rely on.

    120 GitHub stars~1.4k tokensUpdated yesterday
    Testing & QAAuto-check: notes
  • Testing

    web-infra-dev/rstest

    Testing workflow for the Rstest monorepo. An agent skill from web-infra-dev/rstest.

    505 GitHub stars~2.1k tokensUpdated 7 days ago
    Testing & QAAuto-check passed
  • Proxy Setup

    asmyshlyaev177/test-proxy-recorder

    Set up test-proxy-recorder for any Playwright project. An agent skill from asmyshlyaev177/test-proxy-recorder.

    112 GitHub stars~4.3k tokensUpdated 3 days ago
    Testing & QAAuto-check passed
  • Qabot Fixture

    shapeshift/web

    Create a new qabot E2E test fixture interactively. An agent skill from shapeshift/web.

    206 GitHub stars~838 tokensUpdated today
    Testing & QAAuto-check: notes

More from airbytehq/airbyte

All 9 skills in this repo
  • Official

    Starts a throwaway MongoDB 7.0 replica set and runs the Airbyte spec, check, discover and read commands against source-mongodb-v2 images for local end-to-end testing.

    22k GitHub stars~1.9k tokensUpdated today
    Auto-check passed
  • Official

    Stands up a throwaway local SQL Server 2022 backend, applies SQL fixtures and runs Airbyte spec, check, discover and read against source-mssql images.

    22k GitHub stars~4.4k tokensUpdated today
    Auto-check passed
  • Official

    Stands up a throwaway local MySQL 8.0 backend, applies SQL fixtures and sweeps the Airbyte spec, check, discover and read commands against a source-mysql image.

    22k GitHub stars~2.6k tokensUpdated today
    Auto-check passed
  • Official

    Starts a local PostgreSQL 16 container, loads SQL fixtures and runs the Airbyte spec, check, discover and read commands against a chosen source-postgres image.

    22k GitHub stars~2.5k tokensUpdated today
    Auto-check passed
  • Official

    Runs the Airbyte protocol sweep for a source-snowflake image against the shared Snowflake integration account, in an isolated per-run schema.

    22k GitHub stars~918 tokensUpdated today
    Auto-check passed
  • Official

    Reproduces MySQL binlog change-data-capture behavior for the Airbyte source-mysql connector on a local MySQL backend, with fixtures, a catalog and smoke cases.

    22k GitHub stars~1.8k tokensUpdated today
    Auto-check passed

Categories

Questions about MSSQL CDC Bug Reproduction Harness

What does MSSQL CDC Bug Reproduction Harness do?

Reproduces change-data-capture bugs in the source-mssql Airbyte connector by enabling CDC on a local SQL Server backend and replaying per-bug SQL fixtures. sh` with the right fixtures and `--expect-*` assertions. Existing cases cover specific reported issues such as LSN cleanup and schema-history handling.

When should I use MSSQL CDC Bug Reproduction Harness?

MSSQL CDC Bug Reproduction Harness fits situations like: reproducing a reported CDC bug against the source-mssql connector locally; verifying that a fix still rejects genuinely invalid CDC state; authoring a new repro case for a customer-reported CDC issue; re-running an existing CDC case against a development build of the connector.

How do I install MSSQL CDC Bug Reproduction Harness in Claude Code?

Run `npx skills add airbytehq/airbyte --skill source-mssql-e2e-cdc-tests -a claude-code`. Or copy the skill folder (airbyte-integrations/connectors/source-mssql/.agents/skills/source-mssql-e2e-cdc-tests in airbytehq/airbyte) into .claude/skills/source-mssql-e2e-cdc-tests in your project. Claude Code loads it when a task matches its description.

How do I install MSSQL CDC Bug Reproduction Harness in Codex?

Run `npx skills add airbytehq/airbyte --skill source-mssql-e2e-cdc-tests -a codex`. Or copy the skill folder (airbyte-integrations/connectors/source-mssql/.agents/skills/source-mssql-e2e-cdc-tests in airbytehq/airbyte) into .agents/skills/source-mssql-e2e-cdc-tests in your project. Codex loads it when a task matches its description.

Can I use MSSQL CDC Bug Reproduction Harness in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add airbytehq/airbyte --skill source-mssql-e2e-cdc-tests -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/source-mssql-e2e-cdc-tests, .gemini/skills/source-mssql-e2e-cdc-tests, .github/skills/source-mssql-e2e-cdc-tests and .opencode/skills/source-mssql-e2e-cdc-tests in your project.

What does MSSQL CDC Bug Reproduction Harness need to run?

Going by SKILL.md and its folder, MSSQL CDC Bug Reproduction Harness needs a shell for the scripts in its folder. Our summary lists: Docker; uv; jq; A clone of the airbytehq/airbyte repository.

Does MSSQL CDC Bug Reproduction Harness access the network?

SKILL.md names 1 domain. As links in the text: github.com. This is read from the text; nothing was executed.

Is MSSQL CDC Bug Reproduction Harness safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does MSSQL CDC Bug Reproduction Harness use?

MSSQL CDC Bug Reproduction Harness has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.

How many tokens does MSSQL CDC Bug Reproduction Harness use?

About 3.3k tokens (SKILL.md is roughly 13k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to MSSQL CDC Bug Reproduction Harness?

Skills that share tags, products or a category with MSSQL CDC Bug Reproduction Harness: Java SDK E2E Test with Replay Snapshot (github/copilot-sdk, 11k stars), Anti Cheating (elliothux/open-compute, 1.6k stars), ClickUp CLI Testing (krodak/clickup-cli, 120 stars) and Testing (web-infra-dev/rstest, 505 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains MSSQL CDC Bug Reproduction Harness?

airbytehq (a GitHub organization, an official publisher) maintains it in airbytehq/airbyte, which has 22,183 GitHub stars. The repository holds 9 skills in this directory. The repository was last updated on October 7, 2026.

Source: airbytehq/airbyte on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.