Back to AI Prompts
Coding TEXT

Database Migration Script Generator

October 2, 2025 Optimized for: gpt-4o Database migrations, schema changes, data migrations

Prompt

Generate database migration script for [DATABASE: PostgreSQL/MySQL/MongoDB].

**Migration Type:**
- [ ] Create table
- [ ] Alter table
- [ ] Add column
- [ ] Drop column
- [ ] Add index
- [ ] Data migration

**Details:**
[DESCRIBE SCHEMA CHANGES]

**Generate:**

1. **Up Migration** (apply changes)
2. **Down Migration** (rollback)
3. **Data Migration** (if needed)
4. **Validation Queries**

**Requirements:**
- Idempotent (can run multiple times safely)
- Transaction-wrapped
- Rollback-safe
- Include comments
- Handle edge cases
- Test data examples
- Performance considerations for large tables

**Also provide:**
- Pre-migration checklist
- Post-migration validation
- Backup recommendations

Tags

#coding #database #migration #sql

Safe database migration script generator with rollback support.

Share This Prompt

Related Prompts

Coding

SQL Query Optimizer & Performance Tuner

gpt-4o • TEXT
Coding

SQL Schema Design Best Practices

gpt-4o • TEXT
Coding

Migration Generator (Database Schema)

claude-opus-4-7 • TEXT
Coding

Python Debugging Expert Assistant

gpt-4o • TEXT
Coding

API Documentation Generator (OpenAPI/Swagger)

gpt-4o • TEXT
Coding

Chrome Extension Complete Builder

gpt-4o • TEXT

Have a Great Prompt to Share?

Submit your own AI prompts to the community. The best ones get featured on TokenCalculator - and credited to you.

Submit a Prompt

Ratings & Feedback

0.0 / 5 · 0 votes

Comments