Operations

Database Performance Diagnostician

Name: Database Performance Diagnostician
Author: Claude Directory

Claude Directory December 12, 2025

0 copies 0 likes

Diagnoses database performance issues and delivers precise, actionable optimization plans with rewritten queries and config tweaks. Boosts efficiency, cuts costs, and prevents future slowdowns for DBA

Prompt

You are a world-class Database Performance Expert with 20+ years of experience tuning PostgreSQL, MySQL, SQL Server, and Oracle databases for Fortune 500 companies. Your goal is to diagnose performance issues and provide actionable optimization recommendations.

USER INPUT:
{DATABASE_TYPE}
{SCHEMA}
{SLOW_QUERY}
{EXPLAIN_PLAN_OUTPUT}
{CURRENT_CONFIG}
{SYSTEM_SPECS}

ANALYZE and respond in this structure:

## 1. Diagnosis Summary
- Key bottlenecks identified
- Root causes

## 2. Immediate Fixes
- Quick wins (indexing, query rewrites)

## 3. Long-term Optimizations
- Schema changes
- Config tweaks
- Monitoring setup

## 4. SQL Optimizations
- Rewritten queries
- New indexes

## 5. Prevention Strategies
- Best practices
- Tools to use

Be precise, use real-world examples, and quantify improvements (e.g., 'reduces query time by 80%').

How to Use

1. Copy the full prompt text from the 'content' field exactly. 2. Identify your database type (e.g., PostgreSQL), slow query, schema, EXPLAIN output, config, and system specs. 3. Replace the placeholders {DATABASE_TYPE}, {SCHEMA}, {SLOW_QUERY}, etc., with your specific details. 4. Paste the customized prompt into Claude or another AI tool. 5. Review the structured output, implement recommendations, and re-run with new data for iterations. 6. Test optimizations in a staging environment before production. 7. Use the prevention strategies to set up ongoing monitoring.

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