PostgreSQL
Bundled PostgreSQL and managed Postgres prerequisites
The Helm chart bundles PostgreSQL 18 with pgvector by default (infra.db.enabled: true). No external database is required for standard deployments; the bundled instance pre-creates every database the enabled services need and installs pgvector where it is used.
Bring your own managed Postgres
If you prefer a managed instance (RDS, Cloud SQL, Azure Database for PostgreSQL, Supabase, Neon, CloudNativePG, …), set infra.db.enabled: false and have the following in place before helm install. drizzle-kit migrate does not create databases, so a missing one surfaces as failed migration Jobs, or a Lakekeeper pod stuck in init, shortly after install.
| Requirement | Notes |
|---|---|
| Version | PostgreSQL 15 or later. |
| pgvector | Must be installable. RDS ≥ 15.3, Cloud SQL 15+, Azure Flexible Server with azure.extensions=VECTOR, Supabase and Neon ship it. |
| Lakekeeper extensions | uuid-ossp, pgcrypto, pg_trgm, btree_gin and btree_gist, when infra.lakekeeper.enabled: true (the default). |
| Migration role | CREATE TABLE, CREATE INDEX and CREATE EXTENSION on each database, plus CREATEROLE for the tenant-isolation role the migrations create. See Tenant-isolation role. |
| TLS | sslmode=require at minimum. |
Databases to pre-create. One per enabled component. Every component is enabled by default, so plan for all seven unless you have disabled one:
| Database | Required when | pgvector? | Rename with |
|---|---|---|---|
auth | always | yes | — |
agentic | always | yes | — |
analytics | analytics.enabled: true (default) | no | — |
cortex | cortex.enabled: true (default) | yes | cortex.database.name |
events | eventBackbone.enabled: true (default) | no | eventBackbone.database.name |
ontology | apiOntology.enabled: true (default) | no | apiOntology.database.name |
lakekeeper | infra.lakekeeper.enabled: true (default) | no | infra.lakekeeper.database.name |
The SQL to run, the infra.db.external.* values that point each service at its database, per-provider notes and connection-pooling guidance are in Managed Postgres (BYO Database).