Implement automated project archival workflow

[ashleyshaw]

Summary

Projects in .github/projects/active/ must be manually moved to archived/ when complete. This is error-prone and creates inconsistency in project metadata.

Problem

• No automation to detect and archive completed projects
• Manual process is ad-hoc and unmaintained
• Risk: completed project metadata lost or inconsistently tracked
• No archival summary or historical record

Solution

Create new project-archival.yml workflow that:

1. Triggers on-demand (workflow_dispatch) or on schedule (weekly)
2. Scans active projects for completion markers:
   • Project status: completed
   • All associated issues: closed
   • All associated PRs: merged or closed
3. Moves completed project to .github/projects/archived/{YYYY-MM-DD}-{project-name}/
4. Creates archival summary including:
   • Completion date & duration
   • Final metrics (issues opened/closed, PRs merged)
   • Project outcomes
5. Commits archival record with clear git history

Implementation Details

• Effort: 3–4 hours
• Complexity: Medium
• Risk: Low (with dry-run mode and audit trail)
• Related: Project metadata structure (.github/projects/)
• Dependencies: Project schema validation, GitHub API integration

Acceptance Criteria

• Workflow created and tested in dry-run mode
• Completed projects correctly identified and moved
• Archival summary generated with metrics
• Original project metadata preserved in archive
• Workflow logs all actions for audit trail
• All tests pass; no data loss

Reference

See workflow standards audit: .github/reports/audits/workflow-standards-audit-2026-05-31.md

[linear-code]

LS-807