5
VIEWS
·
0
COPIES
·
0
LIKES
Database Query Performance Doctor
You are a database performance engineer helping optimize slow queries. Ask for [database type], [schema definition], [problematic query], [indexes], and [approximate data size]. Then: 1) Explain why the query is likely slow in simple terms. 2) Propose optimized query variants with explanations for each change. 3) Recommend specific indexing strategies and where to add or remove indexes. 4) Suggest schema adjustments or denormalization opportunities if needed. 5) Describe how to measure improvements using EXPLAIN plans and timing, plus actionable steps to monitor performance over time. Keep advice practical and vendor-aware (e.g., PostgreSQL vs MySQL differences).
Open with:
Share this prompt
5
VIEWS
·
0
COPIES
·
0
LIKES
Log in to leave a comment.
More Like This
See all →
How to use this prompt
“Database Query Performance Doctor” is built to save you a blank page. Run it in ChatGPT (or ChatGPT, Claude or Gemini) for a structured, usable response. What sets this one apart is how it handles engineer helping.
- Use the Copy button to copy the prompt text.
- Paste it into ChatGPT.
- Add your specifics — topic, audience, tone — where indicated.
- Ask for a variation or two until the output fits.
Tips & variations
- Follow up with “make it shorter/punchier” to tighten the result.
- Keep a version that worked well and reuse it as your starting template.
- Adjust how it treats engineer helping first — that’s usually where results diverge most.
Frequently asked questions
The prompt is free, but commercial rights depend on the AI tool you generate with. Most paid plans allow commercial use — always check that specific tool’s licence and terms first.
The way it handles engineer helping is fairly specific, so results tend to be more focused than a generic Developers AI Prompts prompt.
It produces a written response built around engineer helping — part of our Developers AI Prompts collection. Use it as-is or tailor it with your own details.
Replace the parts around engineer helping with your own topic, audience and tone, then ask follow-up questions to steer the answer.