myco:vault-schema-migration

What problem does it solve?

Safely migrate the vault SQLite schema by introducing versioned migrations, preventing data loss or corruption across upgrades.

Core Features & Use Cases

• Add new versions to the migration chain safely, with idempotent checks to avoid re-applying migrations.
• Write and apply safe SQL migrations (ALTER TABLE, CREATE TABLE) with optional backfill steps to populate new fields.
• Verify migrations end-to-end in a test vault and update the SCHEMA_VERSION constants accordingly.

Quick Start

Walk me through adding a new schema version, implement the migration block, and verify in a test vault.