Skip to content

Architecture: Database

Defaults

  • SQLite default for local runs (app.db or configured path).
  • Alembic migrations under backend/alembic/versions/.

Main model areas

  • identities/users
  • storage endpoints
  • S3 accounts/users/connections
  • audit and operational data
  • bucket migration and health/billing data

Schema diagrams

The database schema diagrams are generated from the SQLAlchemy metadata in backend/app/db. The overview keeps all tables and foreign-key topology in a single readable image; detailed slices show full column lists.

Database schema overview

Detailed slices

Identity and UI access Identity and UI access database schema
Storage and S3 execution Storage and S3 execution database schema
Tags and classification Tags and classification database schema
Portal Portal database schema
Operations and audit Operations and audit database schema
Observability, quota, and billing Observability quota and billing database schema
Full monolithic fallback Full database schema

Operational note

Always apply schema migrations as part of deployment lifecycle.