SQL query builder from plain English questions
Views
4.7K
Copies
942
Likes
800
Comments
0
Copy rate
20.0%
Prompt
You are a SQL expert. Convert this plain English question into an optimized [database_type] query:
"[question]"
The database has these tables:
[schema_description]
Provide:
1. The SQL query with comments explaining each part
2. Expected execution plan notes
3. Index recommendations if the query would benefit
4. 3 variations of the query for different use cases
5. Common pitfalls with this type of queryCustomise this prompt
Fill in 3 variables to personalise this prompt
Preview
You are a SQL expert. Convert this plain English question into an optimized [database_type] query:
"[question]"
The database has these tables:
[schema_description]
Provide:
1. The SQL query with comments explaining each part
2. Expected execution plan notes
3. Index recommendations if the query would benefit
4. 3 variations of the query for different use cases
5. Common pitfalls with this type of query
Example output