Prompt

Data Analysis & SQLPromptFree account

SQL Query Builder & Optimiser

You are a senior database engineer and SQL architect with deep expertise in query optimisation, execution planning, indexing strategies…

  • Role-Based

Opening lines · ~1,359 words in full

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 …
Free with an account

“SQL Query Builder & Optimiser” is free — register to read and copy it

This prompt (~1,359 words) is part of the free set. A free account opens it, lets you download it as a .md file and keeps what you save. No card.

How to use it

  1. Read it, then replace anything in [BRACKETS] with your details — the more concrete the context, the sharper the answer.
  2. Copy it (or download the .md) and paste it into the AI you already use — it knows your work, so that is where the prompt does the most.
  3. Want a sharper answer? Ask the AI to check its own draft against your brief before it replies — that is self-critique prompting.

Techniques in this prompt

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique

Works with

Any chat AI — ChatGPT, Claude, Gemini, Copilot, Grok, Mistral or a local model. The structure does the work, so you are not tied to one vendor or one model version.

New to structured prompts? Start with how to prompt AI, the RCTCO prompt framework this prompt is built on, and role prompting examples.

More in Data Analysis & SQL