physics91/claude-vibe
Overview
This skill reviews database migrations for safety, rollback capability, downtime risk, and data integrity. It highlights dangerous operations, suggests zero-downtime patterns, and produces concrete rollback and lock analyses to reduce production incidents. Use it to validate schema and data migrations before deployment.
How this skill works
The skill scans migration files and detects common patterns (Prisma, Alembic, TypeORM, Rails, Flyway/Liquibase and plain SQL). It classifies changes (schema vs data), flags high-risk operations (adding non-nullable columns, dropping/renaming columns, changing types, adding constraints), and generates step-by-step mitigations, rollback commands, and lock/downtime guidance. It also recommends batching and concurrent operations for large tables and provides a pre-migration checklist.
When to use it
- Before merging or deploying database migrations
- When adding or changing non-nullable columns or constraints
- When planning large data migrations or backfills
- When verifying rollback plans and down/reverse migrations
- When preparing zero-downtime deployment strategies
Best practices
- Break risky changes into multi-step migrations (nullable → backfill → set NOT NULL)
- Always include down/reverse migration or explicit rollback scripts
- Use CREATE INDEX CONCURRENTLY (or equivalent) to avoid write locks
- Process large data in batches or with server-side SQL to avoid memory and lock issues
- Test migrations and rollbacks on staging with production-like data and backups
Example use cases
- Review a migration that adds phone to users and produce a multi-step safe plan and rollback SQL
- Analyze index creation and recommend CONCURRENTLY plus note transaction constraints
- Validate a data backfill script for batching and memory safety, rewriting to use bulk updates or limited subqueries
- Check a rename operation and produce add/copy/drop pattern plus deployment coordination guidance
- Produce a pre-migration checklist including backup, staging test, downtime window, and rollback verification
FAQ
Adding non-nullable columns without a safe default and dropping tables/columns are critical because they can fail or permanently lose data. Use multi-step patterns and backups.
How do you avoid table locks during index creation?
Use database-specific concurrent/index-without-transaction options (e.g., CREATE INDEX CONCURRENTLY in PostgreSQL) and run the operation outside transactions or in separate migrations.
19 skills
This skill reviews database migrations for safety, backwards compatibility, rollback readiness, and zero-downtime deployment to protect data integrity.
This skill reviews Rust API projects using Actix-web, Axum, or Rocket to optimize async handlers, extractors, and error handling.
This skill helps review ORM code for query efficiency, loading strategies, transactions, and N+1 prevention to improve data access.
This skill reviews Django projects for ORM optimization, view patterns, security, and admin practices to improve performance, safety, and maintainability.
This skill reviews Spring Boot projects for DI patterns, transaction management, REST API design, security config, and JPA best practices to improve
This skill reviews CI/CD pipelines for structure, security, and optimization, helping you improve workflows across GitHub Actions, GitLab CI, and Jenkins.
This skill performs deep multi-model code reviews with Codex and Gemini, aggregating findings, deduplicating results, and detecting secrets to improve security
This skill reviews Go code for idiomatic patterns, error handling, concurrency, and testing to improve robustness and readability.
This skill reviews Java code for idioms, exception handling, resources, null safety, streams, and modern Java features to improve quality.
This skill analyzes test coverage to identify untested files and prioritize improvements for high-impact areas.
This skill reviews Kotlin Multiplatform projects to validate expect/actual, shared module structure, and iOS interop, ensuring clean separation and correct
This skill reviews Dockerfiles and docker-compose for optimization, security, and best practices to improve build speed and image safety.
This skill reviews Android Kotlin code for Compose, Coroutines, Flow, and ViewModel best practices to improve reliability and performance.
This skill reviews Next.js patterns including App Router, Server Components, and data fetching to optimize architecture and performance.
This skill reviews Flutter/Dart code for widget patterns, state management, performance, and platform channels to optimize quality and reliability.
This skill reviews Python code for PEP8, type hints, and Pythonic idioms, improving maintainability and reducing errors.
This skill reviews database schemas for normalization, constraints, data types, and indexing to improve integrity and performance.
This skill reviews ML/DL code for PyTorch/TensorFlow patterns, training optimization, data pipelines, and MLOps checks to improve model quality and reliability.
This skill reviews GraphQL schemas, resolvers, and operations for N+1, query complexity, input validation, and error handling to improve security and
