backend-queries

使用参数化查询、预加载、适当的索引和事务管理编写安全、高性能且优化的数据库查询。在控制器、存储库、服务或模型方法中编写数据库查询时使用此技能；在使用查询构建器或ORM方法时；在实现过滤/排序/分页逻辑时；在通过预加载优化N+1查询问题时；在处理连接和复杂查询时；在实现查询缓存时；或在将相关操作包装到数据库事务中时。

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 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

Instructions

For details, refer to the information provided in this file: backend queries