code-review-jira

What problem does it solve?

It turns a JIRA issue and its linked pull requests into a structured, actionable code review outcome, publishing technical findings to a GitHub PR and a non-technical summary back to the JIRA ticket for visibility.

Core Features & Use Cases

• JIRA issue context loading: Pulls full issue details (description, comments, attachments, links, custom fields, and related PRs) to review implementation against stated requirements.
• Multi-lens PR review (read-only): Runs compliance checks, technical review, security review, and refactoring/DRY analysis scoped to the PR diff.
• Targeted database and risk analysis: Detects database operations in the diff and triggers a dedicated MySQL problem solver analysis, including a dedicated reporting section on GitHub.
• Coverage reporting for changed lines: Runs diff-scoped coverage tooling (or reports that it is unavailable) and ensures coverage information is included in the published PR comment.

Quick Start

Use the code-review-jira skill to review the JIRA issue ECOMAIL-1234 by running it with the issue key as input, then review the posted GitHub PR technical comment and the consolidated JIRA summary comment.