skills.rest
dudedesi12
dudedesi12COMMUNITY
Explore all skills by this author →
GitHub

database-migrator

Generate, validate, and apply PostgreSQL schema migrations with rollback support.

Updated Apr 7, 2026
Search Tags:#CI/CD#database#schema#migration#sql#schema-diff
One-click install
npx skills add https://github.com/dudedesi12/Skills --skill database-migrator-dudedesi12
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-migrator
Source: https://github.com/dudedesi12/Skills/tree/main/skills/database-migrator
Command: npx skills add https://github.com/dudedesi12/Skills --skill database-migrator-dudedesi12

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill simplifies managing and executing database schema migrations, ensuring safe and consistent updates across development and production environments.

Core Features & Use Cases

  • Migration Workflow Automation: Guides users through creating, applying, and rolling back database schema changes.
  • Schema Diffing and Validation: Compares local and remote schemas to detect drift and verify consistency.
  • Use Case: A developer modifies a table structure and wants to generate a migration, test it locally, and then deploy it safely to production.

Quick Start

Use the database-migrator skill to generate a new migration for adding a column and apply it to your database.

Frequently Asked Questions about database-migrator

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

FAQPage Schema
How do I generate and apply database schema migrations for PostgreSQL?▼

To generate and apply database schema migrations, you guide the workflow to create scripts for schema changes, test them locally, and apply the updates to your PostgreSQL database safely.

What is database schema diffing and how does it detect schema drift?▼

Database schema diffing compares local and remote database schemas to detect drift, verifying consistency by identifying structural differences between your development and production environments.

Does the migrra dependency support rolling back database schema changes in CI/CD pipelines?▼

Yes, the migrra dependency supports rolling back database schema changes, enabling safe version-controlled migrations and rollback practices within your CI/CD software engineering workflows.

Can I validate SQL schema updates before deploying to production?▼

You can validate SQL schema updates before production by using schema validation features to compare local and remote schemas, ensuring consistent and safe updates across environments.

What is the best way to manage version-controlled database migrations across development and production?▼

The best way to manage version-controlled database migrations is by automating the workflow to create, apply, and validate schema changes, ensuring consistent updates across development and production environments.

Related Skills

Explore More Software Engineering Skills→
FindMalekFindMalek
9

prisma-database-setup

Configure Prisma for multiple database providers and set up the client.

Community
Intermediate
Rune-kitRune-kit
82

db

Generate and validate database schema migrations for ORMs and raw SQL.

Official
Advanced
Guepard-CorpGuepard-Corp
156

use-gfs-cli

Manage PostgreSQL and MySQL database commits, branches, and time travel with GFS CLI.

Official
Intermediate
Orvanta-CloudOrvanta-Cloud

write-script-mysql

Create, preview, and execute MySQL query scripts programmatically.

Official
Basic