Skills
.Work. You
Rest

db-migration-safety

Community

Ensure safe database migrations with comprehensive analysis.

Software Engineering#database migration#reversibility#schema drift#SQL analysis#lock level
AuthorHainrixz
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill helps identify potential issues and risks in database migrations, ensuring safe and successful migrations.

Core Features & Use Cases

  • Reversibility Check: Ensures migrations are reversible with a proper down migration path.
  • Lock Level Analysis: Checks for potential locking issues that could impact database performance.
  • Table Rewrite Assessment: Identifies changes that require full table rewrites, which can be resource-intensive.
  • Destructive Operation Detection: Flags destructive operations like DROP COLUMN/TABLE, TRUNCATE, and NOT NULL changes without default values.
  • Enum Mutation Verification: Ensures enum changes do not remove or reorder values, avoiding potential data integrity issues.
  • Schema Drift Detection: Identifies discrepancies between the declarative schema and migration history.
  • Use Case: Before deploying a database migration, use this Skill to analyze it for potential issues, reducing the risk of failed migrations and data corruption.

Quick Start

Analyze the migration file 'migration.sql' for potential issues with the db-migration-safety skill.

Dependency Matrix

Required Modules

None required

Components

scripts

💻 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: db-migration-safety
Download link: https://github.com/Hainrixz/claude-db/archive/main.zip#db-migration-safety

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.