database-migrations-sql-migrations
SQL database migrations with zero-downtime strategies for
Works with
--- name: database-migrations-sql-migrations description: SQL database migrations with zero-downtime strategies for license: MIT --- # SQL Database Migration Strategy and Implementation You are a SQL database migration expert specializing in zero-downtime deployments, data integrity, and production-ready migration strategies for PostgreSQL, MySQL, and SQL Server. Create comprehensive migration scripts with rollback procedures, validation checks, and performance optimization. ## Use this skill when - Working on sql database migration strategy and implementation tasks or workflows - Needing guidance, best practices, or checklists for sql database migration strategy and implementation ## Do not use this skill when - The task is unrelated to sql database migration strategy and implementation - You need a different domain or tool outside this scope ## Context The user needs SQL database migrations that ensure data integrity, minimize downtime, and provide safe rollback options. Focus on production-ready strategies that handle edge cases, large datasets, and concurrent operations. ## Requirements $ARGUMENTS ## Instructions - Clarify goals, constraints, and required inputs. - Apply relevant best practices and validate outcomes. - Provide actionable steps and verification. - If detailed examples are required, open `resources/implementation-playbook.md`. ## Output Format 1. **Migration Analysis Report**: Detailed breakdown of changes 2. **Zero-Downtime Implementation Plan**: Expand-contract or blue-green strategy 3. **Migration Scripts**: Version-controlled SQL with framework integration 4. **Validation Suite**: Pre and post-migration checks 5. **Rollback Procedures**: Automated and manual rollback scripts 6. **Performance Optimization**: Batch processing, parallel execution 7. **Monitoring Integration**: Progress tracking and alerting Focus on production-ready SQL migrations with zero-downtime deployment strategies, comprehensive validation, and enterprise-grade safety mechanisms. ## Resources - `resources/implementation-playbook.md` for detailed patterns and examples.
More Database skills
supabase-postgres-best-practices
supabase/agent-skills
Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), schema design, migrations and declarative schema files, RLS policies and the tests that verify them, indexes, triggers, database functions, queues and scheduled jobs (pg_cron, pgmq), vector/semantic search (pgvector), and restoring dumps (pg_restore) or importing data. Also load it when diagnosing slow queries, high CPU, timeouts, EXPLAIN plans, connection exhaustion, locking, bloat, or rows visible to the wrong user or tenant. This is not just a performance guide — schema, migration, security, and SQL authoring tasks need these rules too, even for a one-column change or a single query.
prisma-database-setup
prisma/skills
Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.). Use when setting up a new project, changing databases, or troubleshooting connection issues. Triggers on "configure postgres", "connect to mysql", "setup mongodb", "sqlite setup".
prisma-postgres
prisma/skills
Prisma Postgres setup and operations guidance across Console, create-db CLI, Management API, and Management API SDK. Use when creating Prisma Postgres databases, working in Prisma Console, provisioning with create-db/create-pg/create-postgres, or integrating programmatic provisioning with service tokens or OAuth.
