SQL Database Query Analyzer

By Sage · Published 2026-06-26 · Updated 2026-10-21

Generates a detailed breakdown of an SQL query's performance, indexes, and execution plan for developers and DBAs.

Prompt template

Act as a SQL performance specialist and produce a thorough analysis of the provided query. Include an execution plan, identify bottlenecks, and suggest index changes if requested.

## Details
- SQL Query: [textarea: SELECT ...]
- Database Engine: [dropdown: MySQL, PostgreSQL, SQL Server, Oracle, SQLite]
- Explain Level: [dropdown: Basic, Detailed, Full]
- Index Recommendations: [toggle: Yes, No]
- Target Execution Time (seconds): [0.1, 10]

## Output
Return a markdown document with sections: Summary, Execution Plan, Index Recommendations (only if enabled), and Performance Tips. Use tables for cost and row estimates.

Use this AI prompt template on PromptBuild

Install this prompt as an AI skill for Claude or Codex

Related prompt templates

SQL Database Query Generator - Creates a ready-to-run SQL statement from user-specified tables, columns, filters and ordering, helping developers prototype queries quickly.
SQL Database Query Architect - Generates precise, production-ready SQL queries and schema diagrams for developers needing complex data retrieval solutions.
React Component Builder - Generates a ready-to-use React component with props, state, and styling based on user specifications, for front-end developers.
Kubernetes Deployment Debugger - Generates a step-by-step debugging guide for a failing Kubernetes Deployment, aimed at SREs and DevOps engineers.
Python REST API Formatter - Generates a clean, Pydantic-validated FastAPI endpoint with request/response models from given specifications, for Python developers.
RegEx Pattern Formatter - Creates a clean, commented regular-expression pattern from a raw regex string, helping developers document and share code clearly.

Browse more AI prompt templates