Which AI is this prompt for?

This template was designed and tested with ChatGPT; it also works with ChatGPT, Claude, Gemini and other mainstream text AIs — just replace the bracketed parts with your own situation.

How do I adapt this prompt?

First replace the (bracketed) placeholders with your real data; if the result is too generic, add background context, specify the output format and length, and give one or two examples — the AI's answer will be more precise.

Write a database query (SQL)

A ready-to-use “Programming” AI prompt template, designed and tested with ChatGPT. Replace the (bracketed) parts below with your own needs.

Prompt template

Write SQL: 1) a query per my described need; 2) a section-by-section explanation of what it does; 3) point out possible performance issues (missing indexes, full table scans) and fixes; 4) remind me of edge cases (NULL, duplicates, time zones).

Table schema: "describe tables and columns"
What I want to query: "describe the need"

How to use this prompt

Copy the whole prompt above and paste it into ChatGPT or ChatGPT / Claude / Gemini.
Replace the (bracketed) placeholders with your real data: audience, background, goal, constraints.
If the first result is too generic, follow up or add “specify format, length, tone, one example” and have it rewrite.

Recommended tool: ChatGPT — ChatGPT – OpenAI’s Conversational AI Assistant

Write a database query (SQL)

How to use this prompt

More prompts in this category