Backend Queries

When to use this skill

• When writing Eloquent queries or using the query builder
• When writing raw SQL queries for complex operations
• When optimizing database performance and query execution time
• When preventing N+1 query problems with eager loading (with(), load())
• When implementing database transactions for data consistency
• When adding indexes to database columns for query optimization
• When caching frequently-run or expensive queries
• When selecting only needed columns instead of using SELECT *
• When implementing query timeouts to prevent runaway queries
• When working with WHERE, JOIN, or ORDER BY clauses
• When debugging slow database queries or performance issues
• When implementing pagination or filtering in API endpoints

This Skill provides Claude Code with specific guidance on how to adhere to coding standards as they relate to how it should handle backend queries.

Instructions

For details, refer to the information provided in this file: backend queries