Skills

Skill 16 of 54

GitHub PR Query

Query GitHub pull requests with jq filtering and reusable selectors.

1 minute · 244 words · 11 sections

Install

$ npx skills add github/gh-aw --skill github-pr-query

$ npx skills add github/gh-aw

The first command installs just this skill, by the name in its SKILL.md; the second installs the whole repository.

GitHub Pull Request Query Skill

Query GitHub pull requests efficiently with built-in jq filtering.

Important: jq Parameter is Optional

The --jq parameter is optional. Without --jq, this skill returns schema and data size information instead of full data. Use this to avoid oversized responses and inspect structure before targeted queries.

Use --jq '.' to get all data, or use a more specific filter for targeted results.

Usage

Use this skill to query pull requests from the current repository or any specified repository.

Basic Query (Returns Schema Only)

To list pull requests from the current repository:

./query-prs.sh
# Returns schema and data size, not full data

Get All Data

To get all PR data:

./query-prs.sh --jq '.'

With Repository

To query a specific repository:

./query-prs.sh --repo owner/repo

With jq Filtering

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})'

Common Options

--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
--author: Filter PRs by author login
--app: Filter PRs by GitHub App author
--search: Apply GitHub issue/PR search syntax
--jq: (Optional) jq expression for filtering/transforming output. If omitted, returns schema info

Example Queries

Find 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}'

Get PRs authored by GitHub Actions app activity context:

./query-prs.sh --app github-actions --jq '.[] | {number, title, author: .author.login}'

Find in-scope review feedback (team/collaborator + trusted automation):

# Trusted automation is matched by login; humans are matched by association.
./query-prs.sh --jq \
  '.[] | {number, title, reviews: [.reviews[]? | select(.author.login == "github-actions[bot]" or .author.login == "app/github-copilot" or .authorAssociation == "MEMBER" or .authorAssociation == "OWNER" or .authorAssociation == "COLLABORATOR")] }'

Ignore external review feedback:

./query-prs.sh --jq \
  '.[] | {number, title, external_reviews: [.reviews[]? | select(.authorAssociation == "CONTRIBUTOR" or .authorAssociation == "FIRST_TIME_CONTRIBUTOR" or .authorAssociation == "FIRST_TIMER" or .authorAssociation == "NONE")] }'

List PRs with their labels:

./query-prs.sh --jq '.[] | {number, title, labels: [.labels[].name]}'

Output Format

The script outputs JSON by default, making it easy to pipe through jq for additional processing.

Requirements

GitHub CLI (gh) authenticated
jq for filtering (installed by default on most systems)

Colophon for this issue

Colophon

How this issue was made

Source

github.com/github/gh-aw, branch main, last pushed 23 September 2026.

Licence

MIT — the text of every skill is reproduced unmodified, frontmatter included, under the upstream licence.

Discovery

54 skills found by walking the repository tree for SKILL.md, not by matching a directory convention. 4 distinct layouts observed: .claude/skills/*/SKILL.md, .github/skills/*/SKILL.md, .squad/*/skill.md, SKILL.md (repo root).

Authorship

27 of 54 skills are installed into the repository rather than published from it. They are shelved in the closing “Credited skills” part and remain the work of their own authors. A skill counts as credited when its only copy lives under one agent’s dot directory; visible directories, per-agent mirror sets, and skills installable from this repository on skills.sh all count as published.

Issue colours

Resolved from a curated brand profile — hue 295°, chroma 0.190. Two accent tones are generated per issue and each is proven against its own ground before it ships: a single accent that passes AA on both light and dark paper is arithmetically impossible.

Heading repairs

1 repair applied to this skill so the document has one h1 and no skipped levels:

Shifted “11 headings” from h1 to h2 so the skill title is the only h1.

Spec compliance

4 editorial notes across 3 of 54 skills. They are printed in the margin of each skill rather than as errors here.

Images

Images inside a skill come from the upstream repository. Where the author gave no alternative text we mark the image decorative rather than inventing a description — a plausible caption we made up is worse than none for the reader who depends on it.

Signal

Install counts come from skills.sh. They measure downloads, not quality, and an unranked repository is not an unread one.

Agent surfaces

The whole issue is available as one markdown document at /github/gh-aw.md, and each skill at its own .md URL.

Publication

Set by Skills Docs from the source repository. Body text is Literata at the reader’s chosen size and measure; code is Geist Mono. Nothing on this page was written by us except this paragraph.

./query-prs.sh
# Returns schema and data size, not full data

Get All Data

To get all PR data:

./query-prs.sh --jq '.'

With Repository

To query a specific repository:

./query-prs.sh --repo owner/repo

With jq Filtering

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})'

Common Options

--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
--author: Filter PRs by author login
--app: Filter PRs by GitHub App author
--search: Apply GitHub issue/PR search syntax
--jq: (Optional) jq expression for filtering/transforming output. If omitted, returns schema info

Example Queries

Find 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}'

Get PRs authored by GitHub Actions app activity context:

./query-prs.sh --app github-actions --jq '.[] | {number, title, author: .author.login}'

Find in-scope review feedback (team/collaborator + trusted automation):

# Trusted automation is matched by login; humans are matched by association.
./query-prs.sh --jq \
  '.[] | {number, title, reviews: [.reviews[]? | select(.author.login == "github-actions[bot]" or .author.login == "app/github-copilot" or .authorAssociation == "MEMBER" or .authorAssociation == "OWNER" or .authorAssociation == "COLLABORATOR")] }'

Ignore external review feedback:

./query-prs.sh --jq \
  '.[] | {number, title, external_reviews: [.reviews[]? | select(.authorAssociation == "CONTRIBUTOR" or .authorAssociation == "FIRST_TIME_CONTRIBUTOR" or .authorAssociation == "FIRST_TIMER" or .authorAssociation == "NONE")] }'

List PRs with their labels:

./query-prs.sh --jq '.[] | {number, title, labels: [.labels[].name]}'

Output Format

The script outputs JSON by default, making it easy to pipe through jq for additional processing.

Requirements

GitHub CLI (gh) authenticated
jq for filtering (installed by default on most systems)

GitHub PR Query

GitHub Pull Request Query Skill

Important: jq Parameter is Optional

Usage

Basic Query (Returns Schema Only)

Get All Data

With Repository

With jq Filtering

Common Options

Example Queries

Output Format

Requirements

Colophon

GitHub PR Query

GitHub Pull Request Query Skill

Important: jq Parameter is Optional

Usage

Basic Query (Returns Schema Only)

Get All Data

With Repository

With jq Filtering

Common Options

Example Queries

Output Format

Requirements

Appendix 16.1

Also bundledShell · 1 file

Colophon

Appendix 16.1

Also bundledShell · 1 file