0007-eloquent-best-practices

What problem does it solve?

It solves slow and inefficient Laravel Eloquent performance caused by common ORM anti-patterns like N+1 queries, over-fetching data, and missing indexes.

Core Features & Use Cases

• Query optimization: Eager loading, selecting only needed columns, reusable query scopes, and chunking/lazy processing for large datasets (e.g., rendering feeds without degrading response times).
• Relationship correctness: Clear relationship method return types and efficient count loading with withCount to avoid per-model extra queries (e.g., showing post comment counts in listings).
• Production safety and maintainability: Mass assignment protection via fillable/guarded, type-safe casts, database-level updates/increments, sensible model events, and preventing lazy loading in development (e.g., reducing accidental data bugs and performance regressions).

Quick Start

Ask the AI to review your Laravel Eloquent models and queries and rewrite them to eliminate N+1 issues, reduce selected columns, and add withCount/with eager loading where appropriate.