ClaudeSuperPower

perf-review

Skill

Performance impact assessment for items with the needs-perf-review trait. Evaluates hot paths, query patterns, and measurement plans. Invoked via skillPointer when filling performance-baseline notes.

Install

git clone https://github.com/jpicklyk/task-orchestrator.git ~/.claude/skills/perf-review

What is perf-review?

Performance impact assessment for items with the needs-perf-review trait. Evaluates hot paths, query patterns, and measurement plans. Invoked via skillPointer when filling performance-baseline notes.

What this can do

Capabilities declared in this component's own frontmatter — not inferred.

Inherit all session tools

Declares no tool restrictions — inherits every session tool

~50 tokens of context used while enabled, before you invoke anything

Documentation

README · ~2 min read

Performance Review Framework

Evaluate performance impact of changes. This project is a Kotlin MCP server with SQLite via Exposed ORM, handling tool calls synchronously per request.

Step 1: Hot Path Analysis

Identify which hot paths the change touches:

  • Per-request paths — MCP tool execution (every tool call hits this). New work here adds latency to every request.
  • Per-item loops — operations that iterate over items (search, overview, stalled-item detection). N+1 patterns here scale poorly.
  • Startup path — server initialization, database schema creation, config loading. Affects container startup time.
  • Background operations — cascade detection, dependency resolution. Runs inline, not async.

Step 2: Database Query Patterns

  • N+1 queries — does the change add a query inside a loop? (e.g., countChildrenByRole per child in overview). Count total queries for a typical operation.

Reviews

Log in to leave a review.

No reviews yet — be the first.

Explore related

Other things in this space — across every part of the ecosystem, not just skills.

Skillssimilar to this one

All skills