river-review-performance

river-review-performance is a skill for Claude Code, Codex from s977043/river-review. It costs 49 tokens per session (1,836 once invoked), scanned A, original, MIT.

A performance-review guide for changes involving database queries, loops, batch jobs, caches, or large amounts of data.

In plain words
What is it for?
Use it to review code or SQL changes and route checks for query performance, memory efficiency, external API behavior, logging, monitoring, and service targets.
Why use it?
It directs review toward likely slowdowns such as repeated database calls, inefficient memory use, missing timeouts, and retry problems.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one.

Part of the river-review plugin — 138 skills, 18 commands, 5 agents, 3 hooks shipped together

Good fit Use it to review code or SQL changes and route checks for query performance, memory efficiency, external API behavior, logging, monitoring, and service targets.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/s977043/river-review/river-review-performance
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add s977043/river-review --skill river-review-performance
Clone the repo
git clone --depth 1 https://github.com/s977043/river-review

Made for: Claude Code, Codex.

Or install river-review, the plugin that ships this one along with the rest of its 138 skills, 18 commands, 5 agents, 3 hooks.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for river-review-performance

README.md
[![agentmods](https://agentmods.dev/badge/skills/s977043/river-review/river-review-performance/github.svg)](https://agentmods.dev/skills/s977043/river-review/river-review-performance)
Your own site
<a href="https://agentmods.dev/skills/s977043/river-review/river-review-performance"><img src="https://agentmods.dev/badge/skills/s977043/river-review/river-review-performance/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for river-review-performance

Your own site · 80×15
<a href="https://agentmods.dev/skills/s977043/river-review/river-review-performance"><img src="https://agentmods.dev/badge/skills/s977043/river-review/river-review-performance.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 49 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,836 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00049 $0.01836
Opus 5 $0.00024 $0.00918
Sonnet 5 $0.00010 $0.00367
Haiku 4.5 $0.00005 $0.00184

Measured 10d ago against content hash e78e651a6793, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-10, from the pricing page.

Security

Grade A, and why

river-review-performance scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 10d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/agent-skills/river-review-performance/SKILL.md · 137 lines

How it starts

The opening of the file, as written. The whole thing — 137 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Performance Review(パフォーマンスレビュー)

パフォーマンスに影響する変更を検出し、適切な個別スキルで検証する。

When to Use / いつ使うか

  • データベースクエリの追加・変更時
  • ループ処理やバッチ処理の変更時
  • キャッシュ戦略の変更時
  • 大量データの処理ロジック変更時

Routing / ルーティング

キーワード スキルID 説明
キャッシュ, TTL cache-strategy-consistency 参照のみ。実行は river-review-architecture理由
障害, 監視, メトリクス failure-modes-observability 障害モードと可観測性
ログ, トレース logging-observability ロギング・可観測性
SLO, レイテンシ operability-slo 運用性・SLO

cache-strategy-consistency の帰属について

cache-strategy-consistency はキャッシュ戦略という語感から performance の懸念に見えるが、実体は設計ドキュメント(docs/spec/RFC 等)のキャッシュ戦略記述をレビューする upstream スキル(applyTodocs/**/*.md 等の docs 系のみ、Pre-execution Gate も「差分に設計ドキュメントの変更がある」ことを要求)である。本エントリ(phase midstream、applyTo が code/sql)とはドメインが異なるため、ドメイン一貫性を優先し実行は river-review-architecture(phase upstream、docs 系 applyTo を保有)に据え置く。本表には到達性のための参照行として掲載するのみで、performance 側に重複するアクティブなキーワードルートは追加しない。

デフォルト動作

  • キーワード指定なし → 以下のヒューリスティクスで判定:
    • ループ内I/O → N+1クエリ検出
    • 大量データ処理 → メモリ効率チェック
    • 外部API呼び出し → タイムアウト・リトライ検証

Execution Flow / 実行フロー

1. 変更内容の分析
   ├─ ループ内I/O → N+1クエリ検出を優先
   ├─ 大量データ処理 → メモリ効率チェックを優先
   ├─ 外部API呼び出し → タイムアウト・リトライ検証を優先
   └─ キーワード指定あり → 該当スキルを直接選択

2. スキルの実行
   ├─ cache-strategy-consistency: キャッシュ戦略の一貫性
   ├─ failure-modes-observability: 障害モードと可観測性
   ├─ logging-observability: ロギング・可観測性
   └─ operability-slo: 運用性・SLO

3. 統合
   ├─ 重複する指摘の除去
   └─ Checklistに基づくパフォーマンスチェックの補完

Read the full file on GitHub · 137 lines

Files

What ships with it

1 file beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 10d ago First seen · 137 lines · 49 tokens per session scan A e78e651a6793

Subscribe to this mod's changes

river-review-performance is a skill published in the GitHub repository s977043/river-review (3 stars, last pushed today), licensed MIT. It adds 49 tokens to every session and 1,836 once invoked, about $0.0002 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.

Related

Other skills, from other repositories

review-all

Multi-agent code review for diffs (project-agnostic). Covers standards, bugs, security, DRY, smells, perf, tests, API contracts, a11y/i18n. Verifies each finding to eliminate false positives. Use for /review-all, pre-PR/pre-commit review, or auditing uncommitted/staged changes.

ncoevoet/claude-review-all · 74 tokens

logic-health

Sweep a directory, module, or full codebase for logic correctness and produce a scored health dashboard with systemic patterns. Trigger when the user requests a health view — "audit the whole codebase", "health check", "health overview", "logic health overview", "audit src/", "audit auth and payments modules", "where…

hyhmrright/logic-lens · 180 tokens

logic-diff

Compare two code versions for semantic equivalence via semi-formal tracing of both versions side-by-side. Trigger when the user shares a refactor, rewrite, migration, or A/B implementation and wants to confirm behavior is unchanged — "did I break anything", "is this equivalent", "are these equivalent", "semantically…

hyhmrright/logic-lens · 192 tokens

omnicheck-gitlab

Use when checking if MR review findings have been applied — verifies both OmniForge-generated and human reviewer comments against the current diff, posts nudge replies on unaddressed threads.

nexiouscaliver/OmniForge · 41 tokens

omnicheck-github

Use when checking if PR review findings have been applied — verifies both OmniForge-generated and human reviewer comments against the current diff, posts nudge replies on unaddressed threads.

nexiouscaliver/OmniForge · 40 tokens

omnicreate-gitlab

Use when creating a GitLab merge request (OmniForge). Auto-populates title and description from commits, supports draft MRs, labels, assignees, reviewers, and issue linking.

nexiouscaliver/OmniForge · 45 tokens