Can it detect N+1 query issues automatically?

Yes, the skill is designed to search the codebase for relationships accessed in loops without eager loading and other inefficient query patterns.

What does the audit report include?

The report includes a global performance score, a categorized checklist of results, identified bottlenecks, and a detailed action plan with tasks broken down into 2-4 hour intervals.

Does this skill perform runtime profiling?

No, this is a static code audit tool. It identifies patterns in the code that cause performance issues and recommends runtime tools like Laravel Debugbar or Blackfire for further analysis.

Which PHP frameworks does this skill support?

This skill is specialized for PHP, Laravel, Kirby CMS, Livewire, and Blade applications, including those using Vite and Tailwind CSS.

PHP Performance Audit

Name: PHP Performance Audit
Author: benjaminhaeberli

bybenjaminhaeberli

0•

Database Management

Analyzes PHP, Laravel, and Kirby applications to identify performance bottlenecks, database inefficiencies, and optimization opportunities.

This skill provides a comprehensive framework for conducting static performance reviews of PHP-based web applications, specifically optimized for modern stacks like Laravel and Kirby CMS. It systematically scans codebases for common architectural and implementation issues such as N+1 query patterns, missing database indexes, inefficient Eloquent usage, and unoptimized Livewire components. By generating a structured report and a prioritized action plan, it empowers developers to transform abstract performance concerns into actionable, time-estimated tasks that significantly improve application responsiveness and scalability.

Key Features

01Analysis of caching strategies including OPcache, route, and config caching

02Prioritized action plans with specific time estimates for critical and high-impact fixes

030 GitHub stars

04Identification of unoptimized Livewire components and frontend asset pipelines

05Detection of N+1 query patterns and inefficient database interactions

06Automated generation of detailed Markdown audit reports with global performance scores

Use Cases

01Resolving slow page load times in legacy Laravel applications

02Optimizing database performance by identifying missing indexes and redundant queries

03Conducting pre-deployment performance checks for Kirby CMS projects

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add benjaminhaeberli/claude-plugins php-performance-audit

For use in Claude.ai and ChatGPT

Download Skill