Using AI to Write and Optimize SQL

AI doesn't replace SQL knowledge. It multiplies it.

Here's what you'll find: AI writes good SQL fast. But it also writes confidently wrong SQL sometimes. Without the three days you just completed, you can't tell the difference. That's why you learned SQL first.

The workflow is: describe what you want → get a query → read it, run it, verify the output makes sense → refine. You stay in control. AI handles the typing.

The Prompt Template That Works

The key to getting good SQL from AI is giving it your schema upfront. AI that doesn't know your table names and column names will hallucinate them.

The plain-English description is everything. Be specific about:

• What rows you want (filter conditions)
• What columns to show
• How to sort or limit results
• Any grouping or aggregation needed

Example Prompts That Produce Good Queries

// Prompt 1 — specific and complete
"Give me the total revenue per customer segment for
completed orders only, sorted high to low."

// Prompt 2 — asks for a specific technique
"Using a CTE, find customers whose total spend is more
than 1.5x the average customer spend."

// Prompt 3 — window function request
"Rank customers by total revenue using RANK().
Show name, total, and rank. Top customer is rank 1."

AI as a SQL Debugger

When you get an error — paste it in. AI is extremely good at explaining SQL errors and suggesting fixes.

Using AI to Speed Up Slow Queries

Once you're working with large tables (100K+ rows), query speed matters. AI can suggest indexes, rewrite inefficient subqueries as JOINs, and spot patterns that slow databases down.

-- Slow: correlated subquery runs once per row
SELECT *
FROM orders o
WHERE amount > (
  SELECT AVG(amount)
  FROM orders
  WHERE customer_id = o.customer_id
);

WITH avg_per_customer AS (
  SELECT customer_id, AVG(amount) AS avg_amt
  FROM orders
  GROUP BY customer_id
)
SELECT o.*
FROM orders o
JOIN avg_per_customer a ON o.customer_id = a.customer_id
WHERE o.amount > a.avg_amt;

Prompt: "Here's a slow SQL query. Rewrite it to be more efficient. Explain what change you made and why." — paste your query. AI will almost always find the issue.