Charley requires PostgreSQL 16. The schema is fully idempotent — you can apply it multiple times safely.
Applying the Schema
The schema creates the following tables:
Seed Data (Development)
To populate the database with a test organization and sample telemetry:
The seed creates:
- 1 test organization
- 1 ORG_ADMIN member (matched by email — update
seed.sql to match your Auth0 user’s email)
- 2 test devices
- 30 days of daily telemetry rollups
- 48 hours of hourly telemetry rollups
Only apply seed.sql to development databases. It inserts fixed IDs that will conflict if applied to a database that already has data.
Running Locally with Docker
The repository includes a docker-compose.yml for local development:
pgAdmin is available at http://localhost:5050 when started with --tools.
Connection Details (local Docker)
Migrations
There is no migration framework in the current codebase — the schema is maintained as a single idempotent schema.sql. For production schema changes, apply DDL statements manually or through your database management tooling. 
