Lancedb Update Lance Dependency
lancedb/lancedb
Update LanceDB to a specific Lance release or tag. An agent skill from lancedb/lancedb.
In-browser review of pending changes before committing or opening a PR.
$ npx skills add ClickHouse/ClickHouse --skill diff-review -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install ClickHouse/ClickHouse diff-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/ClickHouse/ClickHouse.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/diff-review .claude/skills/diff-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 "diff-review" agent skill from https://github.com/ClickHouse/ClickHouse/tree/master/.claude/skills/diff-review into .claude/skills/diff-review/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "diff-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/ClickHouse/ClickHouse/tree/master/.claude/skills/diff-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 ClickHouse/ClickHouse --skill diff-review -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install ClickHouse/ClickHouse diff-review --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/ClickHouse/ClickHouse.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.claude/skills/diff-review .agents/skills/diff-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 "diff-review" agent skill from https://github.com/ClickHouse/ClickHouse/tree/master/.claude/skills/diff-review into .agents/skills/diff-review/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "diff-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 ClickHouse/ClickHouse --skill diff-review -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install ClickHouse/ClickHouse diff-review --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/ClickHouse/ClickHouse.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.claude/skills/diff-review .cursor/skills/diff-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 "diff-review" agent skill from https://github.com/ClickHouse/ClickHouse/tree/master/.claude/skills/diff-review into .cursor/skills/diff-review/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "diff-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/ClickHouse/ClickHouse.git --path .claude/skills/diff-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 ClickHouse/ClickHouse --skill diff-review -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install ClickHouse/ClickHouse diff-review --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/ClickHouse/ClickHouse.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.claude/skills/diff-review .gemini/skills/diff-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 "diff-review" agent skill from https://github.com/ClickHouse/ClickHouse/tree/master/.claude/skills/diff-review into .gemini/skills/diff-review/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "diff-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 ClickHouse/ClickHouse diff-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 ClickHouse/ClickHouse --skill diff-review -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/ClickHouse/ClickHouse.git skills-src && mkdir -p .github/skills && cp -r skills-src/.claude/skills/diff-review .github/skills/diff-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 "diff-review" agent skill from https://github.com/ClickHouse/ClickHouse/tree/master/.claude/skills/diff-review into .github/skills/diff-review/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "diff-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 ClickHouse/ClickHouse --skill diff-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 ClickHouse/ClickHouse diff-review --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/ClickHouse/ClickHouse.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.claude/skills/diff-review .opencode/skills/diff-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 "diff-review" agent skill from https://github.com/ClickHouse/ClickHouse/tree/master/.claude/skills/diff-review into .opencode/skills/diff-review/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "diff-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.
diff-reviewIn-browser review of pending changes before committing or opening a PR.
Diff Review is an agent skill from ClickHouse/ClickHouse. In-browser review of pending changes before committing or opening a PR. Starts a local server on localhost:3000 that renders the working-tree diff with @pierre/diffs CodeView, opens the user's browser, and waits for their line comments — which must then be read back and addressed. Works from a browser on the same machine, or from the user's own machine through an SSH-forwarded port (the server prints the ssh -L command); where nobody opens the page within 120 s, it exits on its own. Use when the user asks for a…
Its SKILL.md is about 1.3k tokens, which your agent loads only when the skill is triggered. The skill folder holds 10 other files (for example `vendor/README.md`).
It sits in Databases. It works with Git. The repository describes itself as: ClickHouse® is a real-time analytics database management system. The licence is Apache-2.0.
5 steps, taken from the first numbered list in SKILL.md.
Read from SKILL.md and the folder at commit cd023af. 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.
Ships script files (JavaScript), which the agent can run.
Shell commands in SKILL.md call:
gitsshnodeFrom the folder's file list and the shell code blocks in SKILL.md.
No URLs in SKILL.md. Its commands use git and ssh, which can reach the network depending on how they are called.
From 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.
Diff Review loads about 1.3k tokens when it runs. Until then it costs about 140 tokens; SKILL.md has 657 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 ClickHouse/ClickHouse at commit cd023af, republished under its Apache-2.0 licence (© ClickHouse). 657 words, ~1,302 tokens.
.claude/skills/diff-review/SKILL.md (or your agent's skills folder). This skill also uses 9 other files; get the full folder from GitHub.The user wants to read and review code changes in a browser UI before anything is committed or pushed. This skill serves the diff on localhost, collects the user's line comments, and hands them back to you as JSON. You must address every comment.
The server binds to loopback, so the UI is reachable from a browser on the very
machine the server runs on — or from the user's own machine once they forward
the port (when the machine looks remote, the server prints the exact ssh -L
command to do that). What it cannot survive is an environment where nobody will
ever open the page: an unattended run on an isolated VM. There the server exits
4 on its own after 120 s (see Exit code 4 below). Don't reach for this skill
when there is no user around to open a browser: show the diff in the terminal
with git diff / git show, or just open the pull request and let review
happen there.
Start the server in the background (Bash tool with run_in_background: true):
node .claude/skills/diff-review/server.mjs \
--repo <repo-root> \
--base HEAD \
--port 3000 \
--out /tmp/diff-review-comments.json--base <ref> — what to diff against. HEAD (default) reviews uncommitted
work: staged + unstaged + untracked files.--committed — review already-committed branch work before a PR: diffs
<base>..HEAD and ignores the working tree, so uncommitted or untracked
local edits never leak into the review. Combine it with the merge base
against the repo's default branch, e.g.
--base $(git merge-base origin/master HEAD) --committed.ssh -L port-forwarding
command for the user to review from their own machine, and exits 4 if no
browser opens the page within 120 s.@pierre/diffs is vendored (see
vendor/README.md), so no network access is needed and no third-party CDN
ever sees the diff.Tell the user the review is ready at http://localhost:3000 (and relay the
port-forwarding command if the server printed one), then wait. Do not
fetch the URL yourself — a request from you would count as the browser the
server is waiting for. Do not proceed with the commit/PR — you will be
notified when the background command exits (i.e. when the user submits the
review, or when nobody opened the page in time).
Read the --out JSON file. Shape:
{
"verdict": "approve" | "request_changes",
"overall": "free-text overall comment (may be empty)",
"comments": [
{ "file": "src/app.ts", "side": "new", "startLine": 12, "endLine": 15,
"comment": "the user's comment text" }
]
}side: "new" means line numbers refer to the new version of the file;
side: "old" refers to the base version (a comment on deleted lines).
Address every comment. They are the user's code review. For each one, quote it briefly, then either fix the code or answer the question. After making fixes, offer another review round (re-run the skill) before committing.
verdict: "approve" with no comments → proceed with the commit / PR.
verdict: "request_changes" → do NOT commit until fixes are made and the user
is satisfied.
--base.SSH_CONNECTION/SSH_CLIENT/SSH_TTY), cloud-init state or a cloud vendor
in the DMI strings, or a Linux session with neither DISPLAY nor
WAYLAND_DISPLAY) and no browser opened the review page within 120 s, despite
the printed port-forwarding command. This is the expected outcome on an
unattended, isolated VM — fall back to a terminal diff and carry on; do not
retry on your own initiative.
--force (or DIFF_REVIEW_FORCE=1) makes the server wait indefinitely — for
a user who asked for it because they need more time to forward the port.pkill -f "diff-review/server.mjs", or pass --port <other> and give the user
the new URL.© ClickHouse, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
SKILL.md and 9 other files in .claude/skills/diff-review of ClickHouse/ClickHouse.
Open the folder on GitHubat commit cd023af
Diff 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 |
|---|---|---|---|---|---|---|
| Diff Review this skillClickHouse/ClickHouse | 50k | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | |
| Lancedb Update Lance Dependencylancedb/lancedb | 12k | — | ~1.1k | Automated safety check: Pass | Apache-2.0 | |
| Find Postgres Bugdigoal/blog | 8.6k | — | ~4k | Automated safety check: Pass | GPL-2.0 | |
| Wtfnoobnooc/agent | 1.4k | — | ~2.1k | Automated safety check: Notes | None | |
| Notcrawlopenclaw/notcrawl | 134 | — | ~698 | Automated safety check: Pass | MIT | |
| Alsacreations Guidelinesalsacreations/kiwipedia | 338 | — | ~900 | Automated safety check: Pass | None |
lancedb/lancedb
Update LanceDB to a specific Lance release or tag. An agent skill from lancedb/lancedb.
digoal/blog
Find latent bugs in a local PostgreSQL source tree (RELxxSTABLE branch or HEAD) the way a core hacker does: build a heavily-poisoned debug instance (cassert + cache-discard + -O0/-ggdb3 + core…
noobnooc/agent
Pre-launch and pre-commit audit for vibe coding projects. An agent skill from noobnooc/agent.
openclaw/notcrawl
A skill your agent uses for local Notion archive search, sync freshness, Markdown/database exports, git-share snapshots, and Notcrawl repo/release work.
alsacreations/kiwipedia
Guidelines techniques et conventions internes d'Alsacréations (Kiwipedia) — HTML, CSS, JavaScript, TypeScript, Vue.js, WordPress, PHP/MySQL, accessibilité, performance, SEO, RGPD, écoconception…
KenjiOhtsuka/harmonica
A skill your agent uses when reviewing the Harmonica restart plan against reality — after a phase PR or milestone merges, before proposing the next phase, or when asked "are the specs up to date" /…
ClickHouse/ClickHouse
Analyze ClickHouse Keeper stress-test results from play.clickhouse.com / keeperstresstests data warehouse.
ClickHouse/ClickHouse
Evaluate ClickHouse performance test results from existing CI/dashboard data or local perf.py runs.
ClickHouse/ClickHouse
Check whether ClickHouse's supported versions (last 3 majors + latest LTS) have recent stable patch releases, diagnose why the scheduled AutoReleases pipeline failed, and identify which releases…
ClickHouse/ClickHouse
Analyze a jemalloc (or other) allocation profile in collapsed stack format.
ClickHouse/ClickHouse
Bisect a ClickHouse regression using pre-built master binaries from CI.
ClickHouse/ClickHouse
Generate PR descriptions for ClickHouse/ClickHouse that match maintainer expectations.
Works with
Categories
In-browser review of pending changes before committing or opening a PR. Diff Review is an agent skill from ClickHouse/ClickHouse. In-browser review of pending changes before committing or opening a PR.
Diff Review fits situations like: the user asks for a browser review of the changes.
Run `npx skills add ClickHouse/ClickHouse --skill diff-review -a claude-code`. Or copy the skill folder (.claude/skills/diff-review in ClickHouse/ClickHouse) into .claude/skills/diff-review in your project. Claude Code loads it when a task matches its description.
Run `npx skills add ClickHouse/ClickHouse --skill diff-review -a codex`. Or copy the skill folder (.claude/skills/diff-review in ClickHouse/ClickHouse) into .agents/skills/diff-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 ClickHouse/ClickHouse --skill diff-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/diff-review, .gemini/skills/diff-review, .github/skills/diff-review and .opencode/skills/diff-review in your project.
Going by SKILL.md and its folder, Diff Review needs JavaScript for the scripts in its folder and the command-line tools its instructions call (git, ssh and node). Our summary lists: Node.js.
SKILL.md contains no URLs. Its commands use git and ssh, which can reach the network depending on how they are called. 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.
Diff Review is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
About 1.3k tokens (SKILL.md is roughly 5.2k 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 Diff Review: Lancedb Update Lance Dependency (lancedb/lancedb, 12k stars), Find Postgres Bug (digoal/blog, 8.6k stars), Wtf (noobnooc/agent, 1.4k stars) and Notcrawl (openclaw/notcrawl, 134 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
ClickHouse (a GitHub organization) maintains it in ClickHouse/ClickHouse, which has 50,288 GitHub stars. The repository holds 24 skills in this directory. The repository was last updated on October 8, 2026.
Source: ClickHouse/ClickHouse on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.