AI Prompts for ChatGPT for SQL

Write a SQL query to retrieve [DESCRIBE WHAT YOU WANT] from these tables: [DESCRIBE TABLES AND COLUMNS]. Use [POSTGRESQL / MYSQL / SQLITE]. Include appropriate JOINs, WHERE filters, and ORDER BY.

Write a SQL query that aggregates [WHAT TO AGGREGATE] from [TABLE]. Use GROUP BY, and include HAVING if I need to filter on the aggregated result.

Write a SQL query using a CTE (Common Table Expression) to [DESCRIBE THE GOAL]. Break it into named steps and explain what each CTE does.

Write a SQL [INSERT / UPDATE / DELETE] statement to [DESCRIBE THE OPERATION] on [TABLE]. Include appropriate WHERE clauses to avoid modifying too many rows.

Write a SQL query using a window function to [DESCRIBE THE GOAL: RUNNING TOTAL, RANK, LAG/LEAD]. Explain the OVER clause: PARTITION BY and ORDER BY.

This SQL query is failing or returning wrong results: [PASTE QUERY]. Expected: [DESCRIBE]. Actual error or result: [DESCRIBE]. What is wrong and how do I fix it?

My JOIN is returning [TOO MANY / TOO FEW] rows: [PASTE QUERY]. Explain what each JOIN type does and which I should use here: INNER, LEFT, RIGHT, or FULL OUTER.

My query is not handling NULLs correctly: [PASTE QUERY]. Fix it using IS NULL, IS NOT NULL, COALESCE, or NULLIF as appropriate.

This query is running too slowly: [PASTE QUERY]. What indexes should I add and how should I rewrite the query to be faster? I'm using [POSTGRESQL / MYSQL].

My date/time query is not working: [PASTE QUERY]. I'm using [DATABASE]. Fix it and explain the correct date functions and timezone handling.

Optimize this slow query: [PASTE QUERY]. Suggest: indexes to add, how to restructure the query, and any anti-patterns to eliminate. Explain the impact of each change.

Design indexes for these queries: [PASTE QUERIES]. For each index: which columns, composite or single, and what the index speeds up.

I have an N+1 query problem where a query runs inside a loop: [PASTE CODE]. Rewrite to fetch all needed data in a single query.

Help me understand this EXPLAIN output: [PASTE EXPLAIN RESULT]. What is the query optimizer doing, where is it slow, and what should I change?

My OFFSET-based pagination gets slow on large pages: [PASTE QUERY]. Rewrite using cursor-based pagination with a WHERE clause filter.

Design a database schema for [DESCRIBE THE APPLICATION]. Give me: tables, columns with types, primary keys, foreign keys, and constraints.

Write a migration to [DESCRIBE CHANGE: ADD COLUMN, RENAME TABLE, ADD INDEX]. Include UP and DOWN. Make it safe for production data.

Review this schema for normalization: [PASTE SCHEMA]. Identify violations of 1NF/2NF/3NF and suggest how to restructure.

Write SQL queries to audit the data quality of [TABLE]. Check for: duplicates, NULL in required fields, orphaned foreign keys, and out-of-range values.

Convert this [MYSQL / SQLITE / POSTGRESQL] query to [TARGET DATABASE]: [PASTE QUERY]. Explain any syntax differences and functions that need to change.