reviewing-migration-safety
OfficialEnsure safe PostgreSQL migrations
Software Engineering#postgresql#database migration#zero-downtime#schema changes#production safety#lock risk
Authormusher-dev
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill prevents costly production database downtime by rigorously analyzing PostgreSQL migration scripts for potential risks like table locking, timeouts, and backward compatibility issues.
Core Features & Use Cases
- Lock Risk Assessment: Identifies DDL statements that could block read/write operations.
- Timeout Mandates: Enforces setting explicit
lock_timeoutandstatement_timeout. - CONCURRENTLY Enforcement: Ensures index operations use
CONCURRENTLYto avoid locks. - Expand-Contract Choreography: Guides zero-downtime schema changes.
- WAL Impact Analysis: Assesses and mitigates excessive Write-Ahead Log generation.
- Backward Compatibility Checks: Verifies application compatibility during schema changes.
- Use Case: Before merging a migration script that modifies a critical production table, use this Skill to review it for any potential locking issues or other risks that could lead to an outage.
Quick Start
Review the attached migration script for potential production risks.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: reviewing-migration-safety Download link: https://github.com/musher-dev/bundles/archive/main.zip#reviewing-migration-safety Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.