Prompt file imported from asabocinski/bravo-edd (
.codex/prompts/migrate.md). Copyright stays with the author.
Migrate Command
Migrate legacy ETL (stored procedures, SSIS, Informatica) to modern stack
Usage
/migrate <description-or-file>
Examples
/migrate "Convert stored procedures to dbt models"
/migrate legacy/etl_orders_proc.sql
/migrate "Migrate Informatica workflows to Airflow + dbt"
/migrate "Move SSIS packages to Spark + Iceberg"
What This Command Does
- Analyzes legacy ETL code or description
- Invokes the appropriate agent based on target stack
- Loads KB patterns from
dbt,spark, andairflowdomains - Generates:
- Equivalent modern code (dbt models, PySpark jobs, Airflow DAGs)
- Migration mapping (source → target)
- Data validation queries to compare old vs new output
- Rollback strategy documentation
Agent Delegation
| Agent | Role |
|---|---|
dbt-specialist |
Primary — stored proc → dbt model conversion |
spark-engineer |
Primary — heavy ETL → PySpark conversion |
pipeline-architect |
Escalation — orchestration migration |
sql-optimizer |
Escalation — query optimization during migration |
KB Domains Used
dbt— model patterns, incremental strategies, macrosspark— PySpark patterns, DataFrame transformationsairflow— DAG patterns, operator selectionsql-patterns— cross-dialect SQL translation
Output
The agent generates modern code equivalents, a migration checklist, and validation queries to ensure data parity.
