Stats
Actions
Tags
'%20stop-opacity%3D'0.16'%2F%3E%3Cstop%20offset%3D'1'%20stop-color%3D'rgb(200%2C90%2C60)'%20stop-opacity%3D'0.03'%2F%3E%3C%2FlinearGradient%3E%3C%2Fdefs%3E%3Crect%20width%3D'320'%20height%3D'200'%20fill%3D'url(%23g)'%2F%3E%3Ccircle%20cx%3D'250'%20cy%3D'56'%20r%3D'92'%20fill%3D'rgb(200%2C90%2C60)'%20fill-opacity%3D'0.06'%2F%3E%3Ccircle%20cx%3D'64'%20cy%3D'172'%20r%3D'58'%20fill%3D'rgb(200%2C90%2C60)'%20fill-opacity%3D'0.05'%2F%3E%3C%2Fsvg%3E)
From agentspec
Analyzes legacy ETL (stored procedures, SSIS, Informatica) and produces modern dbt models, PySpark jobs, Airflow DAGs, migration mappings, and validation queries.
How this command is triggered — by the user, by Claude, or both
Slash command
/agentspec:migratedata-engineering/The summary Claude sees in its command listing — used to decide when to auto-load this command
# Migrate Command > Migrate legacy ETL (stored procedures, SSIS, Informatica) to modern stack ## Usage ## Examples --- ## What This Command Does 1. Analyzes legacy ETL code or description 2. Invokes the appropriate agent based on target stack 3. Loads KB patterns from `dbt`, `spark`, and `airflow` domains 4. 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 | |-------|------| | `db...
Migrate legacy ETL (stored procedures, SSIS, Informatica) to modern stack
/migrate <description-or-file>
/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"
dbt, spark, and airflow domains| 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 |
dbt — model patterns, incremental strategies, macrosspark — PySpark patterns, DataFrame transformationsairflow — DAG patterns, operator selectionsql-patterns — cross-dialect SQL translationThe agent generates modern code equivalents, a migration checklist, and validation queries to ensure data parity.
npx claudepluginhub luanmorenommaciel/agentspec --plugin agentspec/pipelineDesigns, implements, tests, and debugs data pipelines and ETL with quality validation, schema contracts, observability, and error handling. Supports Airflow, dbt, Dagster, Prefect.
/etlDesigns and implements ETL/ELT data pipelines based on a required requirement and optional pattern like batch or streaming.
/fire-migrate-databaseGuides database migration between PostgreSQL, MySQL, SQLite, and SQL Server through a structured 6-step pipeline: assess, plan, execute, verify.
/migrateAlias for /portaljs-migrate that will be removed next minor release. Invoke /portaljs-migrate instead.
/migratePlans and executes incremental framework or library migrations: audits dependencies, analyzes breaking changes, creates ordered plan, executes module-by-module, verifies with tests and performance checks.
/migrateMigrate ADVPL procedural .prw code to TLPP object-oriented .tlpp code with classes, namespaces, and modern patterns. Analyzes structure, shows detailed plan requiring approval, then generates files and optional wrapper.