Description
Self-Hosted Schema and Migrations provide the Drizzle schema, ordered SQL evolution, indexes, triggers, and policy definitions needed to operate Dots on PostgreSQL.
Self-Hosted Schema and Migrations is delivered through typed package contracts rather than a surface-specific shortcut. Its primary modules separate the public input or configuration shape from validation, durable state, and the operation that produces the result. That separation lets product surfaces and integrations invoke one implementation while tenant scope and existing domain rules remain in force. Errors stay bounded to the request instead of weakening the underlying data contract.
Selling Points
- Makes the product's durable data model deployable outside a hosted control plane.
- Preserves additive migration history and conformance checks.
- Includes performance indexes and RLS policy generation.
- Applies one typed package contract across every supported caller and surface.
- Keeps invalid inputs and unavailable dependencies from silently widening durable state.
User Story
As a self-hosting administrator, I provision and upgrade the complete Dots data layer through versioned repository artifacts. In practice, I configure or invoke the capability through a supported surface, supply only the inputs its contract accepts, and receive a result governed by the same rules as every other caller. I can inspect the resulting row, setting, event, or query state and correct my input when validation fails. I walk away with a repeatable workflow rather than a one-off client implementation.
Extension Surface
Fixed core: operators choose infrastructure and run migrations, but cannot safely redefine product tables independently.
The fixed_core rating is evidenced by packages/db/src/schema/index.ts, which defines the supported seam used by trusted callers or configuration. The capability can be composed wherever that contract is available, but its invariants are not replaced by tenant-authored executable code. This keeps extension honest: callers control documented inputs and policy choices while the package owns validation and safety.
Capabilities & Limits
- Capability: Executes the scoped workflow described above through the cited live implementation paths.
- Capability: Preserves typed validation and applicable tenant, schema, lifecycle, or service boundaries.
- Limit: This is the schema-level self-hosting capability, not a standalone database administration UI or managed backup service. Self-Hosted Schema and Migrations supports the concrete operations described here and composes them with tenant, schema, or lifecycle checks already owned by the package. It does not grant raw database access, make unsupported inputs valid, or assume that optional providers and downstream consumers exist. Callers remain responsible for permissions and meaningful configuration, and product rendering or external delivery stays outside the package unless explicitly stated.
Implementation Map
packages/db/src/schema/index.tsschemapackages/db/drizzle.config.tscompanyScopedPoliciespackages/db/src/rls/company-scoped-policies.tsdefineConfig