github-review-report

Generate Chinese-format Excel PR review reports from GitHub reviews.

7|3|Updated Jan 15, 2026
One-click install
npx skills add https://github.com/re2zero/deepin-skills --skill github-review-report
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: github-review-report
Source: https://github.com/re2zero/deepin-skills/tree/main/github-review-report
Command: npx skills add https://github.com/re2zero/deepin-skills --skill github-review-report

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires gh, pandas, openpyxl, ai-service.

What problem does it solve?

This Skill automates the creation of structured Chinese-format Excel reports from GitHub pull requests by analyzing code reviews with AI, enabling consistent documentation of issues, risks, and improvement suggestions.

Core Features & Use Cases

  • Two-phase workflow: Collect PR reviews from GitHub, then apply AI analysis to generate structured problem descriptions and impact analysis.
  • Template-based Excel output: Generate reports using a predefined Excel template to preserve formatting, fonts, and styling.
  • Flexible filtering: Filter PRs and reviews by date ranges, branches, and reviewers to produce targeted reports for audits or project reviews.
  • Use Case: Generate a monthly report for a repository showing review quality, common issues, and key reviewers.

Quick Start

Run the skill with your target repository and time range to produce a Chinese-format Excel PR review report. For example: python -m your_skill_module --repo <owner>/<repo> --since "last month" --module-name <module> --base master

Frequently Asked Questions about github-review-report

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate generating Chinese Excel reports from GitHub PR reviews?

You can automate generating Chinese Excel PR review reports by collecting GitHub pull request data within a date window, applying AI analysis to each review, and exporting the structured results to a template-based Excel document.

What is the best way to filter GitHub PR reviews by date and branch for an audit report?

The best way to filter GitHub PR reviews for an audit report is by specifying date ranges, branches, and reviewers, which allows you to produce targeted reports for governance, QA auditing, and project retrospectives.

Does GitHub PR review automation require the gh CLI to work?

Yes, GitHub PR review automation requires the gh CLI to collect pull request data, alongside pandas and openpyxl for Excel template processing, and an AI service to perform the code review analysis.

Can I use a predefined Excel template for exporting AI-analyzed code review reports?

Yes, you can use a predefined Excel template to export AI-analyzed code review reports, which preserves the original formatting, fonts, and styling while populating it with structured problem descriptions and impact analysis.

How does AI analysis work when processing GitHub pull requests for QA auditing?

AI analysis processes GitHub pull requests for QA auditing by evaluating each collected review to generate structured problem descriptions, identify risks, and provide improvement suggestions for the final Excel report.

What are the limitations of using template-based Excel exports for PR review reports?

A limitation of using template-based Excel exports for PR review reports is that the output format and styling are rigidly bound to the predefined template, restricting dynamic layout adjustments for the AI-generated analysis results.