AI Prompts for SQL Queries

Write a SQL query that does the following: [DESCRIBE WHAT YOU WANT IN PLAIN ENGLISH]. My database has these tables: [DESCRIBE TABLE NAMES AND KEY COLUMNS]. The database is [MYSQL/POSTGRESQL/SQLITE/OTHER]. Include the query and explain each part.

Write a SQL query that joins these tables: [TABLE 1 STRUCTURE], [TABLE 2 STRUCTURE], [TABLE 3 STRUCTURE]. I want to retrieve: [DESCRIBE OUTPUT]. Use the correct join type for each relationship and explain why you chose each join type.

Write a SQL query that groups [TABLE NAME] by [COLUMN] and calculates [METRICS, e.g. sum, average, count, max]. Filter results to [CONDITIONS]. Include a HAVING clause if needed. Database: [DATABASE TYPE]. Table structure: [PASTE SCHEMA OR DESCRIBE]

I need to write a query where I first calculate [INTERMEDIATE RESULT] and then use that result to find [FINAL RESULT]. Write this as a subquery and also as a CTE. Explain the difference and recommend which approach is more readable for this case. Tables: [DESCRIBE TABLES]

I need a SQL query that uses window functions to calculate [DESCRIBE CALCULATION, e.g. running total, rank, lag/lead comparison] over [DESCRIBE PARTITION AND ORDER]. Write the query and explain what each part of the window function does. Table: [DESCRIBE TABLE]

This query is running too slowly. Analyze it and suggest specific optimizations: [PASTE QUERY]. Here is the table structure and approximate row counts: [PASTE SCHEMA AND SIZES]. Here is the EXPLAIN output if available: [PASTE EXPLAIN OUTPUT]. What are the main bottlenecks and how would you rewrite this to be faster?

Suggest indexes I should add to improve query performance. Here are the most common query patterns against this table: [DESCRIBE QUERIES OR PASTE THEM]. Here is the current table structure: [PASTE SCHEMA]. What indexes would have the most impact, what is the trade-off for each one, and are there any existing indexes I should remove?

I am running this query in a loop and it is causing an N+1 query problem: [DESCRIBE THE PATTERN]. Here is the code: [PASTE CODE]. Rewrite this as a single efficient SQL query that fetches all the data at once. Explain the performance difference.

The EXPLAIN plan for this query shows a full table scan. Here is the query: [PASTE QUERY]. Here is the schema: [PASTE SCHEMA]. How can I rewrite this query or add indexes to avoid the full scan? What is causing the optimizer to choose a full scan and what will make it use an index instead?

This query joins [NUMBER] tables and is performing poorly. Here is the query: [PASTE QUERY]. Here are the table sizes: [DESCRIBE SIZES]. Suggest ways to reduce the join cost: better join order, pre-filtering, materializing subsets, or restructuring the query logic entirely.

I am getting this SQL error: [PASTE ERROR]. Here is the query that produced it: [PASTE QUERY]. Here is the relevant schema: [PASTE SCHEMA]. Explain what is causing this error in plain language and provide the corrected query.

My query runs without error but returns wrong results. I expect [DESCRIBE EXPECTED RESULTS] but get [DESCRIBE ACTUAL RESULTS]. Here is the query: [PASTE QUERY]. Here is sample data: [PASTE SAMPLE DATA]. Walk through the query logic and identify where it diverges from my intention.

I am getting an error related to GROUP BY or aggregation: [PASTE ERROR]. Here is my query: [PASTE QUERY]. Explain why this error occurs and rewrite the query correctly. Also explain the general rule about what columns can appear in a SELECT when using GROUP BY.

My JOIN query is returning duplicate rows. Here is the query: [PASTE QUERY]. Here is sample data from each table: [PASTE SAMPLES]. Explain why duplicates are occurring, whether this is a data issue or a query logic issue, and how to fix it.

My query is not handling NULL values correctly. The issue is: [DESCRIBE PROBLEM]. Here is the query: [PASTE QUERY]. Explain how SQL handles NULLs in comparisons, aggregations, and joins, and rewrite the query to handle NULLs correctly for my use case.

Design a database schema for [DESCRIBE APPLICATION OR USE CASE]. I need to store [DESCRIBE DATA ENTITIES AND RELATIONSHIPS]. Provide the CREATE TABLE statements, explain your primary and foreign key choices, and identify any design decisions I should think carefully about. Database: [DATABASE TYPE]

Review this database schema for design issues. Look for: normalization problems, missing indexes, poor naming conventions, problematic data types, and any design choices that will make future queries difficult: [PASTE SCHEMA]. Suggest specific improvements and explain the trade-offs.

I need to model a many-to-many relationship between [ENTITY A] and [ENTITY B]. Walk me through the correct way to design this in SQL: the junction table structure, the indexes needed, and how to write the most common queries against this structure.

I am deciding how to normalize this data: [DESCRIBE DATA STRUCTURE]. Should I normalize it into [OPTION A] or keep it denormalized as [OPTION B]? Walk me through the trade-offs for each approach in terms of: storage, query complexity, update anomalies, and performance for my expected query patterns.

I need to change my database schema from [CURRENT STRUCTURE] to [NEW STRUCTURE]. This is a production database with live data. Write the migration SQL and explain: how to do this safely without downtime, what the rollback plan is if something goes wrong, and whether the migration needs to be done in multiple steps.