supabase
Handles the full Supabase workflow from schema changes to deployment, with built-in security guardrails that catch common traps like RLS...
pr-reviewer
Pull request review expertise with focus on context, quality gates, and team standards. Use when reviewing PRs, validating changes before merge, or generating PR descriptions. Works with gh CLI for GitHub integration.
Full skill instructions
Comprehensive pull request review skill that validates changes against project standards, runs quality gates, and provides structured feedback for merge decisions.
# Get PR details
gh pr view <PR_NUMBER> --json title,body,author,state,reviews,files,commits
# View the diff
gh pr diff <PR_NUMBER>
# Check CI status
gh pr checks <PR_NUMBER>
# Get commits
gh pr view <PR_NUMBER> --json commits
# List changed files
gh pr diff <PR_NUMBER> --name-only
Questions to answer:
cd /home/user/Autonomous-Assignment-Program-Manager/backend
# Fetch and checkout PR
git fetch origin pull/<PR_NUMBER>/head:pr-<PR_NUMBER>
git checkout pr-<PR_NUMBER>
# Run quality checks
pytest --tb=short -q
ruff check app/ tests/
black --check app/ tests/
mypy app/ --python-version 3.11
# Check test coverage
pytest --cov=app --cov-fail-under=70
| Gate | Pass | Block |
|---|---|---|
| Tests | All pass | Any failure |
| Linting | 0 errors | Any error |
| Types | 0 errors | Critical types missing |
| Security | No issues | Any vulnerability |
| Coverage | >= 70% | < 60% |
| Architecture | Follows patterns | Major violation |
Use GitHub's suggestion format for fixes:
```suggestion
def calculate_hours(assignments: list[Assignment]) -> float:
"""Calculate total hours from assignments."""
return sum(a.hours for a in assignments)
```
## Review Summary
**Decision:** APPROVE / REQUEST CHANGES / COMMENT
### What This PR Does
[One sentence summary]
### Quality Gate Results
| Gate | Status | Notes |
|------|--------|-------|
| Tests | :white_check_mark: | 47 passed |
| Linting | :white_check_mark: | 0 errors |
| Types | :white_check_mark: | 100% coverage |
| Security | :white_check_mark: | bandit clear |
| Coverage | :yellow_circle: | 72% (target 80%) |
### Changes Reviewed
- `app/services/new_feature.py` - New service implementation
- `tests/test_new_feature.py` - Test coverage
### Feedback
#### Required Changes (Blocking)
1. [file:line] - Description of issue
- Impact: [what could go wrong]
- Suggestion: [how to fix]
#### Suggestions (Non-blocking)
1. [file:line] - Description
- Recommendation: [improvement]
#### Questions
1. [Question about the approach]
### Testing Notes
Tested locally:
- [x] Unit tests pass
- [x] Integration tests pass
- [ ] Manual testing [describe if done]
### Merge Checklist
- [ ] All conversations resolved
- [ ] CI checks passing
- [ ] Required reviews obtained
- [ ] Documentation updated
When creating PRs:
## Summary
[1-3 bullet points describing the change]
## Motivation
[Why this change is needed]
## Changes
- [List key changes]
## Testing
- [How was this tested?]
## Test Plan
- [ ] Unit tests added
- [ ] Integration tests added
- [ ] Manual testing done
## Screenshots
[If applicable]
## Checklist
- [ ] Code follows project style
- [ ] Tests added/updated
- [ ] Documentation updated
- [ ] No breaking changes (or documented)
## Related Issues
Closes #[issue number]
# List open PRs
gh pr list
# View specific PR
gh pr view <number>
# Check PR status
gh pr checks <number>
# Review PR
gh pr review <number> --approve -b "Looks good!"
gh pr review <number> --request-changes -b "See comments"
gh pr review <number> --comment -b "Questions inline"
# Add comment
gh pr comment <number> --body "Comment text"
# Merge PR
gh pr merge <number> --squash --delete-branch
# Get PR diff
gh pr diff <number>
# Create PR
gh pr create --title "Title" --body "Description"
#!/bin/bash
# scripts/pr-review-prep.sh
PR_NUMBER=$1
# Fetch PR
git fetch origin pull/${PR_NUMBER}/head:pr-${PR_NUMBER}
git checkout pr-${PR_NUMBER}
# Run quality checks
echo "=== Running Tests ==="
pytest --tb=short -q
echo "=== Running Linting ==="
ruff check app/ tests/
echo "=== Running Type Check ==="
mypy app/ --python-version 3.11
echo "=== Coverage Report ==="
pytest --cov=app --cov-report=term-missing --cov-fail-under=70
echo "=== Security Scan ==="
bandit -r app/ -ll
echo "=== PR Review Prep Complete ==="
This new functionality needs test coverage.
**Files needing tests:**
- `app/services/new_service.py`
**Suggested test cases:**
1. Happy path - normal input
2. Edge case - empty input
3. Error case - invalid input
4. Integration - database operations
This violates the layered architecture pattern.
**Issue:** Business logic in route handler
**Current:**
```python
@router.post("/items")
async def create_item(data: ItemCreate, db: Session):
# Business logic here (violation)
if data.value > 100:
data.value = 100
item = Item(**data.dict())
db.add(item)
Should be:
# In service layer
async def create_item(db: Session, data: ItemCreate) -> Item:
if data.value > 100:
data.value = 100
item = Item(**data.dict())
db.add(item)
return item
# In route
@router.post("/items")
async def create_item_route(data: ItemCreate, db: Session):
return await create_item(db, data)
### Missing Type Hints
````markdown
Please add type hints to these functions:
```suggestion
async def get_schedule(
db: AsyncSession,
schedule_id: str
) -> Optional[Schedule]:
"""Retrieve a schedule by ID."""
...
## Lesson Learned: PR #442 (2025-12-26)
**What happened:** A fix changed a filter from one value to another, but the new value
was also incorrect because comments/docs said "outpatient" while code used "clinic".
**Prevention checklist for filter/constant changes:**
- [ ] Verify value against seed data (`scripts/seed_templates.py`)
- [ ] Check if comments describe different behavior than code implements
- [ ] Cross-reference with canonical data source (e.g., BLOCK_10_ROADMAP)
- [ ] Confirm the filter will actually find matching records
**Key insight:** Always ask "will this filter find what we expect?" and verify empirically.
## Escalation Rules
**Request human review when:**
1. Changes touch authentication/authorization
2. Database migrations involved
3. ACGME compliance logic affected
4. Breaking API changes
5. Complex business logic unclear
6. Performance-critical code
7. Third-party integration changes
8. **Filter/constant value changes** - verify against canonical data sources
**Can approve automatically:**
1. Documentation-only changes
2. Test additions (without code changes)
3. Dependency updates (minor versions)
4. Code formatting fixes
5. Comment improvements
## Integration with Other Skills
### With code-review
For detailed code analysis:
1. PR-reviewer handles workflow and gates
2. Code-review handles line-by-line analysis
3. Combine findings in final review
### With security-audit
For security-sensitive PRs:
1. Detect sensitive file changes
2. Trigger security-audit skill
3. Include security findings in review
### With automated-code-fixer
For simple fixes:
1. Suggest fixes inline
2. If accepted, automated-code-fixer applies
3. Re-run quality gates
4. Update PR status
## References
- `/review-pr` slash command
- `.github/PULL_REQUEST_TEMPLATE.md` (if exists)
- `docs/development/AI_RULES_OF_ENGAGEMENT.md` - PR workflow rules
Handles the full Supabase workflow from schema changes to deployment, with built-in security guardrails that catch common traps like RLS...
Comprehensive guides and best practices for Neon Serverless Postgres, covering setup, connection methods, authentication, and platform APIs.
Guide for setting up and using Firebase Authentication. Use this skill when the user's app requires user sign-in, user management, or secure data access using auth rules.
A skill to evaluate how secure Firestore security rules are. Use this when Firestore security rules are updated to ensure that the generated rules are extremely secure and robust.
Official skill for integrating Firebase AI Logic (Gemini API) into web applications. Covers setup, multimodal inference, structured output, and security.
Complete Better Auth server and client setup with database adapters, session management, plugins, and security configuration.
Deploy and manage projects on Vercel using token-based authentication. Use when working with Vercel CLI using access tokens rather than interactive login — e.g. "deploy to vercel", "set up vercel", "add environment variables to vercel".
Complete Cloudflare platform integration with decision trees for compute, storage, AI, networking, security, and infrastructure-as-code.
Run Azure compliance and security audits with azqr plus Key Vault expiration checks. Covers best-practice assessment, resource review, policy/compliance validation, and security posture checks. WHEN: compliance scan, security audit, BEFORE running azqr (compliance cli tool), Azure best practices, Key Vault expiration check, expired certificates, expiring secrets, orphaned resources, compliance assessment.
Send, read, and manage Gmail messages, drafts, labels, and account settings.
Comprehensive website auditing across 230+ rules in 21 categories including SEO, performance, security, and accessibility.
Shared authentication, CLI syntax, and output formatting patterns for gws Google Workspace commands.
Discover your celebrity doppelgänger with StarByFace!
GeoSpy: Pricing, Features, FAQs, and Alternatives for AI Teams
Detect AI-generated voices to protect against audio fraud.
Ensure Your Content's Originality with AI Plagiarism Checker
Upscale images by 400% without quality loss
Protect your social media from copyright disputes
Accurately Detect AI-Generated Content with TheChecker.AI
Chrome extension that detects and flags AI-generated content