| name | Backend Queries |
| description | Write efficient, secure database queries following best practices for SQL injection prevention, performance optimization, and data fetching strategies. Use this skill when writing database queries, building query logic, or optimizing data retrieval code. Apply when working with SQL query files, ORM query builder code, raw SQL strings, query optimization, database access layers, repository pattern implementations, or any code that retrieves or manipulates data from databases. Use when implementing parameterized queries, eager loading relationships to prevent N+1 queries, selecting specific columns, creating database indexes, implementing query timeouts, using transactions for data consistency, or caching expensive queries. Apply when optimizing database performance, preventing SQL injection vulnerabilities, or refactoring inefficient data access patterns. |
When to use this skill:
- When writing database queries using SQL, query builders, or ORM methods
- When working with repository files, data access layers, or query logic
- When implementing parameterized queries to prevent SQL injection
- When optimizing queries to avoid N+1 query problems with eager loading
- When selecting specific columns instead of fetching all data
- When creating or optimizing database indexes for query performance
- When implementing transactions for related database operations
- When setting up query timeouts to prevent runaway queries
- When caching frequently-executed or expensive queries
- When refactoring inefficient data fetching patterns
- When joining tables or loading related data efficiently
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.
Instructions
For details, refer to the information provided in this file: backend queries