New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Official agent skill

Source MySQL CDC Test Harness

by airbytehq in airbytehq/airbyte

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.

OfficialCustom licenceAuto-check passedTesting & QA

Install Source MySQL CDC Test Harness

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

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

GitHub CLI
$ gh skill install airbytehq/airbyte source-mysql-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-mysql/.agents/skills/source-mysql-e2e-cdc-tests .claude/skills/source-mysql-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-mysql-e2e-cdc-tests
GitHub stars
22k
Token cost
~1.8k tokens
SKILL.md length
709 words
Files
7
Skills in repo
9
Repo updated
First seen
Licence
Custom licence

At a glance

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.

  • Works in 5 steps: Add an idempotent SQL fixture under… → Add a CDC-aware catalog under… → Add cases/.sh with set -euo pipefail, a… → …
  • Reproducing a CDC-mode source-mysql bug 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

This skill adds change-data-capture testing on top of the generic source-mysql end-to-end skill, which starts a local MySQL 8.0 backend and runs the connector, and the shared db-harness-lib orchestration. It supplies the binlog CDC config, a CDC catalog, SQL fixtures and case scripts. CDC for MySQL is binlog-based and server-wide, and the generic backend already starts with row binlogging, full row images and GTIDs, so nothing is enabled per table and no second backend is started.

Typical uses are reproducing a CDC-mode bug locally, checking a fix with a published connector image or a locally built dev version, running the initial-load and incremental-replay smoke cases, and writing a new idempotent repro. Cases reuse one backend kept alive with --keep-backend. The init SQL drops and recreates the cdc_test database each time it is applied, which is why the incremental-replay case skips fixtures in its second phase. The harness is for local use only and is never to be run against a customer connection or Airbyte Cloud.

When your agent uses it

  • Reproducing a CDC-mode source-mysql bug locally
  • Verifying a connector fix with a published image or a local dev build
  • Running initial-load and incremental-replay smoke cases
  • Writing a new MySQL CDC repro with an idempotent SQL fixture

Example prompts

  • “Reproduce the missing-update bug in source-mysql CDC mode using the incremental-replay case.”
  • “Run the initial-load case against the connector I just built locally.”
  • “Add a new CDC repro that inserts rows into the users table and replays state.”

Requirements

  • Docker, uv and jq
  • A clone of airbytehq/airbyte
  • The source-mysql-db-backend container from the generic skill's start-backend.sh script

Workflow steps

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

  1. Add an idempotent SQL fixture under fixtures/sql/. Keep any CDC database
  2. Add a CDC-aware catalog under fixtures/catalogs/ when the case needs a
  3. Add cases/.sh with set -euo pipefail, a ${VERSION:-3.53.4}
  4. For a multi-phase case, model the sequence on
  5. Verify the case against a published image or VERSION=dev, inspect its

What it can do on your machine

Read from SKILL.md and the folder at commit 8dbd366. 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

    No URLs in SKILL.md.

    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

Source MySQL CDC Test Harness loads about 1.8k tokens when it runs. Until then it costs about 50 tokens; SKILL.md has 709 words of instructions outside code blocks.

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

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 709 words (~1,814 tokens).

“Local CDC test harness for source-mysql. It builds on the engine-independent orchestration in airbyte-integrations/db-harness-lib/ and the generic MySQL skill (source-mysql-e2e-tests). The generic skill starts a MySQL 8.0 backend and runs the connector; this skill supplies the binlog CDC config, CDC…”

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

Read the full SKILL.md on GitHub

Files

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

  • SKILL.md
  • cases/incremental-replay.sh
  • cases/initial-load.sh
  • fixtures/catalogs/users-cdc.json
  • fixtures/configs/cdc.template.json
  • fixtures/sql/00-init-cdc.sql
  • fixtures/sql/mutate-insert-users.sql

Open the folder on GitHubat commit 8dbd366

Compare with similar skills

Source MySQL CDC Test 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.

Source MySQL CDC Test Harness compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Source MySQL CDC Test Harness this skillairbytehq/airbyte22k—~1.8kAutomated safety check: PassCustom licence
Service Virtualizationpetrkindlmann/qa-skills165—~4.1kAutomated safety check: PassMIT
Create Environmentgodatadriven/whirl205—~1.9kAutomated safety check: PassApache-2.0
Run Testsansible-collections/ansible.mysql134—~1.2kAutomated safety check: PassCustom licence
Database Testingpetrkindlmann/qa-skills165—~4.2kAutomated safety check: PassMIT
Clickhouse Local Dev Loopjeremylongshore/tons-of-skills-marketplace2.8k—~1.5kAutomated safety check: NotesMIT

