gh-cli-pr-stats

Computing pull request statistics (merge time, top contributors) from gh CLI JSON output using jq.

SKILL.md

GitHub

PR Statistics from gh CLI Output

Fetching PR Data with Timestamps

gh pr list --repo owner/repo --state all \
  --search "created:2024-12-01..2024-12-31" \
  --limit 500 \
  --json number,state,author,createdAt,mergedAt

The author field returns an object: {"login": "username"}. The state field returns: OPEN, CLOSED, or MERGED.

Computing Average Merge Time with jq

# Filter merged PRs and compute average days to merge
echo "$pr_json" | jq '
  [.[] | select(.state == "MERGED") |
    { created: (.createdAt | fromdateiso8601),
      merged: (.mergedAt | fromdateiso8601) } |
    (.merged - .created) / 86400
  ] | add / length
'
  • fromdateiso8601 converts ISO 8601 strings to Unix epoch seconds.
  • Divide difference by 86400 to get days.
  • add / length computes the mean.

Finding Top Contributor

echo "$pr_json" | jq '
  group_by(.author.login) |
  map({login: .[0].author.login, count: length}) |
  sort_by(-.count) |
  .[0]
'

Counting by State

echo "$pr_json" | jq '{
  total: length,
  merged: [.[] | select(.state == "MERGED")] | length,
  closed: [.[] | select(.state == "CLOSED")] | length
}'

Note: In gh CLI output, CLOSED and MERGED are distinct states. A merged PR has state MERGED, not CLOSED.