prcat

AI-powered PR reviewer — understand any pull request in seconds.

$ prcat https://github.com/django/django/pull/17842

PR #17842: Fix queryset annotation with complex expressions
django/django  feature/fix-annotation → main  +85/-12  6 file(s)

Verdict: Needs minor changes ⚠️

## Summary
This PR fixes a bug where annotating a queryset with complex F() expressions
containing subqueries would fail under certain database backends...

## Concerns
- [WARNING] src/db/models/sql/compiler.py L342
  The fallback path for non-standard backends isn't covered by tests.

## Questions for author
- Does this fix apply to GROUP BY queries with aggregates?

## Suggested review comment
The fix looks correct. I'd like to see a test for the SQLite fallback path
before merging. Otherwise LGTM.

Install

pip install prcat

Set an API key (or use Ollama for local, free review):

export ANTHROPIC_API_KEY=your-key     # Claude (default)
export OPENAI_API_KEY=your-key        # or OpenAI
# or use --provider ollama             # local, no API key needed

Authenticate with GitHub (required to fetch private PRs):

gh auth login   # uses gh CLI — recommended
# or: export GITHUB_TOKEN=your-token

Usage

# Review by PR number (auto-detects repo from git remote)
prcat 42

# Explicit repo
prcat owner/repo#42

# Full URL
prcat https://github.com/owner/repo/pull/42

# Review styles
prcat 42 --style summary    # just summarize the PR
prcat 42 --style risks      # focus on risks only
prcat 42 --style review     # full review (default)

# Use different AI providers
prcat 42 --provider openai
prcat 42 --provider ollama --model qwen2.5:7b

# Copy review to clipboard
prcat 42 --copy

# Save to file
prcat 42 --output review.md

# Compact mode (for CI / scripts)
prcat 42 --compact          # exits 1 if CRITICAL issues found

Options

Use in CI

Exit code 1 when the AI finds CRITICAL issues — perfect for CI gates:

# .github/workflows/pr-review.yml
- name: AI PR review
  run: prcat ${{ github.event.pull_request.number }} --compact
  env:
    ANTHROPIC_API_KEY: ${{ secrets.ANTHROPIC_API_KEY }}
    GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}

Developer workflow

prcat fills the missing piece in the git-workflow toolkit:

# Start the day
standup-ai                          # generate standup from git commits

# Before you push
critiq                              # review YOUR own changes before pushing

# When you submit a PR
gpr                                 # generate PR description + commit message

# When you review a teammate's PR  ← prcat fits here
prcat 42                            # AI-assisted review of their changes

# After merging
gitbrief --changed-only             # pack context for LLM
changelog-ai v1.0.0 v1.1.0         # generate CHANGELOG
chronicle repo                      # understand the story behind changes

Default models

Override with --model:

prcat 42 --provider claude --model claude-sonnet-4-5   # deeper review
prcat 42 --provider openai --model gpt-4o               # OpenAI GPT-4o
prcat 42 --provider ollama --model qwen2.5:7b           # larger local model

License

MIT — free for personal and commercial use.