Name: backend-queries
Author: aiskillstore

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 writing database queries in controllers, service classes, repositories, or model methods
When using query builder methods (where, select, join, orderBy, etc.)
When implementing eager loading to prevent N+1 query problems (with, load, etc.)
When optimizing queries by selecting only needed columns instead of using SELECT *
When implementing filtering, sorting, or pagination logic in queries
When writing complex queries with joins, subqueries, or aggregations
When wrapping multiple related database operations in transactions
When implementing query timeouts or performance optimization
When adding database indexes to improve query performance
When implementing query result caching strategies
When using raw queries or complex SQL (ensuring parameterization for security)
When debugging slow queries or performance issues

For details, refer to the information provided in this file: [backend queries](../../../agent-os/standards/backend/queries.md)

backend-queries