generate-status-report_skill

Overview

This skill generates actionable project status reports by querying Jira, analyzing issues, and producing formatted summaries tailored to the audience. It can produce daily, weekly, sprint-based, or custom-period reports and can publish them to Confluence when requested. The skill is interactive and will always clarify scope and publishing details before performing Confluence actions.

How this skill works

The skill builds JQL queries to fetch relevant Jira issues (completed, in-progress, blocked, high priority) and extracts key fields such as key, summary, status, priority, assignee, and timestamps. It analyzes metrics (counts by status, completion rate, high-priority items, unassigned issues), identifies highlights and blockers, and formats the output using an audience-specific template. Finally, it offers to create or update a Confluence page using Markdown-formatted content and asks for space, parent page, and whether to create or update before publishing.

When to use it

• Create a weekly or daily status report for stakeholders
• Summarize project progress or recent accomplishments for executives
• Generate sprint or custom-period reports from Jira issue activity
• Identify and escalate critical blockers and at-risk items
• Publish status updates to Confluence for archive and visibility

Best practices

• Always confirm project key, time period, audience, and Confluence destination before querying Jira
• Run focused queries for completed, in-progress, blocked, and high-priority issues rather than one large query
• Link directly to Jira issues in the report and include specific metrics (counts and trends)
• Use executive template for decision-makers and detailed template for team-level reports
• Use consistent titles and parent pages in Confluence to make recurring reports easy to find

Example use cases

• Generate a weekly executive summary for Project PHX showing top 3 highlights and 3 critical blockers
• Produce a daily standup brief listing yesterday’s completions, today’s plans, and current blockers
• Create a sprint-end report with completed issues, unresolved blockers, and next-sprint priorities
• Identify unassigned high-priority issues and recommend action owners for delivery managers
• Publish a formatted status page under the project’s Confluence space for team visibility