Codebase Insights Skill
Generate activity summaries revealing what's happening in a codebase day-to-day and week-to-week.
Data Sources
| Source | Tool | Data |
|---|---|---|
| Azure PRs | az repos pr list |
PRs opened, merged, reviewed |
| Azure Work Items | az boards query |
Tickets started, completed, in progress |
| Local Git | git log |
Commits in current repo |
| Confluence | Atlassian MCP | Recently modified pages |
Workflow
1. Collect Data
Run collectors from the current repository directory:
# Azure PRs (last N days)
node ${CLAUDE_SKILL_DIR}/collectors/azure-prs.js --days 7
# Azure work items (last N days)
node ${CLAUDE_SKILL_DIR}/collectors/azure-workitems.js --days 7
# Local git commits (last N days)
node ${CLAUDE_SKILL_DIR}/collectors/git-commits.js --days 7
Confluence: Search for recent pages using Atlassian MCP:
mcp__atlassian__rovo_search(query: "modified:>YYYY-MM-DD space_key")
Extract and save to .insights/raw/confluence.json:
[
{
"id": "12345",
"title": "Page Title",
"space": "SPACE",
"lastModified": "2025-01-08",
"lastModifiedBy": "Author Name",
"url": "https://..."
}
]
Data saved to .insights/raw/.
2. Filter by Period
# For daily summary
node ${CLAUDE_SKILL_DIR}/collectors/filter-by-date.js .insights/raw/commits.json --day 2025-01-08
# For weekly summary
node ${CLAUDE_SKILL_DIR}/collectors/filter-by-date.js .insights/raw/commits.json --week 2025-01-08
3. Generate Summary
Use templates from ${CLAUDE_SKILL_DIR}/templates/:
daily-summary.md- Daily activity reportweekly-summary.md- Weekly activity report
4. Save Output
Reports saved to .insights/:
- Daily:
.insights/YYYY-MM-DD-insights.md - Weekly:
.insights/YYYY-WXX-insights.md
Commands
| Command | Description |
|---|---|
/df:insights:daily [date] |
Generate daily codebase summary |
/df:insights:weekly [date] |
Generate weekly codebase summary |
/df:insights:catchup |
Download raw data since last collection |
Monthly Review
For monthly reviews, use the significance-based formatter:
node ${CLAUDE_SKILL_DIR}/collectors/format-review.mjs --month YYYY-MM
Or follow the templates/monthly-review.md template for AI-generated analysis focusing on:
- High-impact initiatives grouped by theme
- Effort estimation (HIGH/MEDIUM/LOW)
- Status tracking (Shipped/In Progress/Troubled)
- Top contributors by focus area
Usage Examples
- "What happened in the codebase today?"
- "Summarize this week's activity"
- "Show me PR activity for the last 7 days"
- "What work items were completed this week?"
Prerequisites
# Azure DevOps CLI configured
az devops configure --defaults organization=https://dev.azure.com/YOUR_ORG project=YOUR_PROJECT
# Authenticated
az login
Confluence Integration
Requires Atlassian MCP server configured. During data collection, use rovo_search to find recently modified pages.
Search query format: modified:>YYYY-MM-DD [space_key] [keywords]
Collects metadata only: page title, space, last modified date, author. No full content.
Ensure Atlassian MCP is configured.
Output Structure
.insights/
├── raw/
│ ├── prs.json # Azure PRs
│ ├── workitems.json # Azure work items
│ ├── commits.json # Local git commits
│ └── confluence.json # Confluence pages
├── 2025-01-08-insights.md # Daily reports
└── 2025-W02-insights.md # Weekly reports
Report Sections
Daily Summary
- Pull Requests: Opened, merged, reviewed today
- Commits: By author, by area
- Work Items: State changes (started, completed)
- Key Changes: AI-synthesized summary
Weekly Summary
- Overview: High-level activity summary
- PR Activity: Week's PRs with outcomes
- Commit Themes: Patterns and focus areas
- Work Items: Sprint progress, completions
- Contributors: Who worked on what
- Highlights: Notable achievements
Monthly Review
- High-Impact Initiatives: Work grouped by theme with effort/status
- Feature Completions: What shipped and its impact
- Top Contributors: Who drove what areas
- Themes Summary: PR distribution across themes
- Key Observations: Merge rate, bottlenecks, concerns
Converted and distributed by TomeVault — claim your Tome and manage your conversions.