Configuration
Environment Variables
| Variable | Required | Description |
|---|---|---|
DATABASE_URL | ✅ | PostgreSQL connection string |
DASHBOARD_BOOTSTRAP_SECRET | ✅ | First-time admin setup secret |
GOOGLE_CLIENT_ID | ❌ | Google OAuth Client ID (dashboard login) |
GOOGLE_CLIENT_SECRET | ❌ | Google OAuth Client Secret |
GOOGLE_REDIRECT_URL | ❌ | Google OAuth redirect URL |
GOOGLE_ALLOWED_DOMAINS | ❌ | Comma-separated allowed email domains |
BRAND_THEME | ❌ | Default theme (azure, emerald, ruby, amber, orange) |
BRAND_COMPANY_NAME | ❌ | Company name for white-label |
LOG_LEVEL | ❌ | Set debug for development output |
DB_MAX_CONNS | ❌ | Max Postgres connections per pod (default: 10). Each pod also opens 1 for the readiness probe and up to 4 for webhook deduplication: keep replicas × (this value + 5) under the server's max_connections; an invalid value stops boot |
App Names
App names support lowercase letters, numbers, hyphens (-), and underscores (_). Hyphens in the app name are automatically converted to underscores for the PostgreSQL schema (e.g. my-app → schema my_app, URL /my-app/todos).
Apps and Tables
Apps, tables, columns, references, and indexes are created and edited entirely through the Dashboard (/dashboard) — there is no YAML file to author. Each app's JWT secret is generated automatically and stored in the database; each app's schema lives in its own PostgreSQL schema, isolated from every other app.
Column Types
| Type | PostgreSQL |
|---|---|
text | TEXT |
integer | INTEGER |
bigint | BIGINT |
decimal | DECIMAL |
boolean | BOOLEAN |
uuid | UUID |
timestamptz | TIMESTAMPTZ |
jsonb | JSONB |
Column Options
| Field | Description |
|---|---|
required | NOT NULL constraint |
unique | UNIQUE constraint |
default | DEFAULT value (SQL expression) |
rename_from | Rename column on next provision |
references | Foreign key to another table in the same app — see below |
References (Foreign Keys)
A column can declare a foreign key to another table in the same app:
| Field | Description |
|---|---|
table | Target table name (must exist in the same app) |
column | Target column — must be id or a column declared unique |
on_delete | cascade, restrict, set_null, or no_action (default) |
Cross-app references are not supported — each app's schema is isolated. Circular foreign key dependencies between tables are rejected before any schema change is applied.
Indexes
A table can declare any number of indexes, each with one or more columns:
| Field | Description |
|---|---|
name | Index name, unique across the app |
columns | One or more column names, in the order the index should use |
unique | Creates a UNIQUE INDEX instead of a regular one |
Indexes are created idempotently. Removing an index from a table's definition does not drop it from the database — dropping an index is a manual operation.