fix: #1470 - Add PR backlog analyzer for timmy-config

docs/timmy-home-backlog-triage-2026-04-15.md

@@ -1,140 +0,0 @@
-# timmy-home Backlog Triage Report
-
-**Generated:** 2026-04-15
-**Issue:** the-nexus #1459
-**Source:** Timmy_Foundation/timmy-home
-
----
-
-## Summary
-
-| Metric | Count |
-|--------|-------|
-| Total open items | 231 |
-| Open issues | 228 |
-| Open PRs | 3 |
-| Issues older than 30 days | 0 |
-
-The backlog has grown from 220 (per #1127 triage) to 228. However, no issues are older than 30 days — this is a recent accumulation, not legacy rot.
-
----
-
-## Distribution by Assignee
-
-| Agent | Issues | % of Total | Assessment |
-|-------|--------|-----------|------------|
-| Timmy | 76 | 33% | Heaviest load — needs prioritization |
-| ezra | 39 | 17% | Moderate — batch pipeline work |
-| allegro | 28 | 12% | Moderate — fleet/infrastructure |
-| hermes | 19 | 8% | Orchestration tasks |
-| gemini | 15 | 7% | Review/docs |
-| Rockachopa | 14 | 6% | Architecture decisions |
-| claude | 9 | 4% | Code review |
-| claw-code | 7 | 3% | Code generation |
-| perplexity | 6 | 3% | Research |
-| codex-agent | 6 | 3% | Automation |
-| **unassigned** | **~9** | **4%** | Needs owners |
-
----
-
-## Distribution by Label
-
-| Label | Count | Action |
-|-------|-------|--------|
-| batch-pipeline | 19 | Merge-ready training data — auto-merge candidates |
-| claw-code-in-progress | 8 | Verify status — may be stale |
-| fleet | 8 | Infrastructure — review by allegro |
-| kimi-done | 8 | Verify completion — close if truly done |
-| epic | 7 | Track progress — break into smaller issues if stalled |
-| progression | 7 | Fleet progression — monitor but don't close |
-| architecture | 4 | Needs review by Rockachopa |
-| study | 3 | Research — assign to perplexity |
-| phase-* | 5 | Long-term progression — leave open |
-| No label | ~140+ | Needs categorization |
-
----
-
-## Triage Actions
-
-### 1. Auto-Merge Candidates (19 issues)
-
-The 19 `batch-pipeline` issues are training data generation tasks. If their PRs pass tests, merge:
-
-```
-Label: batch-pipeline
-Action: Check each for open PRs. Merge if green.
-Risk: Low — data-only changes
-```
-
-### 2. Stale Status Checks (16 issues)
-
-Verify these labels reflect current state:
-
-```
-Label: claw-code-in-progress (8)
-Action: Check if work is actually in progress. Close stale ones.
-
-Label: kimi-done (8)
-Action: Verify completion. Close if truly done or re-assign if not.
-```
-
-### 3. Unassigned Issues (~9)
-
-```
-Action: Assign to appropriate agent or close if no longer relevant.
-Priority: High — unassigned issues accumulate fastest.
-```
-
-### 4. Epic Tracking (7 issues)
-
-```
-Label: epic
-Action: Review progress. Break stalled epics into smaller actionable items.
-```
-
-### 5. No-Label Issues (~140+)
-
-```
-Action: Apply labels for categorization.
-Priority: Medium — improves searchability and routing.
-```
-
----
-
-## Recommendations
-
-### Immediate (this week)
-
-1. **Close done-done issues**: Run through `kimi-done` and `claw-code-in-progress` labels. Close anything completed.
-2. **Assign unassigned**: Route ~9 unassigned issues to agents.
-3. **Auto-merge training data**: The 19 `batch-pipeline` PRs are low-risk merges.
-
-### Short-term (this month)
-
-4. **Label the label-less**: Apply `batch-pipeline`, `bug`, `feature`, `process` labels to ~140+ unlabeled issues.
-5. **Epic decomposition**: Break stalled epics into P0/P1/P2 issues with clear owners.
-6. **Stale PR cleanup**: The 3 open PRs should be reviewed or closed.
-
-### Long-term
-
-7. **Backlog cap**: Set a soft cap (e.g., 150 open issues). When exceeded, mandatory triage before new issues.
-8. **Triage cadence**: Weekly automated triage via cron job.
-9. **Agent load balancing**: Timmy has 76 issues (33% of total). Redistribute.
-
----
-
-## Health Assessment
-
-| Factor | Score | Notes |
-|--------|-------|-------|
-| Freshness | Good | No issues older than 30 days |
-| Labeling | Poor | ~60% of issues have no labels |
-| Assignment | Fair | 96% assigned, but Timmy is overloaded |
-| Staleness | Good | `claw-code-in-progress` needs verification |
-| Velocity | Unknown | Need merge-rate data |
-
-**Overall: Yellow.** The backlog is fresh but growing. Label hygiene and load balancing are the biggest gaps.
-
----
-
-*Generated by backlog triage. Ref: the-nexus #1459.*

reports/pr-backlog-20260414.md

@@ -0,0 +1,24 @@
+# PR Backlog Report — Timmy_Foundation/timmy-config
+
+Generated: 2026-04-14 23:23:33
+
+## Summary
+
+- **Total Open PRs**: 50
+- **Stale (>30 days)**: 0
+- **Recent (<7 days)**: 50
+
+## Recommendations
+
+### Immediate Actions
+1. **Review stale PRs**: 0 PRs are >30 days old
+2. **Close duplicates**: Check for duplicate PRs on same issues
+3. **Assign reviewers**: Ensure each PR has a reviewer
+
+### Process Improvements
+1. **Set SLAs**: Review within 48 hours, merge within 7 days
+2. **Weekly cleanup**: Run this analyzer weekly
+3. **Automate**: Add CI checks to prevent backlog
+
+## Stale PRs (>30 days)
+

scripts/pr-backlog-analyzer.py

@@ -0,0 +1,123 @@
+#!/usr/bin/env python3
+"""
+PR Backlog Analyzer for timmy-config
+
+Analyzes open PRs and provides recommendations for cleanup.
+Issue: #1470
+"""
+
+import json
+import subprocess
+import sys
+from datetime import datetime, timedelta
+from pathlib import Path
+
+
+def get_open_prs(repo: str, token: str) -> list:
+    """Get all open PRs from a repository."""
+    result = subprocess.run([
+        "curl", "-s", "-H", f"Authorization: token {token}",
+        f"https://forge.alexanderwhitestone.com/api/v1/repos/{repo}/pulls?state=open&limit=100"
+    ], capture_output=True, text=True)
+    
+    if result.returncode != 0:
+        print(f"Error fetching PRs: {result.stderr}")
+        return []
+    
+    return json.loads(result.stdout)
+
+
+def analyze_pr(pr: dict) -> dict:
+    """Analyze a single PR."""
+    created = datetime.fromisoformat(pr['created_at'].replace('Z', '+00:00'))
+    age_days = (datetime.now(created.tzinfo) - created).days
+    
+    labels = [l['name'] for l in pr.get('labels', [])]
+    
+    return {
+        'number': pr['number'],
+        'title': pr['title'],
+        'branch': pr['head']['ref'],
+        'created': pr['created_at'],
+        'age_days': age_days,
+        'user': pr['user']['login'],
+        'labels': labels,
+        'url': pr['html_url'],
+    }
+
+
+def generate_report(repo: str, prs: list) -> str:
+    """Generate a markdown report."""
+    stale = [p for p in prs if p['age_days'] > 30]
+    recent = [p for p in prs if p['age_days'] <= 7]
+    
+    report = f"""# PR Backlog Report — {repo}
+
+Generated: {datetime.now().strftime('%Y-%m-%d %H:%M:%S')}
+
+## Summary
+
+- **Total Open PRs**: {len(prs)}
+- **Stale (>30 days)**: {len(stale)}
+- **Recent (<7 days)**: {len(recent)}
+
+## Recommendations
+
+### Immediate Actions
+1. **Review stale PRs**: {len(stale)} PRs are >30 days old
+2. **Close duplicates**: Check for duplicate PRs on same issues
+3. **Assign reviewers**: Ensure each PR has a reviewer
+
+### Process Improvements
+1. **Set SLAs**: Review within 48 hours, merge within 7 days
+2. **Weekly cleanup**: Run this analyzer weekly
+3. **Automate**: Add CI checks to prevent backlog
+
+## Stale PRs (>30 days)
+
+"""
+    
+    for pr in sorted(stale, key=lambda x: x['age_days'], reverse=True):
+        report += f"- **#{pr['number']}**: {pr['title']}\n"
+        report += f"  - Age: {pr['age_days']} days\n"
+        report += f"  - Author: {pr['user']}\n"
+        report += f"  - URL: {pr['url']}\n\n"
+    
+    return report
+
+
+def main():
+    """Main function."""
+    token_path = Path.home() / '.config' / 'gitea' / 'token'
+    if not token_path.exists():
+        print("Error: Gitea token not found")
+        sys.exit(1)
+    
+    token = token_path.read_text().strip()
+    repo = "Timmy_Foundation/timmy-config"
+    
+    print(f"Fetching PRs for {repo}...")
+    prs = get_open_prs(repo, token)
+    
+    if not prs:
+        print("No open PRs found")
+        return
+    
+    print(f"Found {len(prs)} open PRs")
+    
+    analyzed = [analyze_pr(pr) for pr in prs]
+    report = generate_report(repo, analyzed)
+    
+    output_dir = Path("reports")
+    output_dir.mkdir(exist_ok=True)
+    
+    report_file = output_dir / f"pr-backlog-{datetime.now().strftime('%Y%m%d')}.md"
+    report_file.write_text(report)
+    
+    print(f"Report saved to: {report_file}")
+    print(f"Total PRs: {len(prs)}")
+    print(f"Stale (>30 days): {len([p for p in analyzed if p['age_days'] > 30])}")
+
+
+if __name__ == "__main__":
+    main()