php-performance-review

Audit PHP applications for N+1 queries, missing indexes, and caching gaps.

Updated Feb 5, 2026
One-click install
npx skills add https://github.com/benjaminhaeberli/claude-plugins --skill php-performance-review
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: php-performance-review
Source: https://github.com/benjaminhaeberli/claude-plugins/tree/main/skills/php/php-performance-review
Command: npx skills add https://github.com/benjaminhaeberli/claude-plugins --skill php-performance-review

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps developers uncover performance bottlenecks in PHP apps by providing a structured codebase audit that targets N+1 queries, missing indexes, caching gaps, and pagination issues.

Core Features & Use Cases

  • Structured PHP audit: Scans PHP/Laravel/Kirby apps for common performance pitfalls and generates actionable recommendations.
  • Checklist-driven analysis: Uses the included performance checklist to identify issues in SQL queries, ORM usage, caching, and frontend build interactions.
  • Use Cases: Ideal for optimizing Laravel apps, Kirby CMS sites, or vanilla PHP projects seeking faster response times and better scalability.

Quick Start

Run the audit on your PHP project to generate a comprehensive performance report and an actionable improvement plan.

Frequently Asked Questions about php-performance-review

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

FAQPage Schema
How do I audit my PHP application for performance bottlenecks?

To audit PHP performance, you need a structured codebase review that targets N+1 queries, missing indexes, caching gaps, and pagination issues. This approach scans your application to generate actionable optimization recommendations.

What is the best way to fix N+1 query problems in Laravel?

Fixing N+1 query problems in Laravel requires checking your ORM usage for eager loading and chunking. A performance audit identifies these specific query patterns and provides actionable recommendations to resolve them.

Does this PHP performance audit work with Kirby CMS and vanilla PHP?

Yes, the PHP performance audit works with Kirby CMS and vanilla PHP. It applies to PHP projects using Laravel, Kirby, or vanilla PHP during codebase reviews, performance tuning, and optimization planning.

How do I check if my PHP app is missing database indexes and caching?

You can check for missing indexes and caching by running a checklist-driven performance audit. This process identifies gaps in SQL queries, ORM usage, caching, and frontend build interactions to improve response times.

Why should I use a structured checklist for PHP performance tuning?

Using a structured checklist for PHP performance tuning ensures comprehensive detection of common pitfalls like N+1 queries, missing OPcache, and pagination issues. It enforces consistent checks to generate a reliable improvement plan.