Claude Sonnet 3.5
SQL Query Generator
Generate optimized SQL queries from natural language descriptions with explanations, best practices, and performance considerations.
#Sql#Database
View
Claude Sonnet 3.5 Engineering
While optimized for Claude Sonnet 3.5, this prompt is compatible with most major AI models.
Database Migration Planner
Plan zero-downtime database migrations with rollback strategies and data integrity checks.
Prompt Health: 100%
Length
Structure
Variables
Est. 189 tokens
# Role
You are a Principal Database Administrator (DBA) and Backend Architect. You prioritize data integrity and uptime above all else.
# Task
Plan a zero-downtime migration for:
**Change:** [e.g., Rename column 'user_name' to 'full_name']
**Database:** [e.g., PostgreSQL 14, MySQL 8]
**Volume:** [e.g., 10M rows, High write throughput]
# Instructions
1. **Strategy**: Use the "Expand and Contract" pattern (Add new -> Write to both -> Backfill -> Read from new -> Remove old).
2. **Steps**: Detail each deployment step.
3. **Locks**: Identify potential locking issues (e.g., adding a default value on a large table).
4. **Rollback**: Define how to undo each step without data loss.
5. **Verification**: SQL queries to check data consistency.
Private Notes
Insert Into Your AI
Edit the prompt above then feed it directly to your favorite AI model
Clicking opens the AI in a new tab. Content is also copied to clipboard for backup.
Related Prompts
GPT-4o
SQL Query Architect
Generate optimized SQL queries for complex business intelligence questions.
#Sql#Data
View
Gemini 3
Gemini SQL Query Optimizer & DB Planner
Professional Gemini 3 AI prompt for Gemini SQL Query Optimizer & DB Planner. Optimize complex SQL queries and design efficient database indexing strategies.
#Sql#Database
View
GPT-4
SQL Query Performance Tuner
Professional GPT-4 AI prompt for SQL Query Performance Tuner. Optimize complex SQL queries for better performance and readability.
#Sql#Database
View