SQL Query Builder

Write a SQL query from a plain English description

🧪 Tested by a human Intermediate 👤 Developer 👤 Analyst 👤 Data Engineer
Write a SQL query that [DESCRIBE WHAT YOU NEED — e.g. finds all customers who ordered more than 3 times in the last month but have not ordered in the last 7 days]. Database: [TYPE — SQL Server / PostgreSQL / MySQL]. Tables: [LIST TABLE NAMES AND KEY COLUMNS]. Include: the query, explanation of each clause, and performance considerations.

Works on

⭐ ChatGPT (Best) 🟠 Claude ⚡ M365 Copilot

Copy & Open in

🟢 ChatGPT 🟠 Claude

Prompt is copied to your clipboard when you click

Tips for Best Results

  • Provide table schemas for accurate column references
  • Ask for index recommendations alongside the query
  • Test on a subset of data before running on production

📎 More Prompts

API Documentation Generator

●●
Generate API documentation for [API NAME]. For each endpoint include: (1) HTTP method and path, (2) Description of what it does, (3) Request parameters with types and required/optional, (4) Request body schema with examples, (5) Response schema with examples, (6) Error codes and meanings, (7) Authentication requirements. Format as Markdown.
🟢 GPT ⭐ Claude

Code Review Assistant

●●
Review this code and provide feedback on: (1) Bugs or logic errors, (2) Security vulnerabilities, (3) Performance issues, (4) Readability and naming, (5) Missing error handling, (6) Test coverage gaps. For each issue: explain the problem, show the fix, and rate severity (critical, important, minor). [PASTE CODE]
🟢 GPT ⭐ Claude

Database Migration Script

●●●
Write a migration script for [CHANGE]. Include: up migration, down migration (rollback), data preservation, validation queries, estimated execution time. Include safety checks.
⭐ M365 🟢 GPT 🟠 Claude
💬