Backend Queries

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.

When to use this skill

• When writing SQL queries or ORM query methods to fetch or update data
• When implementing data retrieval logic in services, repositories, or data access layers
• When optimizing queries to avoid N+1 query problems (using eager loading, joins, or includes)
• When using WHERE clauses, JOIN operations, ORDER BY, or GROUP BY statements
• When selecting specific columns instead of using SELECT *
• When wrapping related database operations in transactions
• When implementing query timeouts or error handling for database calls
• When working with parameterized queries to prevent SQL injection
• When adding indexes to columns used in WHERE, JOIN, or ORDER BY
• When caching expensive or frequently-run query results

Instructions

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