Skip to content
Abacus

Database

Migrations

Section titled “Migrations”

Apply pending database migrations:

Terminal window
pnpm cli db:migrate

Migrations also run automatically on pnpm build.

Statistics

Section titled “Statistics”

View database statistics:

Terminal window
pnpm cli stats

Shows:

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

Fix Duplicates

Section titled “Fix Duplicates”

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

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


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