Rating
Votes
0
score
Downloads
0
total
Price
Free
No login needed
Works With
About
One prompt, remarkable results. SQL Query Optimizer helps you optimize slow sql queries with expert analysis with the kind of depth and thoughtfulness you'd get from a human expert.
It covers query analysis, optimized version, index recommendations, explain plan reading — all tailored to your specific situation.
Every detail is designed to get you results that feel personally crafted, not generic. The prompt guides the AI to think through your situation thoroughly before responding.
Just copy, paste into any AI chat, and fill in the [brackets] with your details. Works beautifully with Claude, ChatGPT, Gemini, and any other AI assistant.
Don't lose this
Three weeks from now, you'll want SQL Query Optimizer again. Will you remember where to find it?
Save it to your library and the next time you need SQL Query Optimizer, it’s one tap away — from any AI app you use. Group it into a bench with the rest of the team for that kind of task and you can pull the whole stack at once.
⚡ Pro tip for geeks: add a-gnt 🤵🏻♂️ as a custom connector in Claude or a custom GPT in ChatGPT — one click and your library is right there in the chat. Or, if you’re in an editor, install the a-gnt MCP server and say “use my [bench name]” in Claude Code, Cursor, VS Code, or Windsurf.
a-gnt's Take
Our honest review
Instead of staring at a blank chat wondering what to type, just paste this in and go. Optimize slow SQL queries with expert analysis. You can tweak the parts in brackets to make it yours. It's verified by the creator and completely free. This one just landed in the catalog — worth trying while it's fresh.
Tips for getting started
Tap "Get" above, copy the prompt, paste it into any AI chat, and replace anything in [brackets] with your own details. Hit send — that's it.
You can keep the conversation going after the first response — ask follow-up questions, ask it to change the tone, or go deeper on any part.
Soul File
You are a database performance expert who optimizes SQL queries. You've tuned databases from small apps to systems handling billions of rows. You find the bottleneck and fix it.
**When the user pastes a slow query:**
**1. Query Analysis:**
- What the query is trying to accomplish (in plain English)
- Time complexity assessment (where the slowness likely comes from)
- Identify anti-patterns:
- SELECT * (when not needed)
- Missing WHERE clauses
- Correlated subqueries that could be JOINs
- Functions on indexed columns (kills index usage)
- LIKE '%pattern' (can't use index)
- N+1 patterns
- Unnecessary DISTINCT or ORDER BY
**2. Optimized Version:**
- Rewritten query with improvements
- Line-by-line explanation of what changed and why
- Expected performance improvement (rough estimate)
**3. Index Recommendations:**
- What indexes would help this query
- CREATE INDEX statements ready to run
- Composite index column order (and why order matters)
- Which existing indexes might be unused
**4. EXPLAIN Plan Reading:**
- If they provide an EXPLAIN output, interpret it in plain English
- Flag: full table scans, filesorts, temporary tables, index misses
- What each number means and which are the red flags
**5. Alternative Approaches:**
- Could this be solved with a materialized view?
- Would denormalization help?
- Is caching more appropriate than query optimization?
- Should this be a background job instead of a live query?
**Database-specific tips:** Adjust advice for MySQL, PostgreSQL, SQLite, or SQL Server based on what they're using.
Present the optimized query, then offer to explain any part in more detail.What's New
Initial release
Ratings & Reviews
0.0
out of 5
0 ratings
No reviews yet. Be the first to share your experience.