Agent skill

Resolve PR Review

by shencangsheng in shencangsheng/easydb_app

Resolve pull request code review comments end-to-end. An agent skill from shencangsheng/easydb_app.

MITAuto-check passedDevelopment

Install Resolve PR Review

skills CLI
$ npx skills add shencangsheng/easydb_app --skill resolve-pr-review -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install shencangsheng/easydb_app resolve-pr-review --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/shencangsheng/easydb_app.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.cursor/skills/resolve-pr-review .claude/skills/resolve-pr-review && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
resolve-pr-review
GitHub stars
590
Token cost
~2.4k tokens
SKILL.md length
911 words
Files
1
Skills in repo
3
Repo updated
First seen
Licence
MIT

At a glance

Resolve pull request code review comments end-to-end. An agent skill from shencangsheng/easydb_app.

  • Works in 9 steps: PR state → Fetch review feedback → Build checklist → …
  • The user shares a PR link
  • SKILL.md covers Parse the PR, Workflow checklist, Step 1 — PR state and Step 2 — Fetch review feedback, plus 10 more sections
  • Calls gemini, gh and git; reaches github.com

What it does

Resolve PR Review is an agent skill from shencangsheng/easydb_app. Resolve pull request code review comments end-to-end. Fetches inline review threads from a GitHub PR URL, verifies or implements fixes in the working branch, resolves threads, and posts a summary reply. Use when the user shares a PR link, asks to address/fix/resolve code review feedback, or mentions gemini-code-assist, Copilot, or Bugbot review comments on a pull request.

Its SKILL.md is about 2.4k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Development, covering Pull requests, CSV and tabular files and Code review. It works with GitHub, Tauri, Rust and SQL. The repository describes itself as: EasyDB is a lightweight desktop app built with Tauri + Rust, powered by Apache DataFusion. Query local CSV, TSV, Text, NdJson, Excel, Parquet files and MySQL databases directly…. The licence is MIT.

When your agent uses it

  • The user shares a PR link
  • Asks to address/fix/resolve code review feedback
  • Mentions gemini-code-assist
  • Bugbot review comments on a pull request

Example prompts

  • “/resolve-pr-review”

Requirements

  • Node.js

Workflow steps

9 steps, taken from the step headings in SKILL.md.

  1. PR state
  2. Fetch review feedback
  3. Build checklist
  4. Verify and fix
  5. Smoke checks
  6. Commit and push (only if code changed)
  7. Resolve threads
  8. PR reply
  9. Request re-review

What it can do on your machine

Read from SKILL.md and the folder at commit 1c461a3. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • gemini
    • gh
    • git
    • cargo
    • npm

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Hosts in commands or code, which the agent is likely to contact:

    • github.com

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Resolve PR Review loads about 2.4k tokens when it runs. Until then it costs about 98 tokens; SKILL.md has 911 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~98
When it runs · the whole SKILL.md, loaded when a task matches
~2.4k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from shencangsheng/easydb_app at commit 1c461a3, republished under its MIT licence (© shencangsheng). 911 words, ~2,397 tokens.

