ServicesSupabase
Development
Set up Supabase locally for development.
Start Supabase
pnpm supabase:startThis starts PostgreSQL, Auth, Studio, and all Supabase services locally.
Configure environment
Copy the output keys into your .env:
SUPABASE_URL=http://127.0.0.1:54321
SUPABASE_ANON_KEY=<from output>
SUPABASE_SERVICE_ROLE_KEY=<from output>The migration at services/supabase/migrations/001_initial_schema.sql creates the full schema automatically:
| 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 |
Access Studio at localhost:54323 to browse the database.
Useful commands
pnpm supabase:status # Check running services and keys
pnpm supabase:reset # Wipe and re-run migrations
pnpm supabase:stop # Stop all services