backend-queries

majiayu000 的头像作者 majiayu000

遵循 SQL 注入预防、N+1 查询优化以及 PostgreSQL(Bun.sql、Prisma、Supabase)和 Firestore 性能的最佳实践编写高效、安全的数据库查询。在编写或修改数据库查询、实现数据获取逻辑、使用 ORM(Prisma、TypeORM、实体框架)、使用 Bun.sql 本机驱动程序、查询 Firestore 集合或实现缓存策略时,请使用此技能。在处理服务文件(services/*.ts、repositories/*.ts、*Service.cs)、查询生成器实现、数据访问层或任何获取或操作数据的代码时应用。此技能可确保参数化查询防止 SQL 注入(从不插入用户输入)、急切加载以防止 N+1 问题、选择性列提取(无 SELECT *)、WHERE/JOIN/ORDER BY 列上的策略索引、相关操作的事务、性能查询超时、缓存昂贵的查询、使用 Bun.sql 准备重复查询的语句以及查询驱动的 mod

📖 中文导读:遵循 SQL 注入预防、N+1 查询优化以及 PostgreSQL(Bun.sql、Prisma、Supabase)和 Firestore 性能的最佳实践编写高效、安全的数据库查询。在编写或修改数据库查询、实现数据获取逻辑、使用 ORM(Prisma、TypeORM、实体框架)、使用 Bun.sql 本机驱动程序、查询 Firestore 集合或实现缓存策略时,请使用此技能。在处理服务文件(services/*.ts、repositories/*.ts、*Service.cs)、查询生成器实现、数据访问层或任何获取或操作数据的代码时应用。此技能可确保参数化查询防止 SQL 注入(从不插入用户输入)、急切加载以防止 N+1 问题、选择性列提取(无 SELECT *)、WHERE/JOIN/ORDER BY 列上的策略索引、相关操作的事务、性能查询超时、缓存昂贵的查询、使用 Bun.sql 准备重复查询的语句以及查询驱动的 mod 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

name: Backend Queries description: Write efficient and secure database queries following best practices for SQL injection prevention, N+1 query optimization, and performance for PostgreSQL (Bun.sql, Prisma, Supabase) and Firestore. Use this skill when writing or modifying database queries, implementing data fetching logic, working with ORMs (Prisma, TypeORM, Entity Framework), using Bun.sql native driver, querying Firestore collections, or implementing caching strategies. Apply when working on service files (services/.ts, repositories/.ts, *Service.cs), query builder implementations, data access layers, or any code that fetches or manipulates data. This skill ensures parameterized queries to prevent SQL injection (never interpolate user input), eager loading to prevent N+1 problems, selective column fetching (no SELECT *), strategic indexing on WHERE/JOIN/ORDER BY columns, transactions for related operations, query timeouts for performance, caching expensive queries, prepared statements with Bun.sql for repeated queries, and query-driven modeling for Firestore to avoid complex OR queries.

Backend Queries

When to use this skill:

  • When writing new database queries or data fetching operations
  • When working with ORM query builders (Prisma, TypeORM, Sequelize, Entity Framework)
  • When using Bun.sql native PostgreSQL driver for high-performance queries
  • When implementing service layer methods that query databases
  • When working on repository pattern implementations
  • When writing raw SQL queries for complex operations
  • When optimizing slow queries or addressing N+1 query problems
  • When implementing eager loading or query joins
  • When adding database indexes to improve query performance
  • When wrapping related operations in database transactions
  • When implementing caching strategies for frequently-accessed data
  • When setting query timeouts to prevent long-running queries
  • When working on files that contain data access logic (services/.ts, repositories/.ts, Service.cs, models/.py)
  • When querying Firestore collections and designing queries based on data model
  • When using prepared statements for repeated queries in Bun.sql

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.

Instructions

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