Official agent skill

source-mssql E2E Test Harness

by airbytehq in airbytehq/airbyte

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

OfficialCustom licenceAuto-check passedTesting & QA

Install source-mssql E2E Test Harness

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

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

GitHub CLI
$ gh skill install airbytehq/airbyte source-mssql-e2e-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-tests .claude/skills/source-mssql-e2e-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-tests
GitHub stars
22k
Token cost
~4.4k tokens
SKILL.md length
1,609 words
Files
8 (incl. scripts)
Skills in repo
9
Repo updated
First seen
Licence
Custom licence

At a glance

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

  • Reproducing a non-CDC source-mssql bug against a local SQL Server
  • SKILL.md covers When to use this skill, Prerequisites, Layout and Conventions, plus 4 more sections
  • Runs Shell scripts from its folder; calls jq, docker and uv
  • Running spec, check, discover and read against a specific connector image tag

What it does

This is a local end-to-end harness for the Airbyte source-mssql connector. It starts a SQL Server 2022 container named source-mssql-db-backend, applies SQL fixtures you supply, and runs the protocol commands spec, check, discover and read against any airbyte/source-mssql image tag through the airbyte-ops regression-test command. Engine-independent orchestration lives in a shared db-harness-lib folder, while this skill keeps the backend scripts, fixtures and config templates.

Output goes under a working directory, /tmp/source-mssql-repro by default, with the rendered config.json, a derived configured_catalog.json and one folder per command holding stdout, stderr and report files in Markdown and HTML. It is for non-CDC reproductions and serves as the base for a separate CDC skill. Docker, uv with airbyte-internal-ops, jq and a clone of the airbyte repository are needed, but no GSM or Cloud admin credentials.

When your agent uses it

  • Reproducing a non-CDC source-mssql bug against a local SQL Server
  • Running spec, check, discover and read against a specific connector image tag
  • Testing connector behavior against custom SQL fixtures

Example prompts

  • “Start a local SQL Server and run the full spec, check, discover and read sweep against the dev tag of source-mssql.”
  • “Apply my fixture file with the sample tables and rerun only discover.”
  • “Reset the databases and reproduce the failing read from this bug report.”

Requirements

  • Docker
  • uv, with airbyte-internal-ops installed
  • jq
  • A clone of the airbytehq/airbyte repository

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 4 files in scripts/ (Shell), which the agent can run.

    Shell commands in SKILL.md call:

    • jq
    • docker
    • uv
    • uvx

    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):

    • docs.astral.sh
    • 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

source-mssql E2E Test Harness loads about 4.4k tokens when it runs. Until then it costs about 87 tokens; SKILL.md has 1,609 words of instructions outside code blocks.

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

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); the scripts in this folder 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,609 words (~4,359 tokens).

“Local end-to-end test harness for source-mssql. The engine-independent orchestration lives in airbyte-integrations/db-harness-lib/; this skill keeps the MSSQL backend lifecycle scripts, fixtures, and config templates. It stands up a SQL Server 2022 container named source-mssql-db-backend, lets you apply arbitrary SQL fixtures…”

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

Read the full SKILL.md on GitHub

Files

SKILL.md and 7 other files (scripts) in airbyte-integrations/connectors/source-mssql/.agents/skills/source-mssql-e2e-tests of airbytehq/airbyte.

  • SKILL.md
  • fixtures/configs/base.template.json
  • fixtures/sql/.gitignore
  • fixtures/sql/00-init-base.sql
  • scripts/apply-sql.sh
  • scripts/reset-databases.sh
  • scripts/run.sh
  • scripts/start-backend.sh

Open the folder on GitHubat commit 38c668c

Compare with similar skills

