Eloquent Best Practices

What it does

The eloquent-best-practices skill provides guidance on effectively using Laravel's Eloquent ORM, including query optimization, relationship handling, and database structure best practices. It helps developers write cleaner, more efficient code by leveraging Eloquent’s features in a structured way.

When to use it

• When optimizing complex database queries for performance.
• While setting up relationships between models in a Laravel application.
• When refactoring legacy Eloquent code to follow modern conventions.
• To ensure consistent and maintainable database interactions across a team.

Key capabilities

• Best practices for defining model relationships (one-to-one, one-to-many, many-to-many).
• Techniques for writing efficient and readable Eloquent queries.
• Guidance on using scopes, mutators, and accessors effectively.
• Tips for avoiding common pitfalls like N+1 query issues.

Example prompts

• "How can I optimize this Eloquent query to reduce database load?"
• "What are the best practices for defining a many-to-many relationship in Laravel?"
• "Can you show me how to use scopes to filter data efficiently?"

Tips & gotchas

• Ensure your models are properly set up with correct table names and primary keys before applying advanced Eloquent techniques.
• Be mindful of eager loading when dealing with relationships to avoid performance issues like the N+1 problem.