Similar skills

  • Service Virtualization

    petrkindlmann/qa-skills

    Decision framework for isolating every external dependency in a test suite: when to use in-process mocks, HTTP stubs (MSW, WireMock), record-replay, fault injection (Toxiproxy), or ephemeral real…

    165 GitHub stars~4.1k tokensUpdated 3 mo ago
    Testing & QAAuto-check passed

  • Create Environment

    godatadriven/whirl

    Create a new Whirl environment in the envs/ directory. An agent skill from godatadriven/whirl.

    205 GitHub stars~1.9k tokensUpdated 6 days ago
    Backend & APIsAuto-check passed

  • Run Tests

    ansible-collections/ansible.mysql

    Runs and writes tests (sanity, unit, integration) for the ansible.mysql Ansible collection using ansible-test.

    134 GitHub stars~1.2k tokensUpdated 2 days ago
    DevOps & CloudAuto-check passed

  • Database Testing

    petrkindlmann/qa-skills

    Validate database integrity, test migrations forward and backward, verify schema constraints, manage seed data, detect migration drift, and identify query performance issues.

    165 GitHub stars~4.2k tokensUpdated 3 mo ago
    DatabasesAuto-check passed

  • Clickhouse Local Dev Loop

    jeremylongshore/tons-of-skills-marketplace

    Run ClickHouse locally with Docker, configure test fixtures, and iterate fast.

    2.8k GitHub stars~1.5k tokensUpdated today
    DatabasesAuto-check: notes

  • Go Redis Client Test Runner

    redis/go-redis

    Official

    Explains how to run go-redis tests: the Docker Compose stack, make targets, focusing a single Ginkgo spec, the e2e suite and the version environment variables.

    22k GitHub stars~786 tokensUpdated yesterday
    Testing & QAAuto-check passed

More from airbytehq/airbyte

All 9 skills in this repo

  • MongoDB Source Connector E2E Harness

    airbytehq/airbyte

    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

  • source-mssql E2E Test Harness

    airbytehq/airbyte

    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

  • Airbyte source-mysql E2E Tests

    airbytehq/airbyte

    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

  • Airbyte Postgres Source E2E Tests

    airbytehq/airbyte

    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

  • Source Snowflake E2E Tests

    airbytehq/airbyte

    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

  • MSSQL CDC Bug Reproduction Harness

    airbytehq/airbyte

    Official

    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.

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

Works with

Categories

Questions about Source MySQL CDC Test Harness

What does Source MySQL CDC Test Harness do?

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. 0 backend and runs the connector, and the shared db-harness-lib orchestration. It supplies the binlog CDC config, a CDC catalog, SQL fixtures and case scripts.

When should I use Source MySQL CDC Test Harness?

Source MySQL CDC Test Harness fits situations like: reproducing a CDC-mode source-mysql bug locally; verifying a connector fix with a published image or a local dev build; running initial-load and incremental-replay smoke cases; writing a new MySQL CDC repro with an idempotent SQL fixture.

How do I install Source MySQL CDC Test Harness in Claude Code?

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

How do I install Source MySQL CDC Test Harness in Codex?

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

Can I use Source MySQL CDC Test 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-mysql-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-mysql-e2e-cdc-tests, .gemini/skills/source-mysql-e2e-cdc-tests, .github/skills/source-mysql-e2e-cdc-tests and .opencode/skills/source-mysql-e2e-cdc-tests in your project.

What does Source MySQL CDC Test Harness need to run?

Going by SKILL.md and its folder, Source MySQL CDC Test Harness needs a shell for the scripts in its folder. Our summary lists: Docker, uv and jq; A clone of airbytehq/airbyte; The source-mysql-db-backend container from the generic skill's start-backend.sh script.

Does Source MySQL CDC Test Harness access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Source MySQL CDC Test 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 Source MySQL CDC Test Harness use?

Source MySQL CDC Test 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 Source MySQL CDC Test Harness use?

About 1.8k tokens (SKILL.md is roughly 7.3k 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 Source MySQL CDC Test Harness?

Skills that share tags, products or a category with Source MySQL CDC Test Harness: Service Virtualization (petrkindlmann/qa-skills, 165 stars), Create Environment (godatadriven/whirl, 205 stars), Run Tests (ansible-collections/ansible.mysql, 134 stars) and Database Testing (petrkindlmann/qa-skills, 165 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Source MySQL CDC Test Harness?

airbytehq (a GitHub organization, an official publisher) maintains it in airbytehq/airbyte, which has 22,188 GitHub stars. The repository holds 9 skills in this directory. The repository was last updated on October 8, 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.