Download SKILL.mdSave it as .claude/skills/resolve-pr-review/SKILL.md (or your agent's skills folder).
name
resolve-pr-review
description
Resolve pull request code review comments end-to-end. Fetches inline review threads from a GitHub PR URL, verifies or implements fixes in the working branch, resolves threads, and posts a summary reply. Use when the user shares a PR link, asks to address/fix/resolve code review feedback, or mentions gemini-code-assist, Copilot, or Bugbot review comments on a pull request.

Resolve PR Code Review

When the user provides a GitHub PR URL (or asks to resolve review on a PR), run this workflow end-to-end. Do not edit plan files if the user attached one — execute the workflow directly.

Parse the PR

Extract owner, repo, and number from URLs like:

  • https://github.com/{owner}/{repo}/pull/{number}
  • https://github.com/{owner}/{repo}/pull/{number}#discussion_r...
  • https://github.com/{owner}/{repo}/pull/{number}#pullrequestreview-...

Use gh for all GitHub operations. Require gh auth; if unauthenticated, stop and tell the user to run gh auth login.

Workflow checklist

Copy and track progress:

- [ ] 1. Inspect PR state (branch, head commit, CI)
- [ ] 2. Fetch all inline review comments + unresolved threads
- [ ] 3. Build a per-comment checklist (file, suggestion, status)
- [ ] 4. Verify each item against current code; fix gaps with minimal diff
- [ ] 5. Run smoke checks (build / tests relevant to changed files)
- [ ] 6. Commit and push code fixes (if any)
- [ ] 7. Resolve all addressed review threads on GitHub
- [ ] 8. Post a PR conversation reply @-mentioning the reviewer bot (e.g. `@gemini-code-assist`)
- [ ] 9. Request gemini-code-assist re-review via `/gemini review`

Step 1 — PR state

Run in parallel:

bash
gh pr view {number} --repo {owner}/{repo} --json title,headRefName,baseRefName,headRefOid,state,commits
git status -sb
git branch --show-current

If not on the PR head branch, checkout it:

bash
gh pr checkout {number} --repo {owner}/{repo}

Step 2 — Fetch review feedback

Inline comments (suggestions, file/line context):

bash
gh api repos/{owner}/{repo}/pulls/{number}/comments --paginate

Unresolved threads (preferred — includes resolved state):

bash
gh api graphql -f query='
query {
  repository(owner: "{owner}", name: "{repo}") {
    pullRequest(number: {number}) {
      reviewThreads(first: 50) {
        nodes {
          id
          isResolved
          comments(first: 1) {
            nodes {
              body
              path
              line
              author { login }
            }
          }
        }
      }
    }
  }
}'

Filter to unresolved threads first. Skip bot noise (CI reports, dependency bots) unless the user asked to handle them. Prioritize human reviewers and code-assist bots (e.g. gemini-code-assist, copilot-pull-request-reviewer).

When reading API output, extract only: thread id, file path, line, comment body, author — do not dump full JSON into the reply.

Step 3 — Build checklist

For each unresolved thread, record:

#FileReviewerSummaryCode status
1path/to/fileauthorone-line intentpending / fixed / N/A

Group related comments on the same file. If a later commit already addressed a comment but the thread is still open, mark fixed and plan to resolve without new code.

Step 4 — Verify and fix

For each pending item:

  1. Read the cited file at the relevant lines.
  2. Compare current code to the reviewer's suggestion.
  3. Apply the smallest correct diff that satisfies the feedback.
  4. Match project conventions (existing components, error handling, naming).

Do not refactor unrelated code. Do not resolve a thread unless the fix is actually in the PR head commit (after push if you made changes).

If a comment is invalid or out of scope, skip the code change and explain why in the PR reply — do not resolve unless the user wants threads closed anyway.

Step 5 — Smoke checks

Run checks proportional to touched files:

bash
# Rust changes
cd src-tauri && cargo check

# Frontend changes
npm run build
# or: npx tsc --noEmit

Fix any failures introduced by your changes before committing.

Step 6 — Commit and push (only if code changed)

Follow the repo's commit message style. One focused commit is enough:

bash
git add <relevant files>
git commit -m "$(cat <<'EOF'
fix: address PR review feedback on <short topic>

EOF
)"
git push

Skip commit/push if no code changes were needed (threads-only resolution).

Step 7 — Resolve threads

For each thread that is fixed in the PR head, run:

bash
gh api graphql -f query='
mutation {
  resolveReviewThread(input: {threadId: "{thread_id}"}) {
    thread { isResolved }
  }
}'

Resolve all addressed threads, including ones fixed in an earlier commit on the branch.

Verify all threads are resolved:

bash
gh api graphql -f query='...'  # same query as Step 2; confirm isResolved: true

Step 8 — PR reply

Post a concise summary on the PR conversation. Always @-mention the reviewer bot that left the inline comments (e.g. @gemini-code-assist, @copilot-pull-request-reviewer). Detect the reviewer login from Step 2 thread data (author.login); if multiple bots reviewed, mention each one once at the top.

Standard format (follow PR #15 as the template):

bash
gh pr comment {number} --repo {owner}/{repo} --body "$(cat <<'EOF'
Thanks @gemini-code-assist for the review! All {N} inline comments have been addressed in commit `<sha>` (`<commit subject>`):

1. **`file.ts`**: brief what changed
2. **`other.rs`**: brief what changed

All review threads are now marked as resolved.

/gemini review
EOF
)"

