Popular Copilots
131 specialists across 20 professional domains.
Engineering & Codeโจ Best with Engineering Copilot
Write a SQL Query for My Requirement
This prompt produces correct, optimized SQL queries for any requirement by giving the AI your exact schema and a plain-English description of what you need. It explains each part of the query, recommends indexes for performance, and flags edge cases - so you understand the query, not just copy it.
The Prompt0 of 4 slots filled. Copy as-is or fill more.
Please write a SQL query that meets my requirement. Act as a senior database engineer.
Database context:
- Database type:
- Relevant tables and their columns:
```
Table: users
Columns: id (int, PK), name (varchar), email (varchar), created_at (timestamp), plan (varchar: 'free'|'pro')
Table: orders
Columns: id (int, PK), user_id (int, FK -> users.id), amount (decimal), status (varchar), created_at (timestamp)
Table:
```
What I need the query to do:
Any constraints or preferences:
Please provide:
1. The complete SQL query
2. A plain English explanation of what each clause does
3. Indexes to add for optimal performance
4. Any edge cases the query handles (or does not handle)
5. An alternative approach if one exists
01
How to use this prompt
1
Fill the slots
Edit the highlighted fields above. Same-named slots stay synced.
2
Copy filled
The copy button writes the version with your inputs already filled in.
3
Paste & send
Use it in ChatGPT, Claude, Gemini, or Copilotly.
4
Ask follow-ups
Drill into specific points: "Expand on #3" or "What about X?"
02
Pro tips for better results
โAlways include your actual table names and column names - generic examples produce generic queries that may not work with your schema
โDescribe what you want in plain English first, not in SQL - this helps the AI understand intent rather than just translate syntax
โFor performance-critical queries, specify the approximate row counts per table so the AI can recommend the right indexes and query strategy
03
Why this prompt works
Most people write one-line prompts and get generic, surface-level AI responses. This prompt is engineered to produce expert-level output because it bakes in three principles that meaningfully shift response quality:
Role assignment
It tells the AI to act as a specific professional (a engineering & code expert), activating more relevant knowledge and shifting away from generic advice.
Structured output
It specifies the exact response format - numbered steps, comparisons, risk ratings - so you get organized, actionable answers instead of a wall of prose.
Context anchoring
The slots you just filled force the AI to ground every recommendation in your specific situation instead of defaulting to textbook advice.
For sharper output, use this prompt with Engineering Copilot - it already has engineering & code expertise built in and ships output in the format you expect.
04
Works with every AI platform
๐ค
ChatGPT
Compatible
๐ง
Claude
Compatible
๐
Gemini
Compatible
๐
Copilotly
Best results
05
Frequently asked questions
What does the "Write a SQL Query for My Requirement" prompt do?
This prompt produces correct, optimized SQL queries for any requirement by giving the AI your exact schema and a plain-English description of what you need. It explains each part of the query, recommends indexes for performance, and flags edge cases - so you understand the query, not just copy it.
Can I use this prompt with ChatGPT?
Yes. This prompt works with ChatGPT, Claude, Gemini, and any other AI platform. For the best engineering & code results, use it with Copilotly's Engineering Copilot copilot, which has built-in domain expertise.
Is this prompt free?
Completely free. Fill the slots above, copy the result, and use it with any AI tool. No account required to read, fill, or copy prompts.
How do I customize this prompt?
Replace the highlighted placeholders inline above with your specific details. The more context you provide, the better the AI response. Switch to "Raw" mode in the top-bar to see the unfilled template.
What AI copilot is best for engineering & code prompts?
Copilotly's Engineering Copilot is purpose-built for engineering & code tasks. Unlike generic AI chatbots that hedge or refuse professional advice, Copilotly's copilots use domain-specific frameworks, terminology, and output formats.
The real valueA prompt is a starting line.
A prompt is a starting line.
A copilot runs the race.
Engineering Copilot already knows the right questions to ask, the right format to return, and the follow-ups to drive. Free to start, no card needed.
Open Engineering CopilotAI SQL query promptChatGPT write SQLwrite SQL query AIAI database query generatorSQL generator AI
Keep exploring Copilotly.
131 specialist AI copilots, a free playground, eight documented case studies, and side-by-side comparisons. Pick up wherever you left off.
Free Tools
No signup, no card, try the copilots first.
Learn About Copilotly
How it works, who it is for, and the case studies.
Compare Alternatives
Honest, side-by-side breakdowns of the alternatives.