Supabase target
Single project mode: the app uses NEXT_PUBLIC_SUPABASE_URL and related keys. To switch between local Docker and hosted cloud without editing files, add both *_LOCAL and *_CLOUD pairs in .env.local.
Active host: yvgaydpbpmpuqktxtszw.supabase.co
Backup & SQL export
Operator-run backups using Postgres tools or Supabase. In-app one-click download requires extra server configuration (database URL); use CLI until then.
Supabase (hosted)
- Dashboard → Project Settings → Database: copy the connection string for
pg_dump. - Pro projects: scheduled backups in Dashboard → Database → Backups.
- CLI:
supabase linkthensupabase db dump -f backup.sql(see Supabase CLI docs).
Local Postgres
pg_dump "$DATABASE_URL" -Fc -f backup.dump # or plain SQL: pg_dump "$DATABASE_URL" --no-owner --no-acl -f backup.sql
Restore: use pg_restore or psql against a target database; test on a staging project first.
Universe daily candles (local DB)
Populate and refresh daily_candles for all symbols in your database, then prefer local reads for historical OHLCV.
Raw filing counts: Congress rows: —, Insider rows: —.
After the DB has enough history, add PREFER_LOCAL_HISTORICAL_CANDLES=true and restart the dev server so historical paths skip Polygon (live prices still use Polygon when the market is open).
Settings
Environment variables used by this deployment. Keys and service-role values are masked; URLs and public flags are shown as configured.
Runtime
| Variable | Value |
|---|---|
| NODE_ENV | production |
Site
| Variable | Value |
|---|---|
| NEXT_PUBLIC_SITE_URL | — |
Supabase (legacy single project)
| Variable | Value |
|---|---|
| NEXT_PUBLIC_SUPABASE_URL | https://yvgaydpbpmpuqktxtszw.supabase.co |
| NEXT_PUBLIC_SUPABASE_ANON_KEY | Set · eyJh…zT6I (208 chars) |
Supabase (dual local + cloud)
| Variable | Value |
|---|---|
| NEXT_PUBLIC_SUPABASE_URL_LOCAL | — |
| NEXT_PUBLIC_SUPABASE_ANON_KEY_LOCAL | — |
| NEXT_PUBLIC_SUPABASE_URL_CLOUD | — |
| NEXT_PUBLIC_SUPABASE_ANON_KEY_CLOUD | — |
Supabase (server-only)
| Variable | Value |
|---|---|
| SUPABASE_SERVICE_ROLE_KEY | Set · eyJh…XnmY (219 chars) |
| SUPABASE_SERVICE_ROLE_KEY_LOCAL | — |
| SUPABASE_SERVICE_ROLE_KEY_CLOUD | — |
Supabase (routing)
| Variable | Value |
|---|---|
| NEXT_PUBLIC_SUPABASE_FORCE_PROFILE | cloud |
| NEXT_PUBLIC_SUPABASE_PROFILE_SWITCH | — |
| SUPABASE_DEFAULT_DATA_PROFILE | — |
| (derived) profile detection | hasDualSupabaseProfiles=false · hasLegacySupabaseEnv=true |
Market data
| Variable | Value |
|---|---|
| Provider | Stooq (no API key) |
| PREFER_LOCAL_HISTORICAL_CANDLES | — (effective: false) |