Rules for the reply body:

  • Opening line: Thanks @<reviewer-bot> for the review! — required when the review came from a bot; use the exact GitHub login (e.g. gemini-code-assist, not the display name).
  • Commit reference: include short SHA and commit subject on the same line as the item count.
  • Item list: numbered, one entry per resolved thread; wrap file paths in backticks.
  • Closing line: All review threads are now marked as resolved.
  • Re-review trigger: append /gemini review on its own line at the end of the same comment (Step 9). This is the official slash command to request a fresh code review from gemini-code-assist after fixes are pushed.
  • Use the user's language (Chinese or English) for the change descriptions, but keep the @mention, /gemini review, and structural phrases consistent with the template above.
Show full SKILL.md (329 more words)Show less

Step 9 — Request re-review

After posting the Step 8 summary (which already includes /gemini review at the end), gemini-code-assist will automatically run a new review on the latest commit.

  • When to include: always, if the original review came from gemini-code-assist.
  • When to skip: only if the reviewer was a human or a different bot (e.g. Copilot) — use that bot's equivalent command instead, or omit if none exists.
  • Prerequisite: fixes must be committed and pushed before posting; /gemini review runs against the current PR head.
  • Do not post /gemini review before Step 7 (resolve threads) and Step 8 (summary) — the bot should see resolved threads and a clear changelog first.

Other useful commands (only when explicitly requested by the user):

CommandPurpose
/gemini reviewFull re-review of the PR (default after resolving feedback)
/gemini summaryNew high-level summary of changes
/gemini helpList available commands

Decision rules

SituationAction
Comment already fixed in branchResolve thread only; no new commit
Comment partially addressedFinish the fix, then resolve
Conflicting review commentsAsk the user which approach to take
Comment on outdated/deleted linesVerify fix exists elsewhere; resolve if satisfied
Requires design choiceAsk before implementing

Example trigger

User: https://github.com/shencangsheng/easydb_app/pull/15#pullrequestreview-4433989260 把 review 都解决掉

Agent should: parse PR 15 → fetch gemini-code-assist threads → verify/fix → resolve threads → reply on PR with @gemini-code-assist mention → append /gemini review to request re-review.

Reference reply (PR #15):

Thanks @gemini-code-assist for the review! All 7 inline comments have been addressed in commit `4f9e8d1` (`refactor: enhance notebook components for saved queries`):

1. **`db_utils.rs`** — `insert_saved_query` now opens a single DB connection and reuses it for `execute` + `last_insert_rowid`.
2. **`notebook-left-saved-queries.tsx`** — Search filter uses HeroUI `Input` with `placeholder`, `size="sm"`, and `variant="bordered"`.
...

All review threads are now marked as resolved.

/gemini review

Hard rules

  • Never force-push to main/master.
  • Never skip pre-commit hooks unless the user explicitly asks.
  • Only commit when there are actual code changes (or the user explicitly asks to commit).
  • Resolve a thread only when the feedback is genuinely addressed in the PR head.
  • Keep replies and diffs scoped to review feedback — no drive-by refactors.
  • Always @-mention the reviewing bot in the PR summary comment (@gemini-code-assist, etc.); a reply without the mention is incomplete.
  • Always append /gemini review at the end of the summary comment when the original review came from gemini-code-assist; this triggers a fresh review on the fixed code.

© shencangsheng, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in .cursor/skills/resolve-pr-review of shencangsheng/easydb_app.

Open the folder on GitHubat commit 1c461a3

Compare with similar skills

Resolve PR Review next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Resolve PR Review compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Resolve PR Review this skillshencangsheng/easydb_app590—~2.4kAutomated safety check: PassMIT
SeekDB Code Reviewoceanbase/seekdb3.1k—~2.1kAutomated safety check: PassApache-2.0
PR Reviewjaemk/self_update961—~1.5kAutomated safety check: NotesMIT
PR Reviewjaemk/cached2.1k—~2.5kAutomated safety check: NotesMIT
Coding Agentmastra-ai/mastra29k—~2.3kAutomated safety check: PassCustom licence
Code Reviewoaslananka/kicad-mcp-pro122—~3.9kAutomated safety check: PassMIT

Similar skills

  • SeekDB Code Review

    oceanbase/seekdb

    Reviews seekdb pull requests and diffs for real defects in correctness, resources, concurrency, security and tests, reporting only Blocker or Major findings.

    3.1k GitHub stars~2.1k tokensUpdated yesterday
    DevelopmentAuto-check passed
  • PR Review

    jaemk/self_update

    Targeted, read-only review of a PR or checked-out branch. An agent skill from jaemk/self_update.

    961 GitHub stars~1.5k tokensUpdated 1 mo ago
    DevelopmentAuto-check: notes
  • PR Review

    jaemk/cached

    Targeted, read-only review of a PR or checked-out branch. An agent skill from jaemk/cached.

    2.1k GitHub stars~2.5k tokensUpdated 9 days ago
    DevelopmentAuto-check: notes
  • Coding Agent

    mastra-ai/mastra

    Authoring playbook for building agents that write, edit, review, or refactor code.

    29k GitHub stars~2.3k tokensUpdated today
    DevelopmentAuto-check passed
  • Code Review

    oaslananka/kicad-mcp-pro

    A skill your agent uses for GitHub Copilot pull request and code reviews in oaslananka/kicad-mcp-pro.

    122 GitHub stars~3.9k tokensUpdated today
    DevelopmentAuto-check passed
  • Mz PR Review

    MaterializeInc/materialize

    Local code review of current branch vs Materialize standards.

    6.4k GitHub stars~1.6k tokensUpdated today
    DevelopmentAuto-check: notes

More from shencangsheng/easydb_app

  • Rust No Unwrap

    shencangsheng/easydb_app

    Enforces strict avoidance of unwrap() in Rust code. An agent skill from shencangsheng/easydb_app.

    590 GitHub stars~802 tokensUpdated 1 mo ago
    Auto-check passed
  • Rust SQL Test

    shencangsheng/easydb_app

    Enforces unit test requirements for the Rust data-processing modules in src-tauri/src/sql/ (generator.rs, parse.rs) and src-tauri/src/reader/ (excel.rs and other readers).

    590 GitHub stars~1.2k tokensUpdated 1 mo ago
    Auto-check passed

Categories

Questions about Resolve PR Review

What does Resolve PR Review do?

Resolve pull request code review comments end-to-end. An agent skill from shencangsheng/easydb_app. Resolve PR Review is an agent skill from shencangsheng/easydb_app. Resolve pull request code review comments end-to-end.

When should I use Resolve PR Review?

Resolve PR Review fits situations like: the user shares a PR link; asks to address/fix/resolve code review feedback; mentions gemini-code-assist; bugbot review comments on a pull request.

How do I install Resolve PR Review in Claude Code?

Run `npx skills add shencangsheng/easydb_app --skill resolve-pr-review -a claude-code`. Or copy the skill folder (.cursor/skills/resolve-pr-review in shencangsheng/easydb_app) into .claude/skills/resolve-pr-review in your project. Claude Code loads it when a task matches its description.

How do I install Resolve PR Review in Codex?

Run `npx skills add shencangsheng/easydb_app --skill resolve-pr-review -a codex`. Or copy the skill folder (.cursor/skills/resolve-pr-review in shencangsheng/easydb_app) into .agents/skills/resolve-pr-review in your project. Codex loads it when a task matches its description.

Can I use Resolve PR Review in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add shencangsheng/easydb_app --skill resolve-pr-review -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/resolve-pr-review, .gemini/skills/resolve-pr-review, .github/skills/resolve-pr-review and .opencode/skills/resolve-pr-review in your project.

What does Resolve PR Review need to run?

Going by SKILL.md and its folder, Resolve PR Review needs the command-line tools its instructions call (gemini, gh, git, cargo and npm). Our summary lists: Node.js.

Does Resolve PR Review access the network?

SKILL.md names 1 domain. In commands or code: github.com; the agent is likely to contact it when it follows the instructions. This is read from the text; nothing was executed.

Is Resolve PR Review safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Resolve PR Review use?

Resolve PR Review is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Resolve PR Review use?

About 2.4k tokens (SKILL.md is roughly 9.6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Resolve PR Review?

Skills that share tags, products or a category with Resolve PR Review: SeekDB Code Review (oceanbase/seekdb, 3.1k stars), PR Review (jaemk/self_update, 961 stars), PR Review (jaemk/cached, 2.1k stars) and Coding Agent (mastra-ai/mastra, 29k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Resolve PR Review?

shencangsheng (a GitHub user) maintains it in shencangsheng/easydb_app, which has 590 GitHub stars. The repository holds 3 skills in this directory. The repository was last updated on August 14, 2026.

Source: shencangsheng/easydb_app on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.