sqlx-migrations

What problem does it solve?

This Skill simplifies and secures the management of SQLx migrations by enforcing a consistent workflow, embedding migrations in binaries when desired, and providing a safe CLI path for deployment.

Core Features & Use Cases

• File naming convention for migrations (timestamped up migrations) to ensure deterministic order.
• Destructive DDL safety: require marker -- @destructive on the first line of destructive migrations.
• Dual deployment strategies: compile-time embedding via sqlx::migrate!() and sqlx-cli at deploy.
• CI validation: automated checks to ensure migrations apply cleanly in fresh databases.

Quick Start

Create a new migration with sqlx migrate add <name> and enable compile-time embedding with sqlx::migrate!() in your startup code.