Agile Observer
Proactive agile metrics engine for Scrum Masters and Agile Coaches.
Analyzes Trello or Jira boards to compute flow metrics, detect problems, and generate health reports.
Workflow
- Identify platform and credentials. Ask for Trello or Jira. Look for credential files in workspace secrets (
trello-credentials.json or jira-credentials.json).
- List boards/projects. Fetch available boards and let the user choose, or use the one specified.
- Fetch board data. Pull lists/statuses, cards/issues, and movement history using the API patterns in references.
- Classify workflow states. Map list names or status categories to: backlog, doing, review, done.
- Compute metrics. Calculate cycle time, throughput, WIP, aging, and blockers.
- Generate health report. Assess overall health and add coaching suggestions.
Metrics to Compute
| Metric |
Formula |
Source |
| Cycle Time (median + P85) |
Time from "doing" to "done" per item |
Card/issue transition history |
| Throughput |
Items completed in period |
Cards/issues moved to done |
| WIP |
Items currently in doing/review |
Current board state |
| Aging WIP |
In-progress items with no activity for 5+ days |
dateLastActivity or changelog |
| Blockers |
Items with "blocked" label or blocker priority |
Labels/flags |
| Sprint Burndown |
Done points vs. committed points (Jira only) |
Story points field |
List/Status Classification
Map names to workflow states using these patterns (case-insensitive):
- Backlog: backlog, to do, todo, icebox, upcoming
- Doing: doing, in progress, working, development, dev, active
- Review: review, testing, qa, validation, code review
- Done: done, complete, finished, deployed, released, closed
For Jira, use statusCategory.key: new = backlog, indeterminate = doing, done = done.
Health Score Logic
- 🟢 GOOD: No significant issues. Steady flow.
- 🟡 ATTENTION: WIP exceeds 10 items, OR items aging without activity, OR blockers present.
- 🔴 CONCERN: Cycle time median exceeds 7 days, OR multiple blockers, OR very low throughput.
Report Format
📊 Agile Health Report — [Board/Project Name]
Period: last [N] days
🔄 Throughput: [X] items completed
⏱ Cycle Time: Median [X]d | P85 [X]d ([N] items measured)
📋 WIP: [X] items in progress
📈 Sprint Progress: [X]/[Y] points ([Z]%) — Jira only
🚫 Blocked: [X] items — [names]
🧓 Stale: "[item]" (no activity [X]d)
[🟢/🟡/🔴] Health — [summary]
Coaching Suggestions
Include actionable advice based on findings:
- High WIP: "Consider a WIP limit of [team size x 1.5]. What needs finishing before starting something new?"
- Slow cycle time: "Where do items spend the most time? Look at the flow between columns."
- Stale items: "This item hasn't moved in [X] days. Still a priority, or should we park it?"
- Blockers: "What would it take to unblock [item]? Who needs to be involved?"
- Good health: "Flow looks healthy. What's one thing to improve next sprint?"
Platform API Details
- Trello endpoints and patterns: See
references/trello-api.md
- Jira endpoints and patterns: See
references/jira-api.md
- Detailed metric definitions: See
references/metrics.md
Credential Formats
Trello
{"api_key": "...", "token": "..."}
Also accepts: apiKey + apiToken
Jira
{"instance": "mycompany", "email": "user@example.com", "api_token": "..."}
Scheduling
For automated recurring reports, create a cron job:
- Schedule: weekly Monday 9:00 AM
- Task: Run agile-observer for board [X], deliver report to primary channel
1---2name: agile-observer3description: Proactive agile metrics and team health analysis for Trello and Jira boards. Computes cycle time, throughput, WIP, sprint burndown, aging work items, and blocker detection. Use when: analyzing sprint/board health, generating agile reports, checking team flow metrics, identifying bottlenecks, computing cycle time or throughput, reviewing WIP limits, detecting stale or blocked items, or creating sprint health summaries. Triggers on: how is the sprint going, board health, cycle time, throughput, burndown, agile metrics, team flow, WIP, blocked items, sprint report, agile health check.4---56# Agile Observer78Proactive agile metrics engine for Scrum Masters and Agile Coaches.9Analyzes Trello or Jira boards to compute flow metrics, detect problems, and generate health reports.1011## Workflow12131. **Identify platform and credentials.** Ask for Trello or Jira. Look for credential files in workspace secrets (`trello-credentials.json` or `jira-credentials.json`).142. **List boards/projects.** Fetch available boards and let the user choose, or use the one specified.153. **Fetch board data.** Pull lists/statuses, cards/issues, and movement history using the API patterns in references.164. **Classify workflow states.** Map list names or status categories to: backlog, doing, review, done.175. **Compute metrics.** Calculate cycle time, throughput, WIP, aging, and blockers.186. **Generate health report.** Assess overall health and add coaching suggestions.1920## Metrics to Compute2122| Metric | Formula | Source |23|--------|---------|--------|24| Cycle Time (median + P85) | Time from "doing" to "done" per item | Card/issue transition history |25| Throughput | Items completed in period | Cards/issues moved to done |26| WIP | Items currently in doing/review | Current board state |27| Aging WIP | In-progress items with no activity for 5+ days | dateLastActivity or changelog |28| Blockers | Items with "blocked" label or blocker priority | Labels/flags |29| Sprint Burndown | Done points vs. committed points (Jira only) | Story points field |3031## List/Status Classification3233Map names to workflow states using these patterns (case-insensitive):34- **Backlog:** backlog, to do, todo, icebox, upcoming35- **Doing:** doing, in progress, working, development, dev, active36- **Review:** review, testing, qa, validation, code review37- **Done:** done, complete, finished, deployed, released, closed3839For Jira, use `statusCategory.key`: `new` = backlog, `indeterminate` = doing, `done` = done.4041## Health Score Logic4243- **🟢 GOOD:** No significant issues. Steady flow.44- **🟡 ATTENTION:** WIP exceeds 10 items, OR items aging without activity, OR blockers present.45- **🔴 CONCERN:** Cycle time median exceeds 7 days, OR multiple blockers, OR very low throughput.4647## Report Format4849```50📊 Agile Health Report — [Board/Project Name]51Period: last [N] days5253🔄 Throughput: [X] items completed54⏱ Cycle Time: Median [X]d | P85 [X]d ([N] items measured)55📋 WIP: [X] items in progress56📈 Sprint Progress: [X]/[Y] points ([Z]%) — Jira only57🚫 Blocked: [X] items — [names]58🧓 Stale: "[item]" (no activity [X]d)5960[🟢/🟡/🔴] Health — [summary]61```6263## Coaching Suggestions6465Include actionable advice based on findings:66- High WIP: "Consider a WIP limit of [team size x 1.5]. What needs finishing before starting something new?"67- Slow cycle time: "Where do items spend the most time? Look at the flow between columns."68- Stale items: "This item hasn't moved in [X] days. Still a priority, or should we park it?"69- Blockers: "What would it take to unblock [item]? Who needs to be involved?"70- Good health: "Flow looks healthy. What's one thing to improve next sprint?"7172## Platform API Details7374- **Trello endpoints and patterns:** See `references/trello-api.md`75- **Jira endpoints and patterns:** See `references/jira-api.md`76- **Detailed metric definitions:** See `references/metrics.md`7778## Credential Formats7980### Trello81```json82{"api_key": "...", "token": "..."}83```84Also accepts: `apiKey` + `apiToken`8586### Jira87```json88{"instance": "mycompany", "email": "user@example.com", "api_token": "..."}89```9091## Scheduling9293For automated recurring reports, create a cron job:94- Schedule: weekly Monday 9:00 AM95- Task: Run agile-observer for board [X], deliver report to primary channel
luokai0