backend-queries
使用参数化查询、急切加载、适当索引和事务编写安全、高性能的数据库查询。在编写数据库查询代码、ORM查询方法、SQL语句或数据获取逻辑时使用此技能。在使用参数化查询防止SQL注入、优化查询以避免急切加载的N+1问题、选择特定列而不是SELECT *、为相关操作实现数据库事务、添加查询超时或缓存昂贵查询时使用此技能。在处理存储库文件、具有数据库访问权限的服务文件、查询构建器代码或任何从数据库检索或操作数据的文件时使用。
📖 中文导读:使用参数化查询、急切加载、适当索引和事务编写安全、高性能的数据库查询。在编写数据库查询代码、ORM查询方法、SQL语句或数据获取逻辑时使用此技能。在使用参数化查询防止SQL注入、优化查询以避免急切加载的N+1问题、选择特定列而不是SELECT *、为相关操作实现数据库事务、添加查询超时或缓存昂贵查询时使用此技能。在处理存储库文件、具有数据库访问权限的服务文件、查询构建器代码或任何从数据库检索或操作数据的文件时使用。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。
name: Backend Queries description: Write secure, performant database queries using parameterized queries, eager loading, proper indexing, and transactions. Use this skill when writing database query code, ORM query methods, SQL statements, or data fetching logic. Use this when preventing SQL injection with parameterized queries, optimizing queries to avoid N+1 problems with eager loading, selecting specific columns instead of SELECT *, implementing database transactions for related operations, adding query timeouts, or caching expensive queries. Use this when working on repository files, service files with database access, query builder code, or any file that retrieves or manipulates data from databases.
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 query code using ORM methods or query builders
- When creating repository pattern files that encapsulate data access logic
- When implementing service layer methods that fetch or manipulate database data
- When writing raw SQL queries or stored procedure calls
- When using parameterized queries to prevent SQL injection attacks
- When implementing eager loading or joins to avoid N+1 query problems
- When optimizing queries by selecting specific columns instead of using SELECT *
- When wrapping related database operations in transactions for consistency
- When adding indexes to columns used in WHERE, JOIN, or ORDER BY clauses
- When implementing query timeouts to prevent runaway queries
- When setting up caching strategies for frequently-run or expensive queries
Instructions
For details, refer to the information provided in this file: backend queries