migration

End-to-end orchestrator for migrating a single stored procedure to a dbt model. Invoke when the user asks to "migrate a table", "convert a procedure to dbt", or "run the full migration pipeline". Coordinates discover, profile, and migrate skills in sequence with user gates.

Batch migration agent — generates dbt models from stored procedures using profile, resolved statements, and LLM generation. No approval gates.

Batch profiling agent that produces migration profile candidates for each table. Runs profile.py for context, applies LLM reasoning for the six profiling questions, and writes results into catalog files.

Identifies writer procedures from catalog data and produces a CandidateWriters JSON output. Use when scoping a migration item.

This skill should be used when the user asks to "list tables", "list procedures", "list views", "list functions", "show me the DDL for X", "inspect object X", "what references Y", "find what writes to [table]", "which procedures populate [table]", or wants to explore the structure of a DDL export directory. Use for any object inspection, reference tracing, or writer discovery against a local DDL snapshot.

Generates a dbt model from a stored procedure. Invoke when the user asks to "migrate a procedure", "generate a dbt model", "convert SP to dbt", or "create a model for <table>". Requires catalog profile and resolved statements from prior discover + profile stages.

Profile a single table for migration. Assembles deterministic context from catalog and DDL, reasons over the six profiling questions using what-to-profile-and-why.md, presents profile candidates for user approval, then writes the approved profile into the table catalog file. Use when the user asks to "profile a table", "classify a table", "what kind of model is this table", or wants to determine PK, FK, watermark, or PII for a migration target.