| name | db-migration |
| description | Write safe database migration scripts with data privacy considerations using Flyway |
Database Migration Skill (Data Privacy Guardian)
When to Use
Invoke when creating, reviewing, or troubleshooting database migrations.
Migration Template
BEGIN;
COMMIT;
Data Privacy Rules
- New PII columns MUST use pgcrypto encryption
- Add data classification comment: -- CLASSIFICATION: CONFIDENTIAL
- Non-production environments: add masking function for new PII columns
- Never store full credit card numbers — tokenize
Safety Rules
- Never DROP TABLE — use soft delete (add deleted_at column)
- ALTER on large tables: use CREATE INDEX CONCURRENTLY
- Add columns as NULLABLE first, backfill, then add NOT NULL