performance_review_baseline

Identify performance bottlenecks in backend services with severity levels and output templates.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/denish12/codex-ai-agent-and-skills --skill performance-review-baseline
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: performance_review_baseline
Source: https://github.com/denish12/codex-ai-agent-and-skills/tree/main/locales/en/.agents/skills/performance_review_baseline
Command: npx skills add https://github.com/denish12/codex-ai-agent-and-skills --skill performance-review-baseline

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Performance baseline reviews help engineering teams quickly identify bottlenecks in data access and API paths, enabling targeted optimizations.

Core Features & Use Cases

  • N+1 query detection and remediation guidance
  • Pagination and batching optimization recommendations
  • Caching strategy evaluation across architectures
  • Use Case: when you have a large data-heavy endpoint, apply the baseline to surface DB and cache inefficiencies and propose concrete improvements.

Quick Start

Run a baseline performance audit on your backend to surface the top latency hotspots.

Frequently Asked Questions about performance_review_baseline

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

FAQPage Schema
How do I detect and fix N+1 queries in my backend API?

To detect N+1 queries, this baseline review analyzes your backend API paths and ORM data access patterns to identify repeated database calls causing latency, providing actionable remediation guidance.

What is the best way to audit backend caching strategy and pagination?

Auditing caching strategy and pagination requires a baseline review that evaluates cache architectures and pagination implementations to surface database inefficiencies and propose concrete latency optimizations.

How do I run a performance review to find latency hotspots in data-heavy endpoints?

Running a performance baseline audit on data-heavy endpoints surfaces top latency hotspots by evaluating query optimization, indexing, and caching decisions to identify and report backend performance bottlenecks.

Does this performance baseline analysis work with standard web backends and ORMs?

This performance baseline analysis targets typical web backends, ORMs, and API layers, evaluating query optimization, indexing, and caching decisions to identify bottlenecks impacting service latency.

What are common backend performance bottlenecks related to batching and indexing?

Common backend performance bottlenecks involve missing query batching, poor indexing, and inadequate cache strategy, which this baseline review identifies across API layers and reports with clear severity levels.