migration

Automate SQLite migration creation and validation for schema changes.

2|Updated Nov 17, 2025
One-click install
npx skills add https://github.com/birdgg/moe-bangumi --skill migration-birdgg
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: migration
Source: https://github.com/birdgg/moe-bangumi/tree/main/.agents/skills/migration
Command: npx skills add https://github.com/birdgg/moe-bangumi --skill migration-birdgg

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates the creation and validation of SQLite migrations to keep schema changes aligned with application queries and domain models.

Core Features & Use Cases

  • Migration file generation: Create timestamped SQL files in migrations/ following best practices.
  • Query coherence: Update and synchronize INSERT/UPDATE column lists across related code paths.
  • Safe evolution: Ensure migrations are atomic and reversible where appropriate.

Quick Start

Create a new migration to modify the schema and verify all affected queries and domain models are updated accordingly.

Frequently Asked Questions about migration

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

FAQPage Schema
How do I automate SQLite schema migrations and keep domain models in sync?

You can automate SQLite schema migrations by generating timestamped SQL files and updating related data access code, ensuring INSERT and UPDATE column lists stay synchronized with domain types throughout your codebase.

How does query coherence work when adding columns to an SQLite database?

Query coherence during SQLite schema changes involves automatically updating INSERT and UPDATE column lists across related code paths, ensuring application queries and domain models remain consistent after adding columns or creating tables.

What's the best way to validate SQLite migrations and build integrity?

The best way to validate SQLite migrations is to touch Embedded.hs, update migration SQL and domain types, then check build integrity to ensure schema changes align with application queries and data access code.

Can I make atomic and reversible SQLite schema changes automatically?

Yes, you can create atomic and reversible SQLite schema changes by generating migration files that follow best practices, ensuring safe evolution of your database schema where appropriate.

Do I need to update data access code when altering an SQLite schema?

Yes, when altering an SQLite schema you must update the migration SQL, domain types, and related data access code to keep schema changes aligned with application queries and maintain build integrity.

Why are my SQLite migrations causing build failures after schema changes?

SQLite migrations may cause build failures when related queries and domain models are not updated alongside schema changes, requiring synchronization of INSERT and UPDATE column lists and validation of build integrity.