Stats
Actions
Tags
Help us improve
Share bugs, ideas, or general feedback.
From agentspec
Analyzes legacy ETL (stored procedures, SSIS, Informatica) and produces modern dbt models, PySpark jobs, Airflow DAGs, migration mappings, and validation queries.
npx claudepluginhub luanmorenommaciel/agentspec --plugin agentspecHow 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...
/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-databaseInteractively assess, plan, execute, and verify database migrations between PostgreSQL, MySQL, SQLite, and SQL Server with read-only source audits and confirmations.
/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.
/migrateReviews pending EF Core model changes, generates descriptive migration, reviews SQL for safety risks, and applies with rollback readiness.
/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.
Share bugs, ideas, or general feedback.
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.