source-mssql E2E 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-mssql E2E Test Harness compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
source-mssql E2E Test Harness this skillairbytehq/airbyte22k—~4.4kAutomated safety check: PassCustom licence
Go Redis Client Test Runnerredis/go-redis22k—~786Automated safety check: PassBSD-2-Clause
Forge Project Inityaomindong1996/forge-admin125—~1.9kAutomated safety check: NotesApache-2.0
Java SDK E2E Test with Replay Snapshotgithub/copilot-sdk11k—~1.8kAutomated safety check: PassMIT
E2E TestingOpenHands/OpenHands90k—~308Automated safety check: PassMIT
Verdaccio Change Testing Selectorverdaccio/verdaccio18k—~1.6kAutomated safety check: WarnMIT

Similar skills

  • 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
  • Forge Project Init

    yaomindong1996/forge-admin

    Bootstrap a new project from this Forge template end to end, or reset a Forge database into a clean template system.

    125 GitHub stars~1.9k tokensUpdated yesterday
    Testing & QAAuto-check: notes
  • 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
  • E2E Testing

    OpenHands/OpenHands

    This skill should be used when the user asks to "add an E2E test", "run live E2E", "run mock-LLM tests", "debug Playwright CI", "test the Docker image", or changes tests/e2e, Playwright configs, E2E…

    90k GitHub stars~308 tokensUpdated today
    Testing & QAAuto-check passed
  • Figures out which rebuild and test suites actually cover a change in the verdaccio monorepo, instead of a scoped run that passes untested.

    18k GitHub stars~1.6k tokensUpdated today
    Testing & QAAuto-check: warnings
  • Dqd Lab

    ctrsploit/ctrsploit

    Manage ctrsploit dqd lab environments from github.com/ctrsploit/dqd.

    154 GitHub stars~1.6k tokensUpdated 1 mo ago
    Testing & QAAuto-check passed

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 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 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
  • 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

Questions about source-mssql E2E Test Harness

What does source-mssql E2E Test Harness do?

Stands up a throwaway local SQL Server 2022 backend, applies SQL fixtures and runs Airbyte spec, check, discover and read against source-mssql images. This is a local end-to-end harness for the Airbyte source-mssql connector. It starts a SQL Server 2022 container named source-mssql-db-backend, applies SQL fixtures you supply, and runs the protocol commands spec, check, discover and read against any airbyte/source-mssql image tag through the airbyte-ops regression-test command.

When should I use source-mssql E2E Test Harness?

source-mssql E2E Test Harness fits situations like: reproducing a non-CDC source-mssql bug against a local SQL Server; running spec, check, discover and read against a specific connector image tag; testing connector behavior against custom SQL fixtures.

How do I install source-mssql E2E Test Harness in Claude Code?

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

How do I install source-mssql E2E Test Harness in Codex?

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

Can I use source-mssql E2E 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-mssql-e2e-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-tests, .gemini/skills/source-mssql-e2e-tests, .github/skills/source-mssql-e2e-tests and .opencode/skills/source-mssql-e2e-tests in your project.

What does source-mssql E2E Test Harness need to run?

Going by SKILL.md and its folder, source-mssql E2E Test Harness needs a shell for the scripts in its folder and the command-line tools its instructions call (jq, docker, uv and uvx). Our summary lists: Docker; uv, with airbyte-internal-ops installed; jq; A clone of the airbytehq/airbyte repository.

Does source-mssql E2E Test Harness access the network?

SKILL.md names 2 domains. As links in the text: docs.astral.sh and github.com. This is read from the text; nothing was executed.

Is source-mssql E2E 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. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.

What licence does source-mssql E2E Test Harness use?

source-mssql E2E 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-mssql E2E Test Harness use?

About 4.4k tokens (SKILL.md is roughly 17k 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-mssql E2E Test Harness?

Skills that share tags, products or a category with source-mssql E2E Test Harness: Go Redis Client Test Runner (redis/go-redis, 22k stars), Forge Project Init (yaomindong1996/forge-admin, 125 stars), Java SDK E2E Test with Replay Snapshot (github/copilot-sdk, 11k stars) and E2E Testing (OpenHands/OpenHands, 90k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains source-mssql E2E Test 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.