ServicesSupabase
Supabase
PostgreSQL database, authentication, and real-time APIs.
Supabase provides the database, authentication, and real-time features for the Console app.
Schema
The migration at services/supabase/migrations/001_initial_schema.sql creates the full schema:
| Table | Purpose |
|---|---|
profiles | User profiles (auto-created on signup) |
instances | Agent instances per user (status: pending → provisioning → running) |
subscriptions | LemonSqueezy subscription records |
provision_jobs | Async job queue polled by the worker |
Enums
| Enum | Values |
|---|---|
instance_status | pending, provisioning, running, destroying, destroyed |
job_type | provision, destroy |
job_status | pending, processing, completed, failed |
Key paths
| Path | Description |
|---|---|
services/supabase/config.toml | Local development configuration |
services/supabase/migrations/ | Database migrations |