skills.rest
UnionStreetAI
UnionStreetAIOFFICIAL
Explore all skills by this author →
GitHub

migration-review

Review database migrations for schema diffs, locking risk, and rollback strategy before applying to Neon.

Updated May 6, 2026
Search Tags:#code review#rollback#database migration#neon#postgres#schema review#locking risk
One-click install
npx skills add https://github.com/UnionStreetAI/unionstreet --skill migration-review-unionstreetai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: migration-review
Source: https://github.com/UnionStreetAI/unionstreet/tree/main/plugins/neon/skills/migration-review
Command: npx skills add https://github.com/UnionStreetAI/unionstreet --skill migration-review-unionstreetai

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Applying database migrations without review can cause irreversible schema changes, table locking, or failed rollbacks on Neon-hosted Postgres databases. This Skill provides a structured pre-flight review of migrations before they are applied. ## Core Features & Use Cases - Schema Diff Review: Examine schema changes to catch unintended alterations before they reach the database. - Risk Detection: Identify irreversible operations, locking risk, and problematic data migrations. - Rollback Strategy: Evaluate whether a migration has a viable rollback path. - Use Case: Before deploying a new feature that adds columns and backfills data on your Neon database, run this review to confirm the migration will not lock critical tables and can be safely rolled back. ## Quick Start Review the pending database migration files in this project and flag any irreversible operations, locking risks, or missing rollback strategy before applying them to Neon.

Frequently Asked Questions about migration-review

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

FAQPage Schema
How do I review database migrations before applying them to Neon?▼

Run a migration review that examines schema diffs, flags irreversible operations, assesses locking risk, and checks the rollback strategy. This catches dangerous changes before they execute against your Neon Postgres database.

What risks should I check in a Postgres migration?▼

Check for irreversible operations like dropping columns or tables, locking risk from operations that rewrite tables, unsafe data migrations, and missing rollback paths. These are the main causes of failed or damaging deployments.

Can this review detect table locking issues in migrations?▼

Yes, locking risk is one of the explicit review dimensions. The review examines migration operations for statements likely to hold locks on tables, which can block reads and writes in production.

Does the migration review apply migrations automatically?▼

No, the review only analyzes migrations before they are applied. It evaluates schema diffs, irreversibility, locking, and rollback strategy so you can decide whether it is safe to proceed.

When should I not rely on a pre-apply migration review?▼

A static review cannot predict runtime data volume effects, such as how long a backfill takes on a large table. For high-risk changes, combine the review with testing against a staging branch of your Neon database.

Related Skills

Explore More Software Engineering Skills→
linenoizelinenoize
1

db

Generate rollback-aware database migration files and validate schema changes.

Community
Advanced
astrovilleastroville

migration-safety

Plan database, API, and library migrations with rollback strategies and zero-downtime techniques.

Official
Intermediate
XeXe
732

neon-postgres-branches

Create and manage Neon Postgres branches for migration testing and isolated development environments.

Community
Intermediate
ludicroushqludicroushq

convex-migration-helper

Plan and execute Convex migrations using the widen-narrow workflow.

Official
Advanced