Database

Migrations

Apply pending database migrations:

pnpm cli db:migrate

Migrations also run automatically on pnpm build.

Statistics

View database statistics:

pnpm cli stats

Shows:

• Total usage records
• Records per provider
• Date range of data
• Top users by token count

Fix Duplicates

Remove duplicate usage records (rare, but can happen from sync issues):

# Dry run - see what would be deleted
pnpm cli fix:duplicates

# Execute the cleanup
pnpm cli fix:duplicates --execute