Database Query Optimizer

Optimize database performance with this AI prompt, targeting N+1 query issues and enhancing query efficiency.

What this prompt does

  • Maps all database calls in the code to identify inefficiencies.
  • Analyzes query patterns and data relationships for optimization opportunities.
  • Prioritizes solutions based on performance gain versus implementation effort.

How to use this prompt

  1. Run the full prompt and answer the questions as detailed as possible.
  2. Example: "My code with database calls: SELECT * FROM users WHERE id = ?; My data relationships: Users have many posts and comments."

Premium prompt — included in the Complete AI Bundle. Part of the Coding prompts collection in the God of Prompt library.

Related Coding prompts