retro-prep

Sprint Retrospective Preparation

Automates collection of sprint metrics, trend analysis, and qualitative signals to prepare a comprehensive, data-driven retrospective document. Pulls velocity trends, PR metrics, bug data, blockers, and team sentiment signals.

Usage

/retro-prep [--sprint <sprint-id>] [--publish] [--raw]

• --sprint <id>: Specify sprint ID (auto-detects last completed sprint if omitted)
• --publish: Save formatted retro doc to Confluence
• --raw: Output raw JSON data instead of formatted document

Workflow

Phase 1: Sprint Selection

Identifies the most recently completed sprint or uses the specified sprint ID.

// Pseudo-implementation
const sprints = await jira.getSprintsFromBoard({
  boardId: detectBoardId(),
  state: "closed"
});

const targetSprint = sprints[0]; // Most recent
if (!targetSprint) {
  console.error("ERROR: No closed sprints found");
  return gracefulFailure("No completed sprints available");
}

console.log(`✓ Sprint: ${targetSprint.name} (${targetSprint.id})`);

Graceful degradation: If no sprints found, prompt user for board selection or exit cleanly.

---

Phase 2: Metrics Collection

Fetches quantitative sprint data: story points, ticket counts, cycle times, bug rates.

const sprintTickets = await jira.getIssuesByJQL({
  jql: `sprint = ${targetSprint.id}`
});

const metrics = {
  committed: 0,
  completed: 0,
  carryover: 0,
  completedPoints: 0,
  committedPoints: 0,
  bugsFiled: 0,
  bugsFixed: 0,
  avgCycleTime: 0,
  prCount: 0,
  avgMergeTime: 0,
  ticketsByType: { Story: 0, Bug: 0, Task: 0, Subtask: 0 }
};

for (const ticket of sprintTickets) {
  metrics.ticketsByType[ticket.issuetype.name]++;

  if (ticket.status === "Done") {
    metrics.completed++;
    metrics.completedPoints += ticket.customfield_storypoints || 0;
  } else {
    metrics.carryover++;
  }

  metrics.committedPoints += ticket.customfield_storypoints || 0;
  metrics.committed++;

  // Calculate cycle time (created → done)
  if (ticket.status === "Done") {
    const created = new Date(ticket.created);
    const resolved = new Date(ticket.resolutiondate);
    const cycleHours = (resolved - created) / (1000 * 60 * 60);
    metrics.avgCycleTime += cycleHours;
  }

  // Count bugs
  if (ticket.issuetype.name === "Bug") {
    if (ticket.status === "Done") metrics.bugsFixed++;
    else metrics.bugsFiled++;
  }
}

metrics.avgCycleTime = Math.round(metrics.avgCycleTime / metrics.completed);
metrics.completionRate = Math.round((metrics.completed / metrics.committed) * 100);
metrics.velocity = metrics.completedPoints;

console.log(`✓ Metrics collected: ${metrics.completed}/${metrics.committed} tickets, ${metrics.velocity}pt velocity`);