skills.rest
oalansilva
oalansilvaCOMMUNITY
Explore all skills by this author →
GitHub

db-migration-reviewer

Assess risks in PostgreSQL database migrations before deployment.

Updated Dec 28, 2025
Search Tags:#rollback#database#schema#migration#review#risk-assessment#db-ops
One-click install
npx skills add https://github.com/oalansilva/crypto --skill db-migration-reviewer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-migration-reviewer
Source: https://github.com/oalansilva/crypto/tree/main/.codex/skills/data/db-migration-reviewer
Command: npx skills add https://github.com/oalansilva/crypto --skill db-migration-reviewer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Review database migrations to prevent downtime, data loss, and ensure safe rollback paths.

Core Features & Use Cases

  • Review migration scripts for safety, locking behavior, and data backfills.
  • Validate forward and rollback paths and dependency handling.
  • Assess impact on production databases (size and traffic) and provide actionable risk mitigations.

Quick Start

Review the latest migration script and provide a risk assessment with rollback steps.

Frequently Asked Questions about db-migration-reviewer

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

FAQPage Schema
How do I assess risks in database migrations before deployment?▼

You can validate PostgreSQL schema changes by providing migration scripts, database size, and traffic patterns to identify locking risks and ensure safe rollback strategies before deployment.

How do I validate a rollback strategy for a PostgreSQL schema change?▼

Validating a rollback strategy requires analyzing your migration scripts to confirm forward and rollback paths handle dependencies correctly, ensuring the database can safely revert schema changes without data loss.

Does this database migration review process support PostgreSQL databases with high traffic?▼

Yes, the database migration review process applies to PostgreSQL databases with varying load and downtime constraints, analyzing traffic patterns and database size to assess production impact.

What do I need to provide to review database migration scripts for downtime risks?▼

To review database migration scripts for downtime risks, you need to provide the migration scripts, database size and traffic patterns, and defined rollback strategies to receive actionable risk recommendations.

When should I review schema changes for locking behavior and data backfills?▼

You should review schema changes for locking behavior and data backfills during moderate to large scale database migrations to prevent production downtime and data loss before deployment.

Related Skills

Explore More Software Engineering Skills→
zhangzhang-111-izhangzhang-111-i
2

migration-architect

Generate phased migration plans with risk assessments and rollback procedures.

Community
Advanced
Software-Design-ClubSoftware-Design-Club
1

Backend Migrations

Automates reversible database migrations with up/down scripts and zero-downtime deployments.

Official
Basic
igmarinigmarin
22

rails-migration-safety

Plan and review Rails database migrations for safe schema changes.

Community
Advanced
hdtinh57hdtinh57
1

database

Design database schemas and migration plans with rollback guidance.

Community
Advanced