New: 97,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

Postgres CDC E2E Test Harness

by airbytehq in airbytehq/airbyte

Reproduces PostgreSQL logical-decoding CDC behavior for Airbyte's source-postgres connector on a local backend, with CDC fixtures, a catalog and smoke case scripts.

OfficialCustom licenceAuto-check passedTesting & QA

Install Postgres CDC E2E Test Harness

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

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

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

At a glance

Reproduces PostgreSQL logical-decoding CDC behavior for Airbyte's source-postgres connector on a local backend, with CDC fixtures, a catalog and smoke case scripts.

  • 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-postgres bug on a local machine
  • 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 harness builds on the shared `db-harness-lib` and the generic source-postgres test skill, which starts a PostgreSQL 16 backend and runs the connector. The CDC skill adds the logical-decoding config, a CDC catalog, SQL fixtures and case scripts. That backend already starts with the WAL and replication-slot settings CDC needs, so no second backend or per-run server configuration is added. The fixture works in the shared `test_db` database and resets the `users` table, publication and replication slot there.

It is used to reproduce a CDC-mode bug locally, verify a fix with a published connector image or a locally built dev version, run the initial-load and incremental-replay smoke cases, or author a new repro with an idempotent SQL fixture and a case script that calls the generic `scripts/run.sh`. Cases keep the backend running between runs: start it once, run the cases, then tear it down. It needs no cloud admin credentials and must never be pointed at a customer connection or Airbyte Cloud.

When your agent uses it

  • Reproducing a CDC-mode source-postgres bug on a local machine
  • Verifying a connector fix against the initial-load and incremental-replay cases
  • Writing a new PostgreSQL CDC repro with a repeatable SQL fixture

Example prompts

  • “Start the Postgres backend and run the incremental-replay CDC case against the published connector image.”
  • “Reproduce the missing-update bug in CDC mode with a new SQL fixture and case script.”
  • “Run both CDC smoke cases against my locally built source-postgres dev image.”

Requirements

  • Docker, `uv` and `jq`
  • A clone of airbytehq/airbyte
  • The source-postgres backend container started by the generic skill

Workflow steps

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

  1. Add an idempotent SQL fixture under fixtures/sql/. Keep CDC setup in the
  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.8.5}
  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 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

    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

Postgres CDC E2E Test Harness loads about 1.9k tokens when it runs. Until then it costs about 56 tokens; SKILL.md has 773 words of instructions outside code blocks.

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

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

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

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

Read the full SKILL.md on GitHub

Files

SKILL.md and 6 other files in airbyte-integrations/connectors/source-postgres/.agents/skills/source-postgres-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 38c668c

Compare with similar skills

Postgres CDC 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.

Postgres CDC E2E Test Harness compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Postgres CDC E2E Test Harness this skillairbytehq/airbyte22k—~1.9kAutomated safety check: PassCustom licence
Go Redis Client Test Runnerredis/go-redis22k—~786Automated safety check: PassBSD-2-Clause
Integration Tests for pRESTprest/prest4.6k—~1.1kAutomated safety check: PassMIT
Local Platform E2Ecomputesdk/benchmarks126—~3kAutomated safety check: NotesMIT
E2Eopenathleteorg/openathlete100—~675Automated safety check: PassAGPL-3.0
PR TestElite588/AUTOGPT103—~9.4kAutomated safety check: NotesCustom licence

Similar skills

  • 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

  • Integration Tests for pREST

    prest/prest

    Guides writing and reviewing pREST Docker-based integration tests so every HTTP request is explained by step comments or table-driven descriptions.

    4.6k GitHub stars~1.1k tokensUpdated yesterday
    Testing & QAAuto-check passed

  • Local Platform E2E

    computesdk/benchmarks

    Stand up benchmarks-platform locally (Postgres + MinIO + ClickHouse in docker) and run a real @benchsdk/runner benchmark against it, with no cloud or provider credentials.

    126 GitHub stars~3k tokensUpdated today
    DatabasesAuto-check: notes

  • E2E

    openathleteorg/openathlete

    Run, debug or extend the OpenAthlete Playwright end-to-end tests, which exercise the production Docker images (API, worker, web, PostgreSQL, Redis) through the API and a real browser on desktop and…

    100 GitHub stars~675 tokensUpdated today
    Testing & QAAuto-check passed

  • PR Test

    Elite588/AUTOGPT

    E2E manual testing of PRs/branches using docker compose, agent-browser, and API calls.

    103 GitHub stars~9.4k tokensUpdated 5 mo ago
    Testing & QAAuto-check: notes

  • E2E Test

    divinevideo/divine-mobile

    Run and debug Flutter E2E integration tests that exercise the real app against a local Docker backend (no mocks).

    265 GitHub stars~3.8k tokensUpdated today
    Testing & QAAuto-check: notes

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 Postgres CDC E2E Test Harness

What does Postgres CDC E2E Test Harness do?

Reproduces PostgreSQL logical-decoding CDC behavior for Airbyte's source-postgres connector on a local backend, with CDC fixtures, a catalog and smoke case scripts. This harness builds on the shared `db-harness-lib` and the generic source-postgres test skill, which starts a PostgreSQL 16 backend and runs the connector. The CDC skill adds the logical-decoding config, a CDC catalog, SQL fixtures and case scripts.

When should I use Postgres CDC E2E Test Harness?

Postgres CDC E2E Test Harness fits situations like: reproducing a CDC-mode source-postgres bug on a local machine; verifying a connector fix against the initial-load and incremental-replay cases; writing a new PostgreSQL CDC repro with a repeatable SQL fixture.

How do I install Postgres CDC E2E Test Harness in Claude Code?

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

How do I install Postgres CDC E2E Test Harness in Codex?

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

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

What does Postgres CDC E2E Test Harness need to run?

Going by SKILL.md and its folder, Postgres CDC E2E 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-postgres backend container started by the generic skill.

Does Postgres CDC E2E 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 Postgres CDC 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. Review the folder before installing.

What licence does Postgres CDC E2E Test Harness use?

Postgres CDC 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 Postgres CDC E2E Test Harness use?

About 1.9k tokens (SKILL.md is roughly 7.8k 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 Postgres CDC E2E Test Harness?

Skills that share tags, products or a category with Postgres CDC E2E Test Harness: Go Redis Client Test Runner (redis/go-redis, 22k stars), Integration Tests for pREST (prest/prest, 4.6k stars), Local Platform E2E (computesdk/benchmarks, 126 stars) and E2E (openathleteorg/openathlete, 100 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Postgres CDC 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.