Correct and Optimized SQL Query with Execution Plan
This is a ready-made prompt from the Zayenha Prompt library in Programming & Tech, written for claude-sonnet-4-7. It has a main prompt to copy into the model, built-in quality guards, and a verification prompt to run in a second window to review the answer. The full text needs the Plus plan; the description is open to all.
Turn a described requirement into a correct optimized SQL query, with execution-plan reasoning, suggested indexes, and performance alternatives, without inventing engine-specific functions.
Your current plan: free
Turning a requested management report into a precise query, speeding up a slow production query, validating a complex aggregation query before relying on it.
Built-in quality guards
Never invent APIs, functions, or libraries
Strict adherence to the requested structure
No TODOs or stubs — output runs as-is
OWASP Top 10 considered in code
Frequently asked questions
How do I use this prompt?
Copy the main prompt and paste it into claude-sonnet-4-7 or the model you use, replace what is in square brackets with your details, then run the verification prompt in a second window with the answer pasted in, and review it before relying on it.
Is this prompt free?
Its full text requires the Plus plan or higher. Free prompts you can copy at once without an account are on the ready-made Arabic prompts page.
Which model was this prompt written for?
It was written for claude-sonnet-4-7 and follows how that model works; you can run it on other models too, reviewing the result, since no single wording guarantees the best result on every model.