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

Airbyte Postgres Source E2E Tests

by airbytehq in airbytehq/airbyte

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.

OfficialCustom licenceAuto-check passedTesting & QA

Install Airbyte Postgres Source E2E Tests

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

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

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

At a glance

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.

  • Reproducing a source-postgres bug against a local database
  • SKILL.md covers When to use this skill, Prerequisites, Layout and Conventions, plus 5 more sections
  • Runs Shell scripts from its folder; calls uvx; needs BACKEND_PASSWORD
  • Running spec, check, discover and read against a specific image tag

What it does

This skill is a local test harness for the Airbyte source-postgres connector. Its scripts start a PostgreSQL 16 container named source-postgres-db-backend, apply SQL fixtures such as 00-init-base.sql, reset the databases and render a connector config from a template. A run.sh script then drives the protocol commands spec, check, discover and read through airbyte-ops cloud connector regression-test, with shared orchestration kept in a separate db-harness-lib folder.

You can reproduce a connector bug locally, sweep all four commands or just one against any airbyte/source-postgres image tag, or prove a fix by comparing a target image with a control image. Results for each step land under a working directory, /tmp/source-postgres-repro by default, with the rendered config and one folder per command. Only standard sweeps are covered, because CDC fixtures and replication setup are not yet included.

When your agent uses it

  • Reproducing a source-postgres bug against a local database
  • Running spec, check, discover and read against a specific image tag
  • Comparing a fix image with a control image

Example prompts

  • “Spin up the Postgres backend and run a full protocol sweep against the dev image of source-postgres.”
  • “Load my SQL fixture and check whether discover returns the new table.”
  • “Reset the test databases and rerun the read step against the control image.”

Requirements

  • Docker
  • uv, with airbyte-internal-ops installed so airbyte-ops is on the PATH
  • 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:

    • 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 these keys or tokens, usually read from environment variables:

    • BACKEND_PASSWORD

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

Context cost

Airbyte Postgres Source E2E Tests loads about 2.5k tokens when it runs. Until then it costs about 57 tokens; SKILL.md has 935 words of instructions outside code blocks.

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

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 935 words (~2,499 tokens).

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

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

Read the full SKILL.md on GitHub

Files

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

  • SKILL.md
  • fixtures/configs/base.template.json
  • 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

Airbyte Postgres Source E2E Tests 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.

Airbyte Postgres Source E2E Tests compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Airbyte Postgres Source E2E Tests this skillairbytehq/airbyte22k—~2.5kAutomated safety check: PassCustom licence
Go Redis Client Test Runnerredis/go-redis22k—~786Automated safety check: PassBSD-2-Clause
Java SDK E2E Test with Replay Snapshotgithub/copilot-sdk11k—~1.8kAutomated safety check: PassMIT
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

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

  • Java SDK E2E Test with Replay Snapshot

    github/copilot-sdk

    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

  • 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 yesterday
    Testing & QAAuto-check passed

  • Mobile Testing

    irahardianto/awesome-agv

    Mobile E2E testing patterns — Flutter integrationtest, Patrol, Maestro, golden testing, device matrix, and test data management.

    157 GitHub stars~1.8k tokensUpdated 2 days ago
    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

  • 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

  • Source MySQL CDC Test Harness

    airbytehq/airbyte

    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

Works with

Categories

Questions about Airbyte Postgres Source E2E Tests

What does Airbyte Postgres Source E2E Tests do?

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. This skill is a local test harness for the Airbyte source-postgres connector.sql, reset the databases and render a connector config from a template.

When should I use Airbyte Postgres Source E2E Tests?

Airbyte Postgres Source E2E Tests fits situations like: reproducing a source-postgres bug against a local database; running spec, check, discover and read against a specific image tag; comparing a fix image with a control image.

How do I install Airbyte Postgres Source E2E Tests in Claude Code?

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

How do I install Airbyte Postgres Source E2E Tests in Codex?

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

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

What does Airbyte Postgres Source E2E Tests need to run?

Going by SKILL.md and its folder, Airbyte Postgres Source E2E Tests needs a shell for the scripts in its folder, the command-line tools its instructions call (uvx) and credentials named BACKEND_PASSWORD. Our summary lists: Docker; uv, with airbyte-internal-ops installed so airbyte-ops is on the PATH; jq; A clone of the airbytehq/airbyte repository.

Does Airbyte Postgres Source E2E Tests 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 Airbyte Postgres Source E2E Tests 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 Airbyte Postgres Source E2E Tests use?

Airbyte Postgres Source E2E Tests 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 Airbyte Postgres Source E2E Tests use?

About 2.5k tokens (SKILL.md is roughly 10k 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 Airbyte Postgres Source E2E Tests?

Skills that share tags, products or a category with Airbyte Postgres Source E2E Tests: Go Redis Client Test Runner (redis/go-redis, 22k stars), Java SDK E2E Test with Replay Snapshot (github/copilot-sdk, 11k stars), Integration Tests for pREST (prest/prest, 4.6k stars) and Local Platform E2E (computesdk/benchmarks, 126 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Airbyte Postgres Source E2E Tests?

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.