skills.rest
mikecubed
mikecubedCOMMUNITY
Explore all skills by this author →
GitHub

perf-check

Detect N+1 queries, unbounded loops, and missing pagination in code reviews.

Updated Mar 18, 2026
Search Tags:#performance#static-analysis#code-analysis#code-review#pagination#nplus1
One-click install
npx skills add https://github.com/mikecubed/agent-orchestration --skill perf-check-mikecubed
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: perf-check
Source: https://github.com/mikecubed/agent-orchestration/tree/main/plugins/ccc/skills/perf-check
Command: npx skills add https://github.com/mikecubed/agent-orchestration --skill perf-check-mikecubed

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Performance anti-patterns in code can degrade user experience; perf-check identifies N+1 queries, unbounded loops, and missing pagination during reviews.

Core Features & Use Cases

  • N+1 query detection: flags queries inside loops and suggests batching or prefetching.
  • Unbounded loop detection: flags loops without size guards or pagination.
  • Pagination enforcement: ensures endpoints include limit or page parameters.
  • Use Case: during code reviews, CI checks, and architecture assessments to surface performance risks.
  • Use Case: multi-language projects (TypeScript, Python, Go, Rust, JavaScript) across services and data access layers.

Quick Start

Run perf-check during reviews to automatically identify N+1 queries, unbounded loops, and missing pagination, and surface remediation guidance.

Frequently Asked Questions about perf-check

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

FAQPage Schema
How do I detect N+1 queries during code reviews?▼

To detect N+1 queries during code reviews, this Skill analyzes service, API, and data access layers to flag queries executed inside loops and suggests batching or prefetching remediation across TypeScript, Python, Go, Rust, and JavaScript projects.

What is the best way to enforce pagination requirements in API endpoints?▼

Enforcing pagination requirements in API endpoints relies on static analysis to verify that endpoints include limit or page parameters, surfacing missing pagination as an actionable performance risk during CI checks and architecture assessments.

Can I use static analysis to find unbounded loops in Python and Go projects?▼

Yes, static analysis finds unbounded loops in Python and Go projects by flagging loops without size guards or pagination, providing actionable remediation guidance to surface and resolve these performance risks during code reviews.

Does perf-check work with Rust and JavaScript codebases?▼

Yes, perf-check works with Rust and JavaScript codebases alongside TypeScript, Python, and Go, identifying performance anti-patterns across service, API, and data access layers in multi-language projects during reviews and CI checks.

Why does static code analysis fail to catch unbounded loops without size guards?▼

Static code analysis misses unbounded loops without size guards unless rules explicitly target loops missing pagination; applying performance-specific static analysis rules surfaces these risks by flagging iterations lacking boundary constraints during reviews.

Related Skills

Explore More Software Engineering Skills→
mlvpatelmlvpatel
1

code-reaper

Identify and remediate security weaknesses in source code via static analysis.

Community
Advanced
roycolumbia-coderoycolumbia-code

gsd-ship

Automates GitHub pull request creation, review triggering, and merge tracking.

Community
Intermediate
peopleforresterpeopleforrester
3

performance-reviewer

Identify performance bottlenecks across frontend, backend, and database code.

Community
Basic
cbemistercbemister

performance-check

Analyze code paths for N+1 queries, missing indexes, and transaction boundaries.

Community
Advanced