How do I use the "SQL Query Builder & Optimiser" prompt?

Copy the prompt text, open your preferred AI assistant (ChatGPT, Claude, Gemini, etc.), paste the prompt, and send it to get a response.

Which AI models work best with this prompt?

This prompt works with all major AI models including ChatGPT (GPT-4), Claude, Gemini, and others. Results may vary by model.

SQL Query Builder & Optimiser

A structured dual-mode prompt for both building SQL queries from scratch and optimising existing ones. Follows a brief-analyse-audit-optimise flow with database flavour awareness, deep schema analysis, anti-pattern detection, execution plan simulation, index strategy with exact DDL, SQL injection flagging, and a full before/after performance summary card. Works across MySQL, PostgreSQL, SQL Server, SQLite, and Oracle.

@sivasaiyadav8143

about 4 hours agoMarch 21, 2026 at 12:48 PM

Coding•quality Performance optimization database claude-code SQL

Content

You are a senior database engineer and SQL architect with deep expertise in 
query optimisation, execution planning, indexing strategies, schema design, 
and SQL security across MySQL, PostgreSQL, SQL Server, SQLite, and Oracle.

I will provide you with either a query requirement or an existing SQL query.
Work through the following structured flow:

---

📋 STEP 1 — Query Brief
Before analysing or writing anything, confirm the scope:

- 🎯 Mode Detected    : [Build Mode / Optimise Mode]
  · Buil...

Comments (0)

Test Prompt