AI Prompts Library

Plan a migration from [CURRENT MODEL] to [TARGET MODEL] for a production workload.

Cover:

1. BEHAVIOURAL DELTAS to expect: tokenizer differences and their effect on cost, system prompt interpretation, refusal boundaries, structured output strictness, tool-calling format, streaming behaviour.
2. WHAT WILL SILENTLY BREAK: the changes that pass tests and fail in production. Be specific.
3. TOKEN COUNT IMPACT: different tokenizers mean the same text costs different amounts. Estimate the direction and rough size.
4. SHADOW TEST PLAN: how to run both models on real traffic and compare, including what to compare on and the sample size needed.
5. ROLLOUT: percentage stages, what metric gates each stage, and the rollback trigger.
6. WHAT TO DELETE AFTERWARDS: the workarounds for the old model's quirks that should not survive the migration.

Workload:
[DESCRIBE]

Generate a database migration for [DATABASE - Postgres / MySQL / SQLite].

Goal: [DESCRIBE - add column, rename table, add index, etc.].
Framework: [Prisma / Knex / Rails / Alembic / raw SQL].

Requirements:
1. The migration must be safe to run on a table with millions of rows in production. No table-level locks if avoidable.
2. Include both UP and DOWN migrations.
3. Defaults handled correctly - if adding a NOT NULL column, propose a backfill strategy.
4. Add appropriate indexes.
5. Name the migration descriptively with a timestamp prefix.

Return the migration file content and a one-paragraph runbook explaining how to apply it safely in production.

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