Detect N+1 database queries in Laravel Blade and Livewire files.
npx skills add https://github.com/edulazaro/laraclaude --skill lc-find-n-plus-one
Please help me install this Agent Skill. Skill: lc:find-n-plus-one Source: https://github.com/edulazaro/laraclaude/tree/main/skills/find-n-plus-one Command: npx skills add https://github.com/edulazaro/laraclaude --skill lc-find-n-plus-one
This skill identifies and resolves N+1 query performance issues where database relationships are accessed inside loops without eager loading, which can cause significant application slowdowns.
Use the lc:find-n-plus-one skill to scan the entire project for N+1 query problems and report the findings.
High-intent search queries and answers about installing and using this skill.
To fix Laravel N+1 query problems, scan Blade views, Livewire components, and Eloquent controllers to detect relationship access inside loops. It suggests or applies with() eager loading to optimize database queries and resolve the bottlenecks.
N+1 database query bottlenecks occur when relationships are accessed inside loops without eager loading, triggering individual queries for each item. This causes significant application slowdowns when displaying lists with related Eloquent data.
Yes, N+1 query detection works with Livewire components and Blade templates. It scans these view files alongside Eloquent controllers to find inefficient relationship access patterns and suggests applying with() eager loading optimizations.
The best way to optimize Eloquent relationship loading in loops is to use eager loading. By applying with() or load() clauses to your queries, you fetch all related data in a single additional query instead of querying individually for each item in the loop.
Your Laravel application is likely slow due to N+1 query bottlenecks where database relationships are accessed inside loops without eager loading. Scanning your Eloquent controllers and Blade views can detect missing with() clauses causing the performance bottleneck.
relaticleEnforce Spatie's Laravel and PHP coding standards across Laravel code and Blade templates.
doanchienthangdevRun load, stress, and benchmark tests with k6 and Node.js profilers.
wmeintsWrite parameterized database queries with eager loading to prevent SQL injection and N+1 problems.
fatihkanDetect PHP security anti-patterns and vulnerabilities in Laravel, WordPress, and general projects.
