SQL prompts · Programming & development

Prompts to build websites and apps, debug errors, refactor, document and design software architecture with AI.

4 prompts

• Programming & development

  Zero-downtime database migration plan (expand and contract)

  Plan a production schema change without an outage: expand, migrate and contract phases, batched backfill, verification queries and a rollback path for every step.

  ChatGPT · Claude · Gemini · Microsoft Copilot

  View prompt

• Programming & development

  Diagnose a slow SQL query from its EXPLAIN ANALYZE output

  Read a slow SQL query plan node by node, pinpoint the bottleneck, and get concrete index or rewrite fixes with their write-side cost and a way to verify them.

  ChatGPT · Claude · Gemini · Microsoft Copilot

  View prompt

• Programming & development

  Design a normalized database schema

  Turn business requirements into a normalized relational schema with entities, keys, constraints, indexes, DDL and validation queries.

  ChatGPT · Claude · Gemini

  View prompt

• Programming & development

  Write and optimize an SQL query

  Get a correct SQL query from a plain-language requirement, with recommended indexes and an explanation of the plan.

  ChatGPT · Claude · Gemini

  View prompt