メニュー
SQL-specific code review — delegates to de-sql-optimizer + python-code- reviewer agents. Use when reviewing SQL for anti-patterns, performance issues, or cross-dialect correctness.
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 | sql-review |
| description | SQL-specific code review — delegates to de-sql-optimizer + python-code- reviewer agents. Use when reviewing SQL for anti-patterns, performance issues, or cross-dialect correctness. |
Review SQL code for anti-patterns, performance, and cross-dialect correctness
/sql-review <file-or-directory>
/sql-review models/marts/mart_revenue.sql
/sql-review models/staging/
/sql-review "Review all SQL in this PR for Snowflake compatibility"
sql-patterns, data-quality, and dbt domainsSELECT *, implicit coercion, missing partition filters)| Agent | Role |
|---|---|
python-code-reviewer | Primary — DE review capability (anti-patterns, PII, tests) |
de-sql-optimizer | Escalation — query plan analysis, window functions |
de-dbt-specialist | Escalation — dbt-specific patterns and macros |
sql-patterns — SQL anti-patterns, window functions, CTEsdata-quality — quality checks, PII detectiondbt — model patterns, testing conventionsA structured review report with severity-classified issues and fix suggestions.