---

name: Backend Queries description: Write secure, performant database queries following best practices for data retrieval and manipulation. Use this skill when writing SQL queries, ORM query methods, or database query builders. Use this skill when fetching data with joins, filters, or complex query conditions. Use this skill when implementing eager loading to prevent N+1 query problems. Use this skill when optimizing query performance with proper indexing strategies. Use this skill when writing parameterized queries to prevent SQL injection. Use this skill when implementing database transactions for related operations. Use this skill when working with query optimization, caching strategies, or query timeout handling.

Backend Queries

When to use this skill

• When writing SQL queries or ORM query methods
• When fetching related data using joins or eager loading
• When implementing filtering, sorting, or search functionality
• When optimizing queries to prevent N+1 query problems
• When using parameterized queries to prevent SQL injection
• When implementing database transactions for consistency
• When selecting specific columns instead of using SELECT *
• When adding query timeouts to prevent runaway queries
• When implementing query result caching for expensive operations
• When working with query builders or repository pattern implementations

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