AgentSkillsCN

Backend Queries

使用参数化查询、急加载、战略性索引和恰当的事务管理编写优化且安全的数据库查询。在编写数据库查询、仓储方法或与SQL或NoSQL数据库交互的数据获取逻辑时使用此技能。在实施查询构建器、ORM查询方法、原始SQL查询或数据库服务函数时使用。在处理包含数据库访问代码的文件（repositories.ts、services.ts、queries.py、dao.java）、优化N+1查询问题、实施查询缓存策略或编写带有JOIN和WHERE子句的查询时使用。在防止SQL注入漏洞、设置查询超时或将相关操作包裹在数据库事务中时使用。

SKILL.md
--- frontmatter
name: Backend Queries
description: Write optimized and secure database queries using parameterized queries, eager loading, strategic indexing, and proper transaction management. Use this skill when writing database queries, repository methods, or data fetching logic that interacts with SQL or NoSQL databases. Use when implementing query builders, ORM query methods, raw SQL queries, or database service functions. Use when working with files containing database access code (repositories.ts, services.ts, queries.py, dao.java), when optimizing N+1 query problems, implementing query caching strategies, or writing queries with JOINs and WHERE clauses. Use when preventing SQL injection vulnerabilities, setting up query timeouts, or wrapping related operations in database transactions.

Backend Queries

This Skill provides Claude Code with specific guidance on how to adhere to coding standards for writing secure and optimized database queries.

When to use this skill

  • •When writing database query code in services, repositories, or data access layers
  • •When working with files containing database queries (services.ts, repositories.ts, queries.py, dao.java, etc.)
  • •When using query builders or ORM query methods (TypeORM QueryBuilder, Sequelize queries, SQLAlchemy queries)
  • •When writing raw SQL queries or stored procedure calls
  • •When optimizing N+1 query problems with eager loading or joins
  • •When selecting specific columns instead of using SELECT *
  • •When implementing query caching for expensive or frequent queries
  • •When wrapping related database operations in transactions
  • •When adding indexes to optimize WHERE, JOIN, or ORDER BY clauses
  • •When preventing SQL injection by using parameterized queries
  • •When setting query timeouts to prevent runaway queries
  • •When implementing pagination or data filtering logic

Instructions

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