backend-queries

# Backend Queries ## When to use this skill - When writing database queries in any file that interacts with the database - When constructing SQL statements or using ORM query builders (Prisma, Sequelize, ActiveRecord, etc.) - When preventing SQL injection by using parameterized queries - When optimizing queries to avoid N+1 query problems (use eager loading or joins) - When selecting only needed columns instead of using SELECT * or fetching all fields - When adding indexes to columns used in WHERE, JOIN, or ORDER BY clauses - When implementing database transactions for related operations - When setting query timeouts to prevent runaway queries - When caching results of complex or frequently-run queries - When writing JOIN operations to fetch related data efficiently - When implementing pagination, filtering, or sorting with query parameters - When reviewing query performance and optimization opportunities 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](../../../agent-os/standards/backend/queries.md)