# Migration Runner

> Run and verify SeaORM database migrations against in-memory SQLite. Use when applying migrations, verifying schema changes, or testing migration correctness.

- Skill: `fritzprix/migration-runner` (Agent Skill)
- Install (CLI): `npx skillmds@latest add fritzprix/migration-runner`
- Raw SKILL.md: https://api.skillmd.com/api/skills/fritzprix/migration-runner/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: fritzprix (https://skillmd.com/u/fritzprix)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/fritzprix/migration-runner

---


# Migration Runner

Run and verify SeaORM database migrations for LibrAgent.

## Setup

```rust
use sqlx::sqlite::SqlitePoolOptions;
use sea_orm::SqlxSqliteConnector;
use tauri_mcp_agent_lib::migration::Migrator;
use sea_orm_migration::MigratorTrait;

async fn setup_db() -> sea_orm::DatabaseConnection {
    let pool = SqlitePoolOptions::new()
        .connect("sqlite::memory:")
        .await
        .unwrap();
    let db = SqlxSqliteConnector::from_sqlx_sqlite_pool(pool);
    Migrator::up(&db, None).await.unwrap();
    db
}
```

## Verification Patterns

### Schema Validation

```rust
let db = setup_db().await;
// Verify tables exist
let result = db.query_all(
    "SELECT name FROM sqlite_master WHERE type='table'"
).await.unwrap();
assert!(result.iter().any(|r| r["name"].to_string().contains("expected_table")));
```

### Migration Up/Down

```rust
let db = setup_db().await;
Migrator::up(&db, None).await.unwrap();
// Verify schema after up
Migrator::down(&db, None).await.unwrap();
// Verify schema after down
```

### Foreign Key Validation

```rust
let db = setup_db().await;
// Attempt invalid foreign key insertion
// Verify foreign key constraint is enforced
```

## Key Files

- `src-tauri/src/migration/` - Migration files
- `src-tauri/src/repositories/` - Repository implementations
- `scripts/verify_phase2_migration.sh` - Legacy migration verification
- `scripts/test_planning_module.sh` - Legacy module testing

## CI Integration

Tests must be in `src-tauri/tests/` as integration tests. Run with:

```bash
cargo test --tests
```