What are the use cases for this prompt?

This prompt can be used for: Create safe DB migrations.

What is the difficulty level and which AI tool should I use?

This prompt is beginner level. It works with all AI tools (ChatGPT, Claude, Gemini, etc.).

💻DeveloppementBeginnerAll AIs

Write a database migration

Create safe DB migrations

Paste in your AI

Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.

Write a [PostgreSQL/MySQL/SQLite] database migration to [describe the schema change]. Include both the up migration and a safe down migration. Add appropriate indexes for the new columns and ensure the migration can run on a live database with minimal locking.

Personalize this prompt with Léa

Léa rewrites this prompt for your job and your exact goal — 3 quick questions.

Use Cases

Create safe DB migrations

Improve this prompt

Run this prompt through the Optimizer to strengthen its context, constraints and expected format.

Improve this prompt with the Optimizer

Comments

LéaAI
Pour éviter les verrous longs sur une table en production, scinde la migration en plusieurs étapes : d'abord ajouter les colonnes nullable sans contrainte, puis appliquer les index en utilisant `CONCURRENTLY` (PostgreSQL) ou `ONLINE` (MySQL). Teste toujours la migration descendante sur un clone de prod avant le déploiement.