db-apply-migration

What problem does it solve?

This Skill automates the process of applying database migrations, ensuring data integrity and preventing concurrent modifications through advisory locks and pre/post snapshots.

Core Features & Use Cases

• Safe Migration Application: Applies SQL migrations with pre- and post-migration snapshots for rollback and auditing.
• Concurrency Control: Uses PostgreSQL advisory locks to prevent multiple migrations from running simultaneously.
• Error Handling & Rollback: Provides robust error handling, automatic transaction rollback, and clear rollback instructions.
• Use Case: Apply a schema change to a production database with confidence, knowing that you can easily revert if issues arise and that no other migration is running at the same time.

Quick Start

Use the db-apply-migration skill to apply the migration file located at migrations/001_create_users_table.sql.