skills.rest
RepairYourTech
RepairYourTechCOMMUNITY
Explore all skills by this author →
GitHub

database-migration-management

Manage PostgreSQL and MySQL schema changes with SQL migration scripts.

6|1|Updated Feb 27, 2026
Search Tags:#versioning#rollback#database#postgresql#schema#migration#mysql
One-click install
npx skills add https://github.com/RepairYourTech/cfsa-antigravity --skill database-migration-management
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-migration-management
Source: https://github.com/RepairYourTech/cfsa-antigravity/tree/main/.agent/skills/migration-management
Command: npx skills add https://github.com/RepairYourTech/cfsa-antigravity --skill database-migration-management

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a structured approach to managing database schema changes, ensuring consistency, enabling rollbacks, and facilitating safe deployments across different environments.

Core Features & Use Cases

  • Schema Versioning: Track and manage database schema evolution over time.
  • Rollback Strategies: Plan and execute safe rollback procedures for failed migrations.
  • Data Transformation: Implement data migration and cleanup scripts.
  • Use Case: When introducing a new feature that requires significant database schema changes, use this Skill to define, test, and deploy the migrations incrementally, with a clear plan for reverting if issues arise.

Quick Start

Use the database-migration-management skill to set up PostgreSQL schema versioning.

Frequently Asked Questions about database-migration-management

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

FAQPage Schema
How do I version control my PostgreSQL database schema?▼

Database schema versioning tracks schema evolution for PostgreSQL by defining sequential SQL scripts. This allows you to apply migrations incrementally and maintain consistent schema states across multiple environments.

What is the best way to roll back a failed MySQL schema migration?▼

Rolling back a failed MySQL schema migration requires defining explicit SQL rollback scripts for each applied change. This Skill structures safe rollback procedures, allowing you to revert schema modifications and reverse data transformations if deployment issues arise.

Can I use this for non-blocking schema migrations in MySQL and PostgreSQL?▼

Yes, this approach includes patterns for safe, non-blocking operations when managing MySQL and PostgreSQL schemas. It utilizes SQL scripts designed to execute migrations without locking database tables during deployment.

How do I handle data transformations during a database migration?▼

Data transformations during database migrations are handled by implementing dedicated SQL scripts within the migration logic. These scripts execute data migration and cleanup tasks alongside standard schema changes like index management.

Do I need dedicated SQL scripts to manage database schema changes?▼

Yes, you need dedicated SQL scripts to define, apply, and roll back database schema changes. This Skill relies on SQL scripts to structure migration logic for PostgreSQL and MySQL environments, ensuring safe deployments.

Related Skills

Explore More Software Engineering Skills→
inbharataiinbharatai
22

db-schema-designer

Design normalized relational database schemas with ERDs, indexes, constraints, and migration scripts.

Community
Intermediate
paleoterrapaleoterra
2

sqlite-test-validator

Validate SQLite migrations and schemas with sqlite_validator.py CLI commands.

Community
Intermediate
pluginagentmarketplacepluginagentmarketplace
1

migrations

Version-control database schema migrations with rollback plans and audit trails.

Community
Advanced
ntaksh42ntaksh42
1

database-migration-generator

Generate SQL and TypeORM database migration scripts with rollback support.

Community
Intermediate