Backend Queries

When to use this skill

• When writing database queries using ORM methods or raw SQL
• When implementing data fetching logic in controllers, services, or repositories
• When optimizing query performance or addressing slow database operations
• When using eager loading to prevent N+1 query problems
• When implementing filtering, sorting, or pagination for data sets
• When writing JOIN operations or querying related data
• When using parameterized queries to prevent SQL injection
• When implementing database transactions for related operations
• When adding query timeouts or performance monitoring
• When caching expensive or frequently-run queries
• When selecting specific columns instead of using SELECT *
• When creating database indexes to optimize query performance
• When refactoring queries for better efficiency or readability

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