migrate

Analyze database migration files for lock levels, table rewrites, and data loss.

18|4|Updated Jun 16, 2026
One-click install
npx skills add https://github.com/Hainrixz/claude-db --skill migrate-hainrixz
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: migrate
Source: https://github.com/Hainrixz/claude-db/tree/main/skills/migrate
Command: npx skills add https://github.com/Hainrixz/claude-db --skill migrate-hainrixz

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires node, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides a safety check for database migrations, identifying potential issues like lock levels, table rewrites, and data loss before the migration is executed.

Core Features & Use Cases

  • Migration Linting: Analyze and classify database migration files for safety.
  • Schema Comparison: Compare and generate migrations between two schemas.
  • Risk Assessment: Identify destructive or data-loss operations and propose safe rollout strategies.
  • Use Case: Before deploying a database migration, use this Skill to ensure it won't cause data corruption or downtime.

Quick Start

Analyze the migration file 'migration.sql' for potential issues.

Frequently Asked Questions about migrate

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I check database migration files for potential data loss and table rewrites?

To check database migration files for data loss, table rewrites, and lock levels, you can analyze the SQL schema using dedicated scripts. This migration analysis identifies destructive operations and ensures schema changes are safe before deployment.

What is database migration risk assessment and when do I need it?

Database migration risk assessment is the process of evaluating schema changes to identify destructive operations like table rewrites or data loss. You need this safety check before deploying migrations to prevent database downtime and data corruption.

How do I generate a database migration by comparing two schemas?

You can generate a database migration by running schema comparison scripts that analyze differences between two database schemas. This produces a classified migration file highlighting potential issues like lock levels and data loss operations.

Do I need Node installed to run database migration linting and schema analysis?

Yes, Node is required as a dependency to run the environment for this database migration linting. The schema analysis and migration generation scripts rely on this setup to evaluate lock levels and identify data loss risks.

What's the best way to prevent downtime during database schema migrations?

The best way to prevent downtime during database schema migrations is to perform a safety check that identifies lock levels and table rewrites beforehand. Risk assessment analyzes migration files to propose safe rollout strategies for destructive operations.

Can this migration analysis identify which database operations cause locks?

Yes, this migration analysis identifies lock levels and table rewrites by evaluating your database schema changes. It classifies migration files to highlight operations that could cause locks or data loss before execution.