---

name: database description: Database - schema, indexes, migrations. Use when working with databases.

Database Guideline

Tech Stack

• Database: Neon (Postgres)
• ORM: Drizzle
• Migrations: Drizzle Kit

Non-Negotiables

• All database access through Drizzle (no raw SQL unless necessary)
• Migration files must exist, be complete, and be committed
• CI must fail if schema changes aren't represented by migrations
• No schema drift between environments
• Drizzle schema is SSOT for database structure

Context

Database handles physical implementation — schema, indexes, migrations, query performance. Conceptual modeling (entities, relationships) lives in data-modeling.

Drizzle is the SSOT for database access. Type-safe, end-to-end.

Driving Questions

• Is all database access through Drizzle?
• Are migrations complete and committed?
• What constraints are missing that would prevent invalid state?
• Where are missing indexes causing slow queries?
• What queries are N+1 or unbounded?