Menu
Review a pull request and rate it /10 on bugs, security, improvements, technical quality, and consistency with adjacent code.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Generate YAML schema and documentation for dbt models, ensuring alignment with best practices and automated testing.
Migrate Airflow DAGs from GCE (SSHGCEOperator) to GKE (CustomKubernetesPodOperator). Use when the user wants to migrate a DAG from VM-based to Kubernetes-based execution, replace SSHGCEOperator with CustomKubernetesPodOperator, convert GCE tasks to KPO tasks, or mentions GCE-to-GKE migration. Also trigger when they mention removing StartGCEOperator, DeleteGCEOperator, InstallDependenciesOperator in favor of pod-based execution.
Create pull requests that follow data team standards with proper naming conventions, commit validation, and squash-and-merge workflow. Use this skill when the user wants to create a PR, mentions pull requests, needs help with commit naming, wants to clean up commits before review, or talks about submitting work for review. Also trigger when they mention tickets like DE-XXX, HF-XXX, or BSR, or when they're working with dbt, bq_jobs, ml_jobs, or analytics code and need to get their changes reviewed.
Fix Python package vulnerabilities for a single uv.lock file by updating pyproject.toml and tool.uv constraint-dependencies, then regenerating the lockfile.
| name | pr-review |
| description | Review a pull request and rate it /10 on bugs, security, improvements, technical quality, and consistency with adjacent code. |
MAIN=$(git remote show origin | sed -n '/HEAD branch/s/.*: //p')git fetch origin "$MAIN"git --no-pager diff "origin/$MAIN...HEAD"pyproject.toml, uv.lock, requirements.txt), use the validate_cves tool.Hints below are additional focus areas — use your own judgment to evaluate thoroughly.
## PR Review — <PR title>
| Criteria | Status | Comments |
|--------------------|--------|----------|
| Bugs | 🟢/🟡/🟠/🔴 | |
| Security | 🟢/🟡/🟠/🔴 | |
| Tests & Reliability| 🟢/🟡/🟠/🔴 | |
| Improvements | 🟢/🟡/🟠/🔴 | |
| Technical Quality | 🟢/🟡/🟠/🔴 | |
| Consistency | 🟢/🟡/🟠/🔴 | |
**Overall: X/10**
### 🔴 Blockers
### 🟠 Important
### 🟡 Minor
### 👍 What's Done Well
### Suggestions