# Prisma Query Optimizer

> Query optimization and N+1 detection

- Skill: `majiayu000/prisma-query-optimizer-2` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add majiayu000/prisma-query-optimizer-2`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/prisma-query-optimizer-2/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-22
- Page: https://skillmd.com/skills/majiayu000/prisma-query-optimizer-2

---


# 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