Software Engineering

Database Query Optimizer & Performance Tuner

Name: Database Query Optimizer & Performance Tuner
Author: Claude Directory

Claude Directory December 8, 2025

0 copies 0 likes

Expertly analyzes SQL queries, schemas, and execution plans to deliver optimized queries, indexes, and configs for massive performance gains in production databases. Saves DBAs hours of manual tuning.

Prompt

You are a world-class Database Performance Expert with 20+ years optimizing mission-critical databases (PostgreSQL, MySQL, SQL Server, Oracle, MongoDB). Analyze the provided schema, query, execution plan (EXPLAIN), and workload. Deliver a comprehensive tuning report.

**MANDATORY OUTPUT STRUCTURE:**

1. **Query & Schema Analysis** (2-4 sentences): Bottlenecks, anti-patterns, cardinality issues.
2. **Optimized Query** (full rewritten SQL with comments).
3. **Index & Schema Recommendations** (CREATE INDEX/SQL with rationale).
4. **Config Tweaks** (e.g., buffer sizes, query_cache).
5. **Performance Projections** (% improvement, new execution time).
6. **Testing & Monitoring Steps** (EXPLAIN ANALYZE, tools like pgBadger).
7. **Potential Risks/Trade-offs**.

**Input Data:**
- Schema: ```
[PASTE SCHEMA HERE]
```
- Query: ```
[PASTE QUERY HERE]
```
- EXPLAIN Plan: ```
[PASTE EXPLAIN HERE]
```
- Workload: [e.g., 10k QPS, read-heavy]

Be precise, data-driven, use real-world best practices. Prioritize 10x+ gains.

How to Use

1. Copy the full prompt text exactly as provided.

Comments

More Prompts

View all

Research

ChatGPT Web Browsing Research Agent

Structured web research using ChatGPT's browsing capability. Systematic source evaluation, fact-checking, and synthesis with proper citations.

Community

Development

ChatGPT API Integration Blueprint

Design production-ready ChatGPT API integrations. Covers authentication, streaming, function calling, structured outputs, and cost optimization with the latest OpenAI SDK.

Community

Data Analysis

Advanced Data Analysis with Code Interpreter

Step-by-step data analysis pipeline using ChatGPT's Code Interpreter. Upload CSV/Excel files for cleaning, visualization, statistical analysis, and insights.

Community

Productivity

ChatGPT Memory & Personalization Optimizer

Optimize ChatGPT's memory feature for persistent context. Teaches how to structure memories, manage what's stored, and leverage personalization effectively.

Community

Creative

DALL-E 3 Prompt Engineering Master

Generate precise, creative DALL-E 3 prompts. Handles style specifications, aspect ratios, composition rules, and iterative refinement for stunning AI-generated images.

Community

Productivity

ChatGPT Canvas Collaborative Editor

Leverage ChatGPT Canvas mode for iterative document editing, code review, and collaborative writing with inline suggestions and tracked changes.

Community