repo-sprint

/repo-sprint

"What's open right now?" Pulls together the signals that matter at the start of a coding day so you can pick the next thing to work on.

Workflow

Run the following queries in parallel and synthesize. Use mcp__repoindex__run_sql for each.

1. Dirty working trees

SELECT name, path, language FROM repos
WHERE is_clean = 0
ORDER BY name

2. Unpushed commits

SELECT name, ahead, path FROM repos
WHERE ahead > 0
ORDER BY ahead DESC

3. Recent commit activity (last 3 days)

SELECT r.name, r.language, COUNT(*) AS commits, MAX(e.timestamp) AS last
FROM events e JOIN repos r ON e.repo_id = r.id
WHERE e.type = 'commit' AND e.timestamp > datetime('now', '-3 days')
GROUP BY r.id
ORDER BY last DESC
LIMIT 15

4. Release candidates

Repos that detected a registry package and have commits since the last release tag. Heuristic:

WITH last_tag AS (
  SELECT repo_id, MAX(timestamp) AS tagged FROM events
  WHERE type IN ('git_tag', 'release')
  GROUP BY repo_id
),
recent_commits AS (
  SELECT repo_id, COUNT(*) AS n, MAX(timestamp) AS last_commit
  FROM events
  WHERE type = 'commit' AND timestamp > datetime('now', '-30 days')
  GROUP BY repo_id
)
SELECT r.name, p.registry, p.current_version,
       rc.n AS commits_30d, lt.tagged AS last_release
FROM repos r
JOIN publications p ON p.repo_id = r.id AND p.published = 1
JOIN recent_commits rc ON rc.repo_id = r.id
LEFT JOIN last_tag lt ON lt.repo_id = r.id
WHERE (lt.tagged IS NULL OR rc.last_commit > lt.tagged)
ORDER BY rc.n DESC
LIMIT 10

5. Recently active repos with open quality gaps

WITH recent AS (
  SELECT DISTINCT repo_id FROM events
  WHERE type = 'commit' AND timestamp > datetime('now', '-14 days')
)
SELECT r.name, r.language,
       (CASE WHEN r.has_license = 0 THEN 1 ELSE 0 END) +
       (CASE WHEN r.has_readme  = 0 THEN 1 ELSE 0 END) +
       (CASE WHEN r.has_ci      = 0 THEN 1 ELSE 0 END) AS gaps
FROM repos r
JOIN recent rc ON rc.repo_id = r.id
WHERE COALESCE(r.is_archived, 0) = 0
  AND (r.has_license = 0 OR r.has_readme = 0 OR r.has_ci = 0)
ORDER BY gaps DESC
LIMIT 10