Agent-Skills.md

Agent Skills: Eager Loading and N+1 Prevention

Prevent N+1 queries by eager loading; enable lazy-loading protection in non-production; choose selective fields

UncategorizedID: noartem/laravel-vue-skills/laravel-performance-eager-loading
6

Install this agent skill to your local

pnpm dlx add-skill https://github.com/noartem/skills/tree/HEAD/skills/laravel-performance-eager-loading

Skill Files

Browse the full folder contents for laravel-performance-eager-loading.

Download Skill

Loading file tree…

skills/laravel-performance-eager-loading/SKILL.md

Skill Metadata

Name
laravel-performance-eager-loading
Description
Prevent N+1 queries by eager loading; enable lazy-loading protection in non-production; choose selective fields

Eager Loading and N+1 Prevention

Load Relations Explicitly

Post::with(['author', 'comments'])->paginate();
  • Use load()/loadMissing() after fetching models when needed
  • Select only required columns for both base query and relations

Guard Against Lazy Loading in Dev/Test

Add to a service provider (non-production):

Model::preventLazyLoading(! app()->isProduction());

Verify

  • Use a query logger or debugbar to confirm relation queries are minimized
  • Add tests that assert counts or avoid unexpected query spikes