Apply numbered, registry-backed migrations to AGH SQLite databases.
npx skills add https://github.com/compozy/agh --skill agh-schema-migration
Please help me install this Agent Skill. Skill: agh-schema-migration Source: https://github.com/compozy/agh/tree/main/.agents/skills/agh/agh-schema-migration Command: npx skills add https://github.com/compozy/agh --skill agh-schema-migration
This Skill prevents AGH database schema drift by forcing every SQLite schema change to go through a numbered, registry-backed migration with transactional safety and idempotence.
schema_migrations mechanism instead of fragile EnsureSchema-style reconciliation.BEGIN IMMEDIATE, guarding against re-application, and making operations resume safely after partial runs.-wal and -shm companion files are renamed alongside the .db to avoid corruption and missing-column failures after restarts.Use this skill when you are editing any AGH code path that issues SQLite DDL for persistent stores, and author a numbered migration that is registered, transactional, idempotent, recorded in schema_migrations, and covered by fresh DB and restart tests.
High-intent search queries and answers about installing and using this skill.
To safely migrate an AGH SQLite schema, apply numbered, registry-backed migrations using transactional BEGIN IMMEDIATE execution and idempotent guards to prevent partial run failures and database corruption.
Preventing SQLite schema drift in AdGuard Home requires recording every DDL change in a schema_migrations registry instead of using fragile EnsureSchema-style reconciliation, ensuring changes are tracked and applied consistently.
Missing column failures after restarts happen because the -wal and -shm companion files were not renamed alongside the .db file, causing SQLite recovery behaviors to fail when reading the updated persistent scheduler stores.
Testing SQLite schema migrations for idempotence requires running fresh-DB tests and reopen-after-restart tests to confirm schema expectations, verify data preservation, and ensure backfill behaviors survive partial execution.
You need a numbered migration registry instead of EnsureSchema when applying SQLite DDL changes to durable stores like agh.db or events.db, ensuring transactional safety and preventing out-of-band schema reconciliation.
curiositechManage Drizzle ORM schema definitions and SQLite database migrations efficiently.
saintgo7Backs up SQLite WAL-format databases by checkpointing cache and copying all three files with verification.
Niller2005Manage SQLite connections and run idempotent schema migrations for PolyFlup.
paleoterraValidate SQLite migrations and schemas with sqlite_validator.py CLI commands.