SQL Query Generator

Turn a concrete data question and schema into readable, dialect-aware SQL. Example: find the five highest-spending customers in the last 30 days, with a query, assumptions, and an index suggestion that can be checked before production use.

Author

PromptVar Team

Tags

SQLdatabasequeries

Variables (7)

requirementdbTypeschemaqueryTypeoptimizeincludecomplexity

Template Preview

Generate a SQL query to requirement*.

Database type: dbType*
Table schema:
schema*
Query type: queryType*
Optimize for: optimize*
Include: include*
Complexity: complexity*

Example input (for orientation): PostgreSQL; customers(id, email), orders(id, customer_id, total_cents, created_at); return the five customers with the greatest order total in the last 30 days.
Expected result: Return one parameterized SELECT with an explicit time boundary and aggregation, then explain the join and name indexes worth checking. State any missing schema assumptions and never invent a table or column silently.
Editing guidance: Replace the example with the real schema and the intended time zone. Keep write queries disabled unless the requested operation and transaction safeguards are explicit.

Try filling out the variables

Comments

Indexes

Performance Tips

Example Data