bacoco/useless-report/ingest-from-github

ingest-from-github

Goal

Pull structured PR and issue activity from GitHub for the current repository, complementing what ingest-from-git provides from local git history. This adds the human layer: review state, comments, linked issues, and merge timing.

Prerequisites

The gh CLI must be installed and authenticated. Verify first:

gh auth status

If unauthenticated or missing, return: "gh CLI not available or not authenticated. Run `gh auth login`, or skip GitHub ingestion and rely on git-only data."

How to use

Step 1 — Confirm the period

Default: last 7 days. Match whatever was used for ingest-from-git if running both.

Step 2 — Fetch PRs

# All PRs touched in the period (created, updated, or closed)
gh pr list --state all --search "updated:>=<YYYY-MM-DD>" \
  --json number,title,author,state,createdAt,closedAt,mergedAt,labels,reviews,additions,deletions,baseRefName,url \
  --limit 100
 
# Recently merged PRs specifically
gh pr list --state merged --search "merged:>=<YYYY-MM-DD>" \
  --json number,title,author,mergedAt,additions,deletions,labels,url \
  --limit 50
 
# Open PRs requiring attention
gh pr list --state open \
  --json number,title,author,reviewDecision,isDraft,createdAt,url \
  --limit 50

Step 3 — Fetch issues

# Issues touched in the period
gh issue list --state all --search "updated:>=<YYYY-MM-DD>" \
  --json number,title,state,labels,createdAt,closedAt,url \
  --limit 50

Step 4 — Extract structured facts

• Merged PRs: list with title, author, merge date, +/- lines, labels
• Open PRs: title, author, review state (APPROVED, REVIEW_REQUIRED, CHANGES_REQUESTED), is-draft
• Closed without merge: PRs that were rejected or abandoned
• Issues closed: bug fixes, features, chores
• Issues opened: new work surfaced in the period
• Review activity: PRs that received reviews this period
• Linked work: PRs that reference issues (look for #NNN in titles or bodies)

Step 5 — Output

## GitHub Activity Summary — [start] to [end]
 
**Repo:** [owner/name]
**PRs merged:** N
**PRs still open:** N
**Issues closed:** N
**Issues opened:** N
 
### Merged this period
-#N "[title]" by @author — merged [date], +X/-Y lines [labels]
-...
 
### Open PRs needing attention
-#N "[title]" by @author — [review state], [age]
-...
 
### Closed without merge
-#N "[title]" — closed [date], reason: [if available]
 
### Issues closed
-#N "[title]" — [labels]
-...
 
### Issues opened
-#N "[title]" — [labels]
-...
 
### Notable review activity
-#N "[title]" — N reviews, [last reviewer]
-...

Rules

• Never invent PR numbers or titles. Only report what gh returns.
• Combine cleanly with ingest-from-git output — the downstream generate-* skill receives both as one fact base.
• Handle rate limits gracefully: if gh returns a rate-limit error, report what was fetched and note the truncation.
• Skip empty sections — if no issues were closed, don't write "Issues closed: (none)" repeatedly. Just omit the section.
• Don't include reviewer names unless explicitly asked — keeps the output safer to share.

Pipeline position

ingest-from-git + ingest-from-github
                 ↓
        [classify-manager-style]
                 ↓
              generate-X-report
                 ↓
        [format-as-html | format-as-slides]