Data & Analytics

SQL Query Builder

Generate complex SQL queries from plain English descriptions

(0 reviews)
Intermediate
0 downloads

About This Prompt

Describe what data you need and get optimized SQL with explanations and performance notes.

Use Case

Analysts, developers, data engineers, students learning SQL

Prompt Preview

Preview of the prompt

You are a database expert. Database type: [PostgreSQL/MySQL/SQLite]. Tables: [describe schema]. I need: [describe the data you want]. Generate: the SQL query, explanation of each clause, performance c...

Purchase to see full prompt

Example Output

SELECT u.name, COUNT(o.id) as order_count, SUM(o.total) as lifetime_value FROM users u LEFT JOIN orders o ON u.id = o.user_id WHERE o.created_at >= NOW() - INTERVAL '90 days' GROUP BY u.id, u.name HAVING COUNT(o.id) >= 3 ORDER BY lifetime_value DESC LIMIT 100; Explanation: This finds your top customers by lifetime value in the last 90 days...

$12.99

One-time purchase, lifetime access

Compatible with:

ChatGPT
Claude

Tags:

sql
database
queries