| 1 | -- When each repository last had pull request, review, push, run or release activity |
| 2 | -- (agentic/today.ts). The Today view visits the recently active repositories first; |
| 3 | -- repos.pushed_at alone misses work done through the API and MCP. |
| 4 | CREATE TABLE repo_activity ( |
| 5 | repo_id TEXT PRIMARY KEY, |
| 6 | at TEXT NOT NULL |
| 7 | ); |
| 8 | CREATE INDEX repo_activity_at ON repo_activity(at); |