audit-perf

Audit TanStack Start routes for static performance anti-patterns with ranked fixes.

22|3|Updated Jul 28, 2024
One-click install
npx skills add https://github.com/webdevcody/go-mailing-list --skill audit-perf-webdevcody
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: audit-perf
Source: https://github.com/webdevcody/go-mailing-list/tree/main/.claude/skills/audit-perf
Command: npx skills add https://github.com/webdevcody/go-mailing-list --skill audit-perf-webdevcody

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you identify likely performance bottlenecks in a specific route/page/module by flagging common scalability issues such as N+1 database queries, missing indexes on filtered/joined columns, oversized fetches, sequential awaits, and server-only code leaking into client bundles.

Core Features & Use Cases

  • Static performance pattern scanning: Detects high-signal patterns (e.g., N+1 query shapes, unbounded selects, missing indexes) by reading the code rather than running benchmarks.
  • Evidence-backed findings: Every finding includes a precise file:line location plus a concrete, code-level fix.
  • Triage to reduce noise: Filters out false positives and reframes impacts in concrete terms like “N additional DB roundtrips per request” or “full-table scan as the table grows.”
  • No auto-fixing: Reports issues only; you apply fixes with full control over tradeoffs.

Use cases: auditing a specific “slow page” in a TanStack Start/React app, reviewing a route loader/server-fn data path for DB/query inefficiencies, and checking bundle risks from server-only imports.

Quick Start

Ask for a performance audit of a specific slow entry point by saying: “audit perf for the dashboard route.”

Frequently Asked Questions about audit-perf

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I statically detect N+1 queries and missing indexes in my TanStack Start routes?

Static performance auditing detects N+1 queries and missing indexes by scanning route entry points and imports two layers deep. It identifies database bottlenecks by reading code structure, producing evidence line references and ranked fixes without running benchmarks.

What is the best way to find server-only code leaking into client bundles?

To find server-only client leakage, audit the module's import paths to identify server-only code leaking into client bundles. The scanner checks import boundaries and reports bundle risks with precise file and line locations for targeted removal.

How do I audit a slow page loader for sequential awaits and SELECT * over-fetching?

Auditing a slow page loader reviews server function data paths to flag sequential awaits and SELECT * over-fetching. It reframes impacts concretely, such as identifying N additional database roundtrips per request, and provides code-level fixes.

Can I use static analysis to find unbounded selects and synchronous I/O in my server functions?

Static analysis can find unbounded selects and synchronous I/O in server functions by reading the code. It scans data-loading and render paths to detect these performance anti-patterns and filters false positives to reduce noise.

Does this performance audit automatically apply fixes to my database optimization issues?

This performance audit does not automatically apply fixes to database optimization issues. It reports performance anti-patterns with evidence and ranked solutions, leaving you to apply fixes with full control over tradeoffs.