Schema & type inference (Drizzle, 14 namespaces)

Generated from mcp/patterns.registry.json — do not edit by hand; change the registry and run bun run patterns:build.

Index card — the docs below are the canonical explanation; deep-tier pattern pages additionally carry invariants and emulation notes.

Category: Databases & Storage · Tier: light · Risk: medium — external managed service (Neon Postgres)

Drizzle table definitions split across 14 pgSchema() namespaces and re-exported from a single schema index for compile-time type inference.

When to use: Use when adding or changing database tables and query results need to stay type-safe end to end.

Docs

• docs/blueprint/db/relational.md (GitHub · GitLab)
• docs/stack/data/drizzle.md (GitHub · GitLab)

Code

• src/lib/server/db/schema/ (GitHub · GitLab)

Proof

• /showcases/db/relational/types

Machine-readable record: databases-schema-type-inference in mcp/patterns.registry.json.