Skip to main content
CodingDatabase & SQLintermediate

SQL Query Performance Optimizer & Index Explainer

Optimized for Claude, Chatgpt • Verified Prompt Template

Analyze slow SQL queries, explain EXPLAIN ANALYZE bottlenecks, and suggest optimal B-tree or partial indexes.

Compatibility & Specs

Compatible AI Models
ClaudeChatGPT
Last UpdatedMar 27, 2026
Customizable Variables3 parameters

How to Use This Prompt

Follow this 3-step workflow to extract high-signal responses from any compatible AI model.

01

1. Tailor the Parameters

Use the interactive customizer above to substitute the bracketed placeholders with your exact context, requirements, and constraints.

02

2. Send to AI Model

Copy the prompt and paste it into Claude, ChatGPT, Gemini, or Copilot. These models follow structured multi-step constraints reliably.

03

3. Review and Iterate

Review the output against the verified benchmark below. Follow up in the conversation to stress-test edge cases or refine tone.

Prompt Variables & Parameters

Reference breakdown of every dynamic variable embedded in this prompt template.

PlaceholderParameter NameTypeStatusDescription & Guidance
[db_engine]Database EngineselectRequiredPostgreSQL, MySQL, SQLite, SnowflakeDefault: PostgreSQL 15/16
[slow_query]Slow QuerytextareaRequiredPaste your existing slow SQL queryDefault: SELECT o.id, o.created_at, u.email, COUNT(i.id) as item_count FROM orders o JOIN users u ON u.id = o.user_id LEFT JOIN order_items i ON i.order_id = o.id WHERE o.status = 'completed' AND o.created_at >= NOW() - INTERVAL '30 days' GROUP BY o.id, o.created_at, u.email ORDER BY o.created_at DESC LIMIT 50;
[table_schemas]Table Schemas & Row CountstextareaOptionalApproximate row counts and existing indexesDefault: orders table has 8M rows; order_items has 32M rows; users has 1.2M rows. Current index is only primary keys on id.

Example Output & Parameters Breakdown

Inspect verified benchmark AI responses and review how parameters, system constraints, and input variables calibrate generation.

Parameters & Variable Breakdown

3 Inputs
[db_engine]
PostgreSQL 15/16
[slow_query]
SELECT o.id, o.created_at, u.email ...
[table_schemas]
orders: 8M rows, order_items: 32M rows...

Verified AI Benchmark Response

Grounded Output
### 1. Bottleneck Diagnosis - **Sequential Table Scan**: Without an index on `orders(status, created_at)`, PostgreSQL must scan all 8 million rows to filter for 'completed' orders in the last 30 days. - **Unindexed Join**: Joining 32M `order_items` without a foreign key index on `order_items(order_id)` forces a massive hash join. ### 2. Required Index DDL ```sql -- Composite partial index for the exact WHERE + ORDER BY filter CREATE INDEX idx_orders_status_created_at ON orders (created_at DESC) WHERE status = 'completed'; -- Foreign key index on items CREATE INDEX idx_order_items_order_id ON order_items (order_id); ```

Best Use Cases

Scenarios and roles where this prompt produces maximum leverage.

Backend developers troubleshooting high p99 API latencies
Database administrators maintaining multi-million row production databases

Tips for Best Results

Techniques to elevate response fidelity

  • •Provide rich background context rather than one-sentence inputs to receive deep, non-generic responses.
  • •Engage in multi-turn conversation: use the initial output as a baseline, then ask the AI to sharpen specific sections.
  • •Prompt the model to highlight any hidden assumptions or missing trade-offs in its recommendations.

Common Mistakes to Avoid

Frequent failure modes and anti-patterns

  • •Giving minimal context and expecting nuanced, expert-level strategic output.
  • •Not validating factual references, citations, or statistical claims with verified primary sources.
  • •Skipping the customization step and pasting raw bracketed template variables into the AI chat.

Frequently Asked Questions About This Prompt

Technical guidance on model compatibility, parameter substitution, iteration techniques, and commercial usage.

Q1.Which AI models work best with the "SQL Query Performance Optimizer & Index Explainer" prompt?

