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.
Resolve pull request code review comments end-to-end. An agent skill from shencangsheng/easydb_app.
$ npx skills add shencangsheng/easydb_app --skill resolve-pr-review -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install shencangsheng/easydb_app resolve-pr-review --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ 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-srcUse ~/.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/
Install the "resolve-pr-review" agent skill from https://github.com/shencangsheng/easydb_app/tree/main/.cursor/skills/resolve-pr-review into .claude/skills/resolve-pr-review/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "resolve-pr-review", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/shencangsheng/easydb_app/tree/main/.cursor/skills/resolve-pr-reviewType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add shencangsheng/easydb_app --skill resolve-pr-review -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install shencangsheng/easydb_app resolve-pr-review --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/shencangsheng/easydb_app.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.cursor/skills/resolve-pr-review .agents/skills/resolve-pr-review && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "resolve-pr-review" agent skill from https://github.com/shencangsheng/easydb_app/tree/main/.cursor/skills/resolve-pr-review into .agents/skills/resolve-pr-review/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "resolve-pr-review", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add shencangsheng/easydb_app --skill resolve-pr-review -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install shencangsheng/easydb_app resolve-pr-review --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/shencangsheng/easydb_app.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.cursor/skills/resolve-pr-review .cursor/skills/resolve-pr-review && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "resolve-pr-review" agent skill from https://github.com/shencangsheng/easydb_app/tree/main/.cursor/skills/resolve-pr-review into .cursor/skills/resolve-pr-review/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "resolve-pr-review", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/shencangsheng/easydb_app.git --path .cursor/skills/resolve-pr-review--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add shencangsheng/easydb_app --skill resolve-pr-review -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install shencangsheng/easydb_app resolve-pr-review --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/shencangsheng/easydb_app.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.cursor/skills/resolve-pr-review .gemini/skills/resolve-pr-review && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "resolve-pr-review" agent skill from https://github.com/shencangsheng/easydb_app/tree/main/.cursor/skills/resolve-pr-review into .gemini/skills/resolve-pr-review/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "resolve-pr-review", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install shencangsheng/easydb_app resolve-pr-reviewInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add shencangsheng/easydb_app --skill resolve-pr-review -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/shencangsheng/easydb_app.git skills-src && mkdir -p .github/skills && cp -r skills-src/.cursor/skills/resolve-pr-review .github/skills/resolve-pr-review && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "resolve-pr-review" agent skill from https://github.com/shencangsheng/easydb_app/tree/main/.cursor/skills/resolve-pr-review into .github/skills/resolve-pr-review/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "resolve-pr-review", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add shencangsheng/easydb_app --skill resolve-pr-review -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install shencangsheng/easydb_app resolve-pr-review --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/shencangsheng/easydb_app.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.cursor/skills/resolve-pr-review .opencode/skills/resolve-pr-review && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "resolve-pr-review" agent skill from https://github.com/shencangsheng/easydb_app/tree/main/.cursor/skills/resolve-pr-review into .opencode/skills/resolve-pr-review/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "resolve-pr-review", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
resolve-pr-reviewResolve 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. 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.
9 steps, taken from the step headings in SKILL.md.
Read from SKILL.md and the folder at commit 1c461a3. It shows what the files ask for, not the result of running them.
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.
Shell commands in SKILL.md call:
geminighgitcargonpmFrom the folder's file list and the shell code blocks in SKILL.md.
Hosts in commands or code, which the agent is likely to contact:
github.comFrom URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
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.
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.
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.
The full file from shencangsheng/easydb_app at commit 1c461a3, republished under its MIT licence (© shencangsheng). 911 words, ~2,397 tokens.
.claude/skills/resolve-pr-review/SKILL.md (or your agent's skills folder).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.
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.
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`Run in parallel:
gh pr view {number} --repo {owner}/{repo} --json title,headRefName,baseRefName,headRefOid,state,commits
git status -sb
git branch --show-currentIf not on the PR head branch, checkout it:
gh pr checkout {number} --repo {owner}/{repo}Inline comments (suggestions, file/line context):
gh api repos/{owner}/{repo}/pulls/{number}/comments --paginateUnresolved threads (preferred — includes resolved state):
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.
For each unresolved thread, record:
| # | File | Reviewer | Summary | Code status |
|---|---|---|---|---|
| 1 | path/to/file | author | one-line intent | pending / 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.
For each pending item:
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.
Run checks proportional to touched files:
# Rust changes
cd src-tauri && cargo check
# Frontend changes
npm run build
# or: npx tsc --noEmitFix any failures introduced by your changes before committing.
Follow the repo's commit message style. One focused commit is enough:
git add <relevant files>
git commit -m "$(cat <<'EOF'
fix: address PR review feedback on <short topic>
EOF
)"
git pushSkip commit/push if no code changes were needed (threads-only resolution).
For each thread that is fixed in the PR head, run:
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:
gh api graphql -f query='...' # same query as Step 2; confirm isResolved: truePost 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):
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:
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).All review threads are now marked as resolved./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.@mention, /gemini review, and structural phrases consistent with the template above.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.
gemini-code-assist./gemini review runs against the current PR head./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):
| Command | Purpose |
|---|---|
/gemini review | Full re-review of the PR (default after resolving feedback) |
/gemini summary | New high-level summary of changes |
/gemini help | List available commands |
| Situation | Action |
|---|---|
| Comment already fixed in branch | Resolve thread only; no new commit |
| Comment partially addressed | Finish the fix, then resolve |
| Conflicting review comments | Ask the user which approach to take |
| Comment on outdated/deleted lines | Verify fix exists elsewhere; resolve if satisfied |
| Requires design choice | Ask before implementing |
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 reviewmain/master.@gemini-code-assist, etc.); a reply without the mention is incomplete./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
Just SKILL.md in .cursor/skills/resolve-pr-review of shencangsheng/easydb_app.
Open the folder on GitHubat commit 1c461a3
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.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Resolve PR Review this skillshencangsheng/easydb_app | 590 | — | ~2.4k | Automated safety check: Pass | MIT | |
| SeekDB Code Reviewoceanbase/seekdb | 3.1k | — | ~2.1k | Automated safety check: Pass | Apache-2.0 | |
| PR Reviewjaemk/self_update | 961 | — | ~1.5k | Automated safety check: Notes | MIT | |
| PR Reviewjaemk/cached | 2.1k | — | ~2.5k | Automated safety check: Notes | MIT | |
| Coding Agentmastra-ai/mastra | 29k | — | ~2.3k | Automated safety check: Pass | Custom licence | |
| Code Reviewoaslananka/kicad-mcp-pro | 122 | — | ~3.9k | Automated safety check: Pass | MIT |
oceanbase/seekdb
Reviews seekdb pull requests and diffs for real defects in correctness, resources, concurrency, security and tests, reporting only Blocker or Major findings.
jaemk/self_update
Targeted, read-only review of a PR or checked-out branch. An agent skill from jaemk/self_update.
jaemk/cached
Targeted, read-only review of a PR or checked-out branch. An agent skill from jaemk/cached.
mastra-ai/mastra
Authoring playbook for building agents that write, edit, review, or refactor code.
oaslananka/kicad-mcp-pro
A skill your agent uses for GitHub Copilot pull request and code reviews in oaslananka/kicad-mcp-pro.
MaterializeInc/materialize
Local code review of current branch vs Materialize standards.
shencangsheng/easydb_app
Enforces strict avoidance of unwrap() in Rust code. An agent skill from shencangsheng/easydb_app.
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).
Categories
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.