AgentSkillsCN

Backend Queries

使用参数化语句、恰当的索引设计，以及高效的取数模式，编写安全且优化的数据库查询。在编写数据库查询、ORM查询方法、SQL语句，或数据访问层代码时使用此技能。在处理包含Prisma查询、TypeORM查询构建器、原始SQL语句、数据库事务逻辑、急加载与联结、查询优化代码、实现数据分页或筛选的文件，或为昂贵查询设计缓存策略，以及处理数据库连接池与查询超时的文件时使用此技能。

SKILL.md
--- frontmatter
name: Backend Queries
description: Write secure, optimized database queries using parameterized statements, proper indexing, and efficient data fetching patterns. Use this skill when writing database queries, ORM query methods, SQL statements, or data access layer code. When working on files containing Prisma queries, TypeORM query builders, raw SQL statements, database transaction logic, eager loading and joins, query optimization code, files implementing data pagination or filtering, cache strategies for expensive queries, or files handling database connection pooling and query timeouts.

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 using ORMs (Prisma, TypeORM, Drizzle, Sequelize)
  • •When constructing raw SQL queries or parameterized statements
  • •When implementing data fetching logic in API routes or server components
  • •When using query builders or constructing complex WHERE clauses
  • •When implementing pagination, filtering, sorting, or search functionality
  • •When writing JOIN queries or eager loading related data to avoid N+1 problems
  • •When implementing database transactions for data consistency
  • •When optimizing slow queries or adding query performance monitoring
  • •When setting up query caching strategies or read replicas
  • •When implementing query timeouts or connection pooling configurations

Instructions

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