This prompt is thoroughly tested and compatible with Claude, Chatgpt. For multi-step reasoning, architectural planning, and code refactoring, Claude 3.7/3.5 Sonnet and ChatGPT-4o provide the highest constraint adherence. For large-document synthesis, Google Gemini 2.5 Pro is also recommended.

Q2.How do I customize the parameters in this prompt template?

This template features 3 customizable parameter(s): [db_engine], [slow_query], [table_schemas]. Replace each bracketed placeholder with your project's specific details, constraints, or code before submitting to your AI model. You can also use our interactive workbench on this page to populate and copy the completed prompt in one click.

Q3.Can I use this prompt and its outputs for commercial projects?

Yes. All prompts published on Beautiful AI Prompt are 100% free for both personal and commercial use. You hold full ownership of all code, copy, strategies, or imagery generated by your selected AI model when running this prompt.

Q4.How does this prompt prevent AI hallucinations and ensure output accuracy?

This template enforces explicit negative constraints, few-shot parameter boundaries, and schema requirements (such as tabular comparisons or step-by-step logic). This suppresses speculative drift and forces the AI model to ground its response in your provided inputs.

Related AI Prompts

Complementary workflows in Coding

View all Coding prompts
Codingadvanced

Principal Code Reviewer & Architecture Auditor

Conduct rigorous architectural code reviews identifying memory leaks, race conditions, and typing holes.

[Copy & Paste Template]4 parameters

›You are a Principal Software Architect conducting an uncompromising production code review. Programming Language & Stack: [language_stack] Primary Objective: [primary_objective] Target Strictness: [strictness_level] Code to review: ``` [code_to_review] ``` Deliver your review in this structured format: 1. Executive Summary: 2-sentence verdict on production-readiness. 2. Critical Vulnerabilities & Bugs: Race conditions, unhandled exceptions, memory leaks, security flaws (OWASP), or type unsafety. 3. Architecture & Separation of Concerns: Assess coupling, cohesion, testability, and state management. 4. Complete Before & After Refactoring: Rewrite the code adhering to clean architecture, full typing, and explicit error handling. 5. Performance & Complexity Analysis: Big-O time and space delta between original and refactored versions.

claudechatgptcopilot
#code-review#clean-code#architecture
JavaScriptintermediate

TypeScript Strict Type Refactoring Wizard

Eliminate 'any', unsafe type assertions, and type narrowing gaps with pure discriminated unions.

[Copy & Paste Template]1 parameters

›You are an elite TypeScript Compiler & Type System Architect. Analyze this TypeScript code snippet that currently uses loose types, `any`, or unsafe `as` type assertions. Code to refactor: ```typescript [loose_typescript_code] ``` Requirements: 1. Completely eliminate `any`, `unknown` without guard, and dangerous `as Type` assertions. 2. Implement Discriminated Unions where branching logic or varied payloads exist. 3. Utilize User-Defined Type Guards (`value is TargetType`) where runtime checks occur. 4. Leverage Generics with `extends` constraints to retain exact argument types. 5. Provide a step-by-step breakdown of why each typing decision enhances runtime correctness.

claudechatgptcopilot
#typescript#type-safety#discriminated-unions
Next.jsintermediate

Next.js App Router Performance & Cache Auditor

Audit Next.js routes for static pre-rendering, cache invalidation, and Core Web Vitals optimization.

[Copy & Paste Template]3 parameters

›You are a Next.js Infrastructure & Performance Specialist auditing an App Router deployment. Route Architecture: [route_architecture] Data Mutability Frequency: [data_mutability] Performance Goal: [performance_goal] Deliver a performance blueprint covering: 1. Static vs. Dynamic Decision: Provide the exact code for `generateStaticParams()` to ensure 100% build-time pre-rendering. 2. Caching Strategy: Define the interplay between the Next.js Data Cache, Full Route Cache, and Router Cache. 3. Core Web Vitals Optimization: Actionable instructions to reduce LCP < 1.0s and ensure Cumulative Layout Shift (CLS) = 0.00. 4. Asynchronous Request APIs (Next.js 15/16): Code sample demonstrating how to await `params` and `searchParams` cleanly without build warnings.

claudechatgptperplexity
#nextjs#turbopack#caching

Related Engineering Guides

Deep-dive playbooks and system prompt methodologies for Coding

View all guides