Agent skill

Rocky Test Fixtures

by rocky-data in rocky-data/rocky

Dagster integration test fixture lifecycle. An agent skill from rocky-data/rocky.

Apache-2.0Auto-check passedTesting & QA

Install Rocky Test Fixtures

skills CLI
$ npx skills add rocky-data/rocky --skill rocky-test-fixtures -a claude-code

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

GitHub CLI
$ gh skill install rocky-data/rocky rocky-test-fixtures --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/rocky-data/rocky.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/rocky-test-fixtures .claude/skills/rocky-test-fixtures && 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
rocky-test-fixtures
GitHub stars
304
Token cost
~2.3k tokens
SKILL.md length
993 words
Files
1
Skills in repo
22
Repo updated
First seen
Licence
Apache-2.0

At a glance

Dagster integration test fixture lifecycle. An agent skill from rocky-data/rocky.

  • Works in 2 steps: Release binary at… → duckdb CLI on $PATH — used to seed the…
  • Regenerating live-binary fixtures via just regen-fixtures / scripts/regenfixtures.sh
  • SKILL.md covers The two test-data surfaces, When to use this skill, Regeneration workflow and Prerequisites, plus 7 more sections
  • Calls just, cargo and uv

What it does

Rocky Test Fixtures is an agent skill from rocky-data/rocky. Dagster integration test fixture lifecycle. Use when regenerating live-binary fixtures via just regen-fixtures / scripts/regenfixtures.sh, debugging why a generated fixture differs across runs, or adding scenario data for new CLI commands. Covers determinism (zeroed timings, sentinel timestamps), the relationship between tests/scenarios.py and tests/fixturesgenerated/, and the two POCs that back the corpus.

Its SKILL.md is about 2.3k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Testing & QA, covering Test data and fixtures, Integration testing and Debugging. It works with Dagster and Pydantic. The repository describes itself as: A SQL transformation engine that type-checks your whole pipeline and catches breaking changes before they run — branches, replay, column-level lineage, compile-time contracts… The licence is Apache-2.0.

When your agent uses it

  • Regenerating live-binary fixtures via just regen-fixtures / scripts/regenfixtures.sh
  • Debugging why a generated fixture differs across runs
  • Adding scenario data for new CLI commands

Example prompts

  • “/rocky-test-fixtures”

Requirements

  • Python 3

Workflow steps

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

  1. Release binary at engine/target/release/rocky — build with
  2. duckdb CLI on $PATH — used to seed the playground POC's DuckDB file

What it can do on your machine

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

    Shell commands in SKILL.md call:

    • just
    • cargo
    • uv
    • brew
    • git

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

  • Network

    No URLs in SKILL.md. Its commands use uv and git, which can reach the network depending on how they are called.

    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

Rocky Test Fixtures loads about 2.3k tokens when it runs. Until then it costs about 110 tokens; SKILL.md has 993 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~110
When it runs · the whole SKILL.md, loaded when a task matches
~2.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

The full file from rocky-data/rocky at commit 365aebf, republished under its Apache-2.0 licence (© rocky-data). 993 words, ~2,267 tokens.

Download SKILL.mdSave it as .claude/skills/rocky-test-fixtures/SKILL.md (or your agent's skills folder).
name
rocky-test-fixtures
description
Dagster integration test fixture lifecycle. Use when regenerating live-binary fixtures via `just regen-fixtures` / `scripts/regen_fixtures.sh`, debugging why a generated fixture differs across runs, or adding scenario data for new CLI commands. Covers determinism (zeroed timings, sentinel timestamps), the relationship between `tests/scenarios.py` and `tests/fixtures_generated/`, and the two POCs that back the corpus.

Dagster test fixture regeneration

The dagster integration has two parallel sources of test data with different roles. Conflating them causes confusion, so this skill is worth reading before touching either.

The two test-data surfaces

PathRoleEdit policy
integrations/dagster/tests/scenarios.pySource of truth for parsing/translator/component tests. Hand-crafted Python dicts exposed as *_json pytest fixtures via conftest.py (which json.dumps each scenario).Edit by hand. Add new scenarios when introducing a new CLI command or covering a new shape.
integrations/dagster/tests/fixtures_generated/Live-binary corpus. Captured from the running rocky binary against the playground POCs. Used for drift detection — test_generated_fixtures.py re-validates that every captured JSON still parses against the current Pydantic models.Regenerated by just regen-fixtures. Don't hand-edit — the next regen overwrites your changes.

Tests in test_types.py, test_translator.py, test_component.py, etc. consume the *_json fixtures backed by scenarios.py. The generated corpus is exercised solely by test_generated_fixtures.py to catch shape drift between the Rust binary and the Pydantic models.

A legacy tests/fixtures/*.json directory previously held the parsing-test corpus; it was removed once scenarios.py became the source of truth. See conftest.py for the migration note. The --in-place flag in scripts/regen_fixtures.sh still targets that directory and is effectively a no-op today.

When to use this skill

  • Changing any *Output struct that affects a fixture's shape (pairs with the rocky-codegen skill — codegen updates the Pydantic models; the captured fixtures should still parse against them)
  • Adding a brand new CLI command that needs a parsing test in test_types.py (you'll add a scenarios.py entry, not a JSON file)
  • Investigating why test_generated_fixtures.py fails after a binary or schema change
  • Debugging non-determinism in a captured fixture (timestamps, durations, row counts)

Regeneration workflow

bash
just regen-fixtures
# or
./scripts/regen_fixtures.sh

Writes to integrations/dagster/tests/fixtures_generated/. The captured JSON should git diff cleanly except for fields that legitimately changed; non-trivial diffs warrant inspection.

After regenerating, always run from integrations/dagster/:

bash
uv run pytest tests/test_generated_fixtures.py -v

This catches any captured-output shape that no longer parses against the current Pydantic models.

Prerequisites

The script hard-fails if either is missing:

  1. Release binary at engine/target/release/rocky — build with:

    bash
    cd engine && cargo build --release --bin rocky

    or run just codegen (which also builds in release mode and shares the artifact).

  2. duckdb CLI on $PATH — used to seed the playground POC's DuckDB file:

    bash
    brew install duckdb        # macOS

Two POCs back the corpus

regen_fixtures.sh runs the binary against two playground POCs, captured into different subdirectories of fixtures_generated/:

POCPurposeFixtures produced
examples/playground/pocs/00-foundations/01-replication-basics/Baseline full_refresh replication pipeline. Produces most fixtures. (00-playground-default is now a transformation pipeline; this is its verbatim replication clone, kept as the fixture source so captures stay byte-identical.)discover.json, plan.json, run.json, state.json, compile.json, test.json, ci.json, lineage.json, doctor.json, history.json, metrics.json, optimize.json, etc.
examples/playground/pocs/02-performance/03-partition-checksum/time_interval (partition-keyed) pipeline. Exercises partition-specific shapes.partition/compile.json, partition/run_single.json, partition/run_backfill.json, partition/run_late.json

If you need a fixture shape that neither POC produces naturally (e.g. drift.json from a non-zero schema diff), add it as a scenarios.py entry rather than coercing the POC into producing it.

Determinism: why captured JSON is stable across runs

Without post-processing, every regen would produce a slightly different diff because Rocky stamps:

  • Duration fields with real wall-clock elapsed time (_ms, _seconds, _secs suffixes)
  • Timestamp fields with now() (updated_at, started_at, finished_at, timestamp, captured_at)

The capture helper inside regen_fixtures.sh runs a Python normalizer (scripts/_normalize_fixture.py) over each captured JSON file that:

  • Zeroes any numeric field whose key ends in _ms / _seconds / _secs
  • Replaces any string field whose key is in the wall-clock set with "2000-01-01T00:00:00Z"

Important invariants the normalizer preserves:

  • last_value (watermarks) — NOT touched. It's a logical value derived from seeded data and is genuinely deterministic across runs.
  • Anything inside a data payload — NOT touched. Only top-level wall-clock fields get the sentinel.

If you add a new timing or timestamp field to an *Output struct, you may need to extend TIMING_SUFFIXES or WALL_CLOCK_FIELDS in the normalizer. Otherwise your new fixture will drift on every regen.

Show full SKILL.md (385 more words)Show less

Exit-code tolerance

The capture helper tolerates non-zero exit codes as long as stdout parses as JSON. This is intentional:

  • rocky doctor exits 1 when any check is warning, 2 when critical — and both still emit valid JSON.
  • rocky run can exit non-zero on partial success and still emit a valid RunOutput.

The dagster integration's allow_partial=True path mirrors this tolerance in production — see integrations/dagster/src/dagster_rocky/resource.py.

Adding parsing-test coverage for a new CLI command

For a new CLI command whose output the dagster tests need to parse:

  1. Rust schema exists (from the rocky-codegen skill).
  2. Pydantic binding exists (from just codegen-sdk).
  3. Add a scenarios.py entry with a representative output dict, then expose it via a *_json pytest fixture in conftest.py.
  4. Add a parsing test in test_types.py that loads the fixture and asserts on key fields.
  5. Optionally, add a capture call in scripts/regen_fixtures.sh so the playground POC contributes a live-binary sample under fixtures_generated/. Run just regen-fixtures afterwards.

If the playground POC can't produce the command naturally (e.g. an adapter-specific command that needs Databricks), skip step 5 — the scenarios.py entry is the test source of truth.

Debugging fixture drift

Symptoms and causes:

SymptomLikely cause
test_generated_fixtures.py fails with ValidationErrorPydantic model changed but captured fixture is stale — run just regen-fixtures
fixtures_generated/<name>.json differs by a single _ms fieldNormalizer missed a new duration field — extend TIMING_SUFFIXES
Fixture differs wildly between runsPlayground POC has non-deterministic seed data (rare) or a new timestamp field — extend WALL_CLOCK_FIELDS
capture prints ==> <name> but the file is emptyCommand exited non-zero AND wrote to stderr, not stdout — check the command manually
rocky binary not found at engine/target/release/rockyMissing release build — run cd engine && cargo build --release --bin rocky or just codegen
Partition fixtures missing but main ones present02-performance/03-partition-checksum POC missing or broken — check ls examples/playground/pocs/02-performance/03-partition-checksum/

Reference files

  • scripts/regen_fixtures.sh — the capture pipeline + POC list
  • scripts/_normalize_fixture.py — wall-clock + timing normalizer
  • integrations/dagster/tests/scenarios.py — hand-crafted Python dict scenarios (test source of truth)
  • integrations/dagster/tests/conftest.py — *_json fixture exposure
  • integrations/dagster/tests/test_generated_fixtures.py — the test that guards the captured corpus
  • integrations/dagster/AGENTS.md — "Adding support for a new Rocky CLI command" checklist (includes the scenarios step)
  • justfile — the regen-fixtures recipe (wraps the script)
  • rocky-codegen — the Rust → Pydantic/TS cascade that fixtures are validated against
  • rocky-new-cli-command — the end-to-end checklist that includes scenario/fixture creation
  • rocky-poc — authoring the playground POCs that the captured fixture corpus depends on

© rocky-data, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in .agents/skills/rocky-test-fixtures of rocky-data/rocky.

Open the folder on GitHubat commit 365aebf

Compare with similar skills

Rocky Test Fixtures 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.

Rocky Test Fixtures compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Rocky Test Fixtures this skillrocky-data/rocky304—~2.3kAutomated safety check: PassApache-2.0
Java SDK E2E Test with Replay Snapshotgithub/copilot-sdk11k—~1.8kAutomated safety check: PassMIT
Airbyte Postgres Source E2E Testsairbytehq/airbyte22k—~2.5kAutomated safety check: PassCustom licence
Aspire Integration TestingDevBetterCom/DevBetterWeb1572 repos~2.3kAutomated safety check: PassNone
Robotics Testingarpitg1304/robotics-agent-skills369—~4.7kAutomated safety check: PassApache-2.0
Source MySQL CDC Test Harnessairbytehq/airbyte22k—~1.8kAutomated safety check: PassCustom licence

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

    DevBetterCom/DevBetterWeb

    Write integration tests using .NET Aspire's testing facilities with xUnit.

    157 GitHub starsUsed in 2 repos~2.3k tokens
    Testing & QAAuto-check passed
  • Robotics Testing

    arpitg1304/robotics-agent-skills

    Testing strategies, patterns, and tools for robotics software.

    369 GitHub stars~4.7k tokensUpdated 2 mo ago
    Testing & QAAuto-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
    Testing & QAAuto-check passed
  • Create interactive PHP test case scripts for Dolibarr ERP/CRM that allow users to setup test data, view results via direct links, and tear down (clean up) the data.

    7.7k GitHub starsUsed in 1 repo~5.5k tokens
    Testing & QAAuto-check passed

More from rocky-data/rocky

All 22 skills in this repo
  • Fivetran

    rocky-data/rocky

    Fivetran REST API reference for Rocky's source adapter. An agent skill from rocky-data/rocky.

    304 GitHub stars~914 tokensUpdated yesterday
    Auto-check passed
  • Databricks

    rocky-data/rocky

    Databricks REST API and SQL reference for Rocky's warehouse adapter.

    304 GitHub stars~2k tokensUpdated yesterday
    Auto-check passed
  • Rocky Codegen

    rocky-data/rocky

    Rocky CLI JSON-output schema cascade. An agent skill from rocky-data/rocky.

    304 GitHub stars~1.9k tokensUpdated yesterday
    Auto-check passed
  • Rocky Dev

    rocky-data/rocky

    Top-level router for Rocky development tasks. An agent skill from rocky-data/rocky.

    304 GitHub stars~2.1k tokensUpdated yesterday
    Auto-check passed
  • Rocky Dsl Change

    rocky-data/rocky

    Rocky DSL (.rocky file) cross-subproject cascade. An agent skill from rocky-data/rocky.

    304 GitHub stars~1.3k tokensUpdated yesterday
    Auto-check passed
  • Rocky New Adapter

    rocky-data/rocky

    Adding a new warehouse or source adapter crate to the Rocky engine.

    304 GitHub stars~2k tokensUpdated yesterday
    Auto-check passed

Works with

Categories

Questions about Rocky Test Fixtures

What does Rocky Test Fixtures do?

Dagster integration test fixture lifecycle. An agent skill from rocky-data/rocky. Rocky Test Fixtures is an agent skill from rocky-data/rocky. Dagster integration test fixture lifecycle.

When should I use Rocky Test Fixtures?

Rocky Test Fixtures fits situations like: regenerating live-binary fixtures via just regen-fixtures / scripts/regenfixtures.sh; debugging why a generated fixture differs across runs; adding scenario data for new CLI commands.

How do I install Rocky Test Fixtures in Claude Code?

Run `npx skills add rocky-data/rocky --skill rocky-test-fixtures -a claude-code`. Or copy the skill folder (.agents/skills/rocky-test-fixtures in rocky-data/rocky) into .claude/skills/rocky-test-fixtures in your project. Claude Code loads it when a task matches its description.

How do I install Rocky Test Fixtures in Codex?

Run `npx skills add rocky-data/rocky --skill rocky-test-fixtures -a codex`. Or copy the skill folder (.agents/skills/rocky-test-fixtures in rocky-data/rocky) into .agents/skills/rocky-test-fixtures in your project. Codex loads it when a task matches its description.

Can I use Rocky Test Fixtures 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 rocky-data/rocky --skill rocky-test-fixtures -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/rocky-test-fixtures, .gemini/skills/rocky-test-fixtures, .github/skills/rocky-test-fixtures and .opencode/skills/rocky-test-fixtures in your project.

What does Rocky Test Fixtures need to run?

Going by SKILL.md and its folder, Rocky Test Fixtures needs the command-line tools its instructions call (just, cargo, uv, brew and git). Our summary lists: Python 3.

Does Rocky Test Fixtures access the network?

SKILL.md contains no URLs. Its commands use uv and git, which can reach the network depending on how they are called. This is read from the text; nothing was executed.

Is Rocky Test Fixtures 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 Rocky Test Fixtures use?

Rocky Test Fixtures is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Rocky Test Fixtures use?

About 2.3k tokens (SKILL.md is roughly 9.1k 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 Rocky Test Fixtures?

Skills that share tags, products or a category with Rocky Test Fixtures: Java SDK E2E Test with Replay Snapshot (github/copilot-sdk, 11k stars), Airbyte Postgres Source E2E Tests (airbytehq/airbyte, 22k stars), Aspire Integration Testing (DevBetterCom/DevBetterWeb, 157 stars) and Robotics Testing (arpitg1304/robotics-agent-skills, 369 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Rocky Test Fixtures?

rocky-data (a GitHub organization) maintains it in rocky-data/rocky, which has 304 GitHub stars. The repository holds 22 skills in this directory. The repository was last updated on October 10, 2026.

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