cambium-database-migrations

What problem does it solve?

Prevents destructive or failing deployments caused by EF Core and PostgreSQL schema drift, missing columns or tables on Railway, and accidental use of automatic startup migration that can recreate or break production schemas.

Core Features & Use Cases

• Manual-first migration workflow: generate SQL from EF Core migrations, review for destructive changes, and apply to Railway deliberately instead of using MigrateAsync.
• Self-healing ALTER pattern: per-column ALTER with try/catch to add critical auth-related columns at startup and verification to avoid single-point failures.
• Pre-push and audit controls: run schema checks, keep manual migration records, and validate Railway state before pushing code that changes the schema.
• Use Case: use this Skill when adding entities or columns, debugging PostgreSQL errors 42703 or 42P01, or preparing a safe Railway deployment.

Quick Start

Generate the SQL script from your EF Core migration, review it for destructive operations, and apply the resulting SQL manually to the Railway database.