Query GitHub pull requests efficiently with jq argument support for filtering
This skill provides efficient querying of GitHub pull requests with built-in jq filtering support.
The --jq parameter is optional. When called without --jq, this skill returns schema and data size information instead of the full data.
This prevents overwhelming responses with large datasets and helps you understand the data structure before querying.
Use --jq '.' to get all data, or use a more specific filter for targeted results.
Use this skill to query pull requests from the current repository or any specified repository.
To list pull requests from the current repository:
./query-prs.sh
# Returns schema and data size, not full data
To get all PR data:
./query-prs.sh --jq '.'
To query a specific repository:
./query-prs.sh --repo owner/repo
Use the --jq argument to filter and transform the output:
# Get only open PRs
./query-prs.sh --jq '.[] | select(.state == "open")'
# Get PR numbers and titles
./query-prs.sh --jq '.[] | {number, title}'
# Get PRs by a specific author
./query-prs.sh --jq '.[] | select(.author.login == "username")'
# Get merged PRs from last week
./query-prs.sh --jq '.[] | select(.mergedAt != null)'
# Count PRs by state
./query-prs.sh --jq 'group_by(.state) | map({state: .[0].state, count: length})'
--state: Filter by state (open, closed, merged, all). Default: open--limit: Maximum number of PRs to fetch. Default: 30--repo: Repository in owner/repo format. Default: current repo--jq: (Optional) jq expression for filtering/transforming output. If omitted, returns schema infoFind large PRs (many changed files):
./query-prs.sh --jq '.[] | select(.changedFiles > 10) | {number, title, changedFiles}'
Get PRs awaiting review:
./query-prs.sh --jq '.[] | select(.reviewDecision == "REVIEW_REQUIRED") | {number, title, author: .author.login}'
List PRs with their labels:
./query-prs.sh --jq '.[] | {number, title, labels: [.labels[].name]}'
The script outputs JSON by default, making it easy to pipe through jq for additional processing.
gh) authenticatedjq for filtering (installed by default on most systems)