ad-migration

Scan git worktrees for branches with merged PRs and clean them up (remove worktree, delete local and remote branches). Then sweep gone branches and remote-only branches that have merged PRs.

Batch model generation command — generates dbt models from stored procedures. Coordinates generation, review, unit-test setup, and unit-test repair stages via focused sub-agents.

Use when one or more migrated tables are ready for end-to-end test generation after scoping and profiling, and the command workflow should run generation, independent review, and expectation capture together.

Bootstraps a migration project and validates local prerequisites before source, target, and sandbox CLI setup.

Whole-scope mart migration planner. Validates readiness, scoping completeness, catalog ownership resolution, and writes a resumable Markdown operational plan.

Use when scoping a single table, view, or materialized view for migration and the next step depends on identifying its writer, SQL structure, or dependency call tree from catalog-backed DDL context.

Use when generated dbt unit test specs may have branch-coverage gaps, fixture-quality problems, or unresolved warnings across table, view, or materialized-view cases

Use when editing, generating, reviewing, or debugging migrated dbt unit test specs and review artifacts that must stay consistent across paired test skills.

Use automatically before any completion, successful, passing, PR-ready, merged, or stage-complete statement to verify fresh evidence and choose accurate claim wording.

Use when profiling a single table, view, or materialized view for migration and the next step depends on persisted classification, keying, watermark, foreign-key typing, PII handling, or stg-vs-mart view classification.