nocode_explorerNo-code Explorer
Posted on 6/12/2026
Optimize this SQL/Prisma query for performance
Architecture#SQL#Prisma#Performance#Database
Use Case
Identify N+1 queries, missing indexes, and unoptimized join operations to speed up database queries.
Prompt Template
Analyze the following database query or Prisma client call: [paste query/code]. The query is currently slow in production under high loads. Please: 1. Identify bottlenecks such as N+1 query patterns, missing index fields, or unnecessary selecting of large fields (like text bodies). 2. Provide the optimized Prisma query using select/include filters, pagination, or raw SQL. 3. Suggest exactly which SQL indexes (CREATE INDEX commands) should be added to the schema.
Effect & Tips
Crucial for scaling applications when data sizes grow.