Database migrations

Updated Jul 27, 2026

Frankie ships Diesel migrations for its local SQLite schema. To apply any pending migrations to a database file and record the resulting schema version in telemetry, run:

frankie --migrate-db --database-url frankie.sqlite

This command does not contact GitHub. On success, Frankie records a telemetry event as a JSON line on stderr.

For testing or ephemeral usage, SQLite supports an in-memory database using the special :memory: URL:

frankie --migrate-db --database-url :memory: