Write a SQL query for {{databaseType}} that {{queryGoal}}. Tables: {{tables}}. Relationships: {{relationships}}. Include: JOINs, WHERE conditions, GROUP BY, ORDER BY, LIMIT. Optimize for performance. Add comments explaining complex logic.
How to Use This Prompt
Copy the full prompt text above
Replace the variables (in {{curly braces}}) with your specific information
Paste into ChatGPT, Claude, or Gemini
Review the output and iterate — adjust variables for different results
Save your favorite configurations for repeated use
About This Prompt — Deep Dive
SQL query generation is one of the most practical applications of AI for developers and data analysts. Complex queries involving multiple JOINs, subqueries, and aggregations can be generated in seconds, dramatically reducing development time.
For best results, use this prompt as a starting point and customize it to your specific needs. The most effective AI users treat prompts as templates that evolve over time, refining them based on output quality and specific use cases. Experiment with different models as each has unique strengths — GPT-4 excels at structured analytical tasks, Claude is outstanding for nuanced writing and analysis, and Gemini offers excellent Google ecosystem integration.