| name | Backend Queries |
| description | Write secure, optimized database queries using parameterized statements, proper indexing, and efficient data fetching patterns. Use this skill when writing database queries, ORM query methods, SQL statements, or data access layer code. When working on files containing Prisma queries, TypeORM query builders, raw SQL statements, database transaction logic, eager loading and joins, query optimization code, files implementing data pagination or filtering, cache strategies for expensive queries, or files handling database connection pooling and query timeouts. |
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 database queries using ORMs (Prisma, TypeORM, Drizzle, Sequelize)
- When constructing raw SQL queries or parameterized statements
- When implementing data fetching logic in API routes or server components
- When using query builders or constructing complex WHERE clauses
- When implementing pagination, filtering, sorting, or search functionality
- When writing JOIN queries or eager loading related data to avoid N+1 problems
- When implementing database transactions for data consistency
- When optimizing slow queries or adding query performance monitoring
- When setting up query caching strategies or read replicas
- When implementing query timeouts or connection pooling configurations
Instructions
For details, refer to the information provided in this file: backend queries