Database Management

The aw db CLI commands manage the supported Allowealth database targets:

sqlite for local development

Supported Targets

Target	Use Case	Configuration
`sqlite`	Local development	`db/.dev.db`

Migrations

Generate a migration

Create a migration from schema changes:

bun run aw db generate

Apply migrations

Apply pending migrations to the selected target:

bun run aw db migrate

Schema changes

Quick development workflow

Push schema changes directly to SQLite:

bun run aw db push

Use this only in development. It bypasses migration tracking.

Reset local SQLite

Delete the local SQLite database, recreate the schema, and seed demo data:

bun run aw db reset

This command works only with the sqlite target.

Backup

Create timestamped backups for any supported target:

bun run aw db backup --target sqlite

By default, backups save to backups/sqlite-<timestamp>.db.

Use a custom path when needed:

bun run aw db backup --target sqlite --output /path/to/backup.db

Restore

Restore validates backups before applying changes and creates a safety backup unless you opt out.

Dry run

Validate a backup without restoring it:

bun run aw db restore --dry-run

Restore from local backup

# Interactive (requires confirmation)
bun run aw db restore --target sqlite

# Non-interactive
bun run aw db restore --target sqlite --force

# Skip pre-restore backup
bun run aw db restore --target sqlite --force --no-backup

# Restore a specific file
bun run aw db restore --target sqlite --file backups/sqlite-2026-03-04.sql

Restore from cloud backup

bun run aw db restore --source cloud

Cloud backups read from backups/cloud/ by default. Override the location if needed:

bun run aw db restore --source cloud --cloud-dir /path/to/cloud/backups

Data seeding

Seed demo data

bun run aw db seed --target sqlite

Control data volume

# Seed 6 months of history
bun run aw db seed --target sqlite --months=6

# Seed 12 months + 5,000 extra transactions
bun run aw db seed --target sqlite --months=12 --transactions=5000

Add benchmark data

bun run aw db seed --target sqlite --benchmark

Add stress-test data

bun run aw db seed --target sqlite --stress

Dangerous operations

Drop all tables

Delete all tables and reset the selected database:

bun run aw db drop

This command requires typed confirmation.

Empty data but keep schema

bun run aw db empty

Quality checks

Before committing database changes, run:

bun run lint:fix
bun run stylelint:fix
bun run format:fix
bun run typecheck