메뉴
Legacy ETL migration — delegates to de-dbt-specialist and de-spark-engineer agents. Use when converting stored procedures, SSIS packages, or Informatica workflows to modern stack.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Create a pull request with conventional commits and a structured description. Supports GitHub and Azure DevOps — platform is auto-detected from the git remote. Use when the user wants to open a PR, commit changes, or submit work for review.
Create a pull request with conventional commits and a structured description. Supports GitHub and Azure DevOps — platform is auto-detected from the git remote. Use when the user wants to open a PR, commit changes, or submit work for review.
Analyze meeting transcripts — extract decisions, action items, and create SSOT documents. Use when processing standup notes, stakeholder reviews, or sprint meetings.
Save valuable insights from the current session to storage. Use when you've discovered decisions, patterns, or gotchas worth remembering across sessions.
Generate comprehensive, production-ready README.md by analyzing codebase with explorer + documenter agents. Use when creating or updating project documentation.
Sync project context to copilot-instructions.md by analyzing codebase patterns and conventions. Use after adding agents, commands, or significant architecture changes.
| name | migrate |
| description | Legacy ETL migration — delegates to de-dbt-specialist and de-spark-engineer agents. Use when converting stored procedures, SSIS packages, or Informatica workflows to modern stack. |
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 |
|---|---|
de-dbt-specialist | Primary — stored proc → dbt model conversion |
de-spark-engineer | Primary — heavy ETL → PySpark conversion |
architect-pipeline | Escalation — orchestration migration |
de-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.