--- description: "Reference pages give you exact endpoints, database view columns, environment variables, and operator runbooks for lookup." --- # Reference Reference pages give you exact endpoints, database view columns, environment variables, and operator runbooks for lookup. For step-by-step lessons, see [Tutorials](https://getmarula.com/docs/psa/next/tutorials). For task checklists, see [How-to guides](https://getmarula.com/docs/psa/next/how-to). For design reasoning, see [Explanation](https://getmarula.com/docs/psa/next/explanation). For the vocabulary the rest of the site assumes, start with the [glossary](https://getmarula.com/docs/psa/next/reference/glossary). ## Glossary and lookup - [Glossary](https://getmarula.com/docs/psa/next/reference/glossary) — the recurring PSA and Marula terms, each linked to the page that explains it. Boards and stages are in there, as are contract and billing vocabulary, provenance and audit, grants, plugins, and the N−2 window. - [Troubleshooting](https://getmarula.com/docs/psa/next/troubleshooting) — symptom first, for when something is broken rather than unconfigured. It points back into these pages. ## API, data views, and schema reference - [API reference](https://getmarula.com/docs/psa/next/reference/api) — Every endpoint in `core-api`, generated directly from the committed OpenAPI specification. - [The OpenAPI pin](https://getmarula.com/docs/psa/next/reference/openapi) — How `packages/sdk/openapi.json` and `fixtures/openapi/v1/openapi.json` stay locked in sync. - [Read model view catalog](https://getmarula.com/docs/psa/next/reference/read-model) — The stable `ops.v1_*` SQL views for custom reports and external BI tools (with per-view column definitions in `docs/reference/read-model/`). - [Billing schema reference](https://getmarula.com/docs/psa/next/reference/billing-schemas) — Tables and constraints for work-type categories, billing verification, contract pricing, and project milestone billing. - [Routing & travel reference](https://getmarula.com/docs/psa/next/reference/routing) — Environment variables, organization settings keys, warning codes, and endpoints for technician travel estimates and mileage reimbursement. - [Upgrade matrix](https://getmarula.com/docs/psa/next/reference/upgrade-matrix) — Automated CI upgrade paths verified across releases under the N-2 support policy. ## Self-hosting and operations runbooks - [The local stack](https://getmarula.com/docs/psa/next/reference/self-host-local-stack) — Docker Compose services, ports, optional profiles, the PostgreSQL migration-owner vs. RLS app-role split, container hardening, and required secrets. - [Local AI: transcription and embeddings on your own hardware](https://getmarula.com/docs/psa/next/reference/self-host-local-ai) — Why model weights stay outside the core container image and how the local `ollama` profile runs Whisper and 768-dimension embeddings. - [Embedding model catalogue](https://getmarula.com/docs/psa/next/reference/embedding-model-catalogue) — The selectable embedding models, their capacity floors, the `model@version/dimensions` space tag, custom entries, and the instance-versus-organization credential rule. - [Observability](https://getmarula.com/docs/psa/next/reference/self-host-observability) — Optional OpenTelemetry export (`Tempo`, `Loki`, `Grafana`) plus `Uptime Kuma` status monitoring. - [Backup & restore runbook](https://getmarula.com/docs/psa/next/reference/backup-restore) — How to back up PostgreSQL and Garage object storage using `pg_dump`, `restic`, or `WAL-G` point-in-time recovery, and how to rehearse restores with `deploy/backup/restore.sh`. - [Postgres 17 to 18 upgrade](https://getmarula.com/docs/psa/next/reference/pg18-upgrade) — One-time data migration guide for deployments created before the PostgreSQL 18 transition. - [Database observability](https://getmarula.com/docs/psa/next/reference/db-observability) — The query mix (`ops.query_tail`), the plan of one statement (`ops.explain_plan`), the signal readiness view (`ops.db_signals`), scheduled maintenance, and which of these a managed Postgres will not let you enable. - [Reverse proxy & TLS runbook](https://getmarula.com/docs/psa/next/reference/reverse-proxy-tls) — The public front door: required upstream routes, the streamed SSE live leg, upload size limits, Direct-mode ACME, Cloudflare Edge mode (Origin CA vs DNS-01), origin IP-range lockdown, and the trusted-proxy settings that make the resolved client IP mean something. - Desktop packaging and release workflow: `docs/desktop-release.md`. - Runbook scaffold index: `deploy/runbooks/README.md`.