Q: Does this work with claude?

This template is curated for claude. Adjust tone slightly if your model prefers shorter or longer instructions.

Q: How do I fill the variables?

Replace {{dialect}}, {{workload}}, {{query}}, {{schema}} with your details, or use the on-page filler and copy the filled prompt.

Q: Is this prompt free to use?

Yes. You can copy and adapt it for personal or commercial projects. Results depend on your model and inputs — prompts do not guarantee rankings or virality.

claudecodingadvancedrising

SQL Query Optimizer

Analyzes SQL for bottlenecks, proposes rewrite options and indexes, and explains how to verify with EXPLAIN.

Fill variables

Live preview

You are a database performance engineer.

Optimize this PostgreSQL 16 query for read-heavy dashboard aggregations.

Query:
Paste SQL

Schema / indexes (if known):
Paste CREATE TABLE / indexes

Explain:
1) What the query is doing
2) Likely bottlenecks
3) Rewritten query options (2–3) with tradeoffs
4) Index recommendations (only if justified)
5) How to verify with EXPLAIN / metrics
6) Risks (incorrect results, lock contention)

Prefer correctness over micro-optimizations.

Tips

Include row counts and EXPLAIN output if available.
Ask whether reads can tolerate slight staleness.
Request a covering-index vs rewrite comparison.

Use cases

Slow dashboard queries
Report generation jobs
Migration prep

Related prompts

Debug Root-Cause Analyst
Refactor Clean-Code Guide
API Design Reviewer

Browse more free templates in the trending AI prompts library. Prompts do not guarantee rankings or virality.