Write reversible SQLite migrations with golang-migrate for the Mediaz project.
npx skills add https://github.com/kasuboski/mediaz --skill migration-writer
Please help me install this Agent Skill. Skill: migration-writer Source: https://github.com/kasuboski/mediaz/tree/main/.claude/skills/migration-writer Command: npx skills add https://github.com/kasuboski/mediaz --skill migration-writer
Writing and maintaining database migrations for the Mediaz SQLite store can be error-prone without a repeatable, reversible workflow. This skill provides expert guidance on using golang-migrate, safe table recreation, data-preserving updates, and robust rollback patterns.
Generate the next migration pair following the project's SQLite guidelines.
High-intent search queries and answers about installing and using this skill.
To write reversible SQLite migrations using golang-migrate, generate dual up/down files ensuring each schema change has a corresponding rollback. This skill enforces idempotent SQL and safe table recreation to preserve data during upgrades and downgrades.
The safest way to recreate a SQLite table during a schema migration is using data-preserving update patterns. This skill provides step-by-step templates for table recreation that ensure user data remains intact across both upgrade and downgrade operations.
Testing golang-migrate database migrations for safe rollback requires running both fresh and upgrade tests. This skill provides CI-ready testing instructions and validation patterns to verify schema reversibility and idempotency before deployment.
Yes, you can use Jet ORM with SQLite and golang-migrate. This skill guides you through regenerating Jet ORM code after schema changes, ensuring your generated models remain synchronized with your updated SQLite database structure.
SQLite schema migrations fail to roll back cleanly when SQL statements are not idempotent or down files are missing. This skill enforces dual up/down files and safety-first rules to guarantee reliable, reversible migration workflows.
FindMalekConfigure Prisma for multiple database providers and set up the client.
yuhle-qugOptimize Prisma ORM schemas, migrations, and query performance across databases.
DatTran26Execute unit, integration, e2e, and UI tests with coverage reports.
y1feng200156Manage database schema migrations with Flyway and Atlas.
