Skip to Content
LYNKORIADocs

ADR 007: One database across products

  • Status: Proposed
  • Owner: Security reviewer
  • Date: 2026-11-12

Context

Separate clusters per product cost more and complicate operations.

Decision

One PostgreSQL database with composite foreign keys (id, environment_id, tenant_id) so rows cannot reference another project's or tenant's conversation. A dedicated Fidescript store if the security review requires it.

Consequences

Isolation is enforced by schema, not only by queries (tested). RLS can be added as defense in depth.

On this page