prisma-query-optimizer

databayt 的头像作者 databayt

查询优化和N+1检测

📖 中文导读:查询优化和N+1检测 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

name: Prisma Query Optimizer description: Query optimization and N+1 detection version: 1.0.0 category: database

Prisma Query Optimization Skill

N+1 Detection

Bad: Loop with queries Good: Include relations

Optimization

  • Select specific fields
  • Add indexes
  • Use pagination

Checklist

  • No N+1 queries
  • Indexes on foreign keys
  • Select only needed fields