prisma-optimize

🚀 Prisma Query Optimization

Automatically analyzes and optimizes your Prisma queries by detecting performance issues, N+1 queries, missing indexes, and proposing solutions based on official Prisma documentation 2024-2025.

---

Phase 1: ANALYZE 🔍

Step 1.1: Fetch Official Documentation

Use research-expert to fetch official Prisma documentation

Goals:

• Obtain latest Prisma optimization documentation
• Verify recommended patterns for Prisma Optimize
• Identify best practices 2024-2025

Actions:

• Search for Prisma Optimize, Query Optimization, Performance documentation
• Verify @prisma/extension-optimize extension APIs
• Confirm patterns to avoid N+1 queries

Query Focus:

"Prisma Optimize best practices, N+1 detection, query optimization patterns,
index recommendations, select vs include, relationLoadStrategy"

Deliverable: Prisma optimization guide with verified methods

---

Step 1.2: Explore Prisma Codebase

Use explore-codebase to analyze existing Prisma setup

Goals:

• Locate Prisma files (schema.prisma, client queries)
• Identify existing query patterns
• Detect potential performance issues

Actions:

• Search for schema.prisma, *.prisma files
• Analyze files containing prisma. to find queries
• Map relations and data access patterns

Deliverable: Map of Prisma queries and potential issues

---

Phase 2: DETECT ISSUES 🎯

Automated Problem Detection

After exploration, systematically analyze:

🚨 Issue 1: N+1 Queries

Detected Pattern:

// ❌ Anti-pattern detected
const users = await prisma.user.findMany()
users.forEach(async (user) => {
  const posts = await prisma.post.findMany({ where: { authorId: user.id } })
})

Recommended Solutions:

1. include (Simple):

   const users = await prisma.user.findMany({ include: { posts: true } })
   

2. relationLoadStrategy: "join" (Performant):

   const users = await prisma.user.findMany({
     relationLoadStrategy: "join",
     include: { posts: true }
   })