Name: Drizzle Core
Author: srinathv31

Drizzle Core Schema Patterns

Comprehensive schema definition guide for Drizzle ORM, applicable across all supported databases (PostgreSQL, MySQL, SQLite, MSSQL). Contains 9 rules across 3 categories focused on building type-safe, well-structured database schemas.

When to Apply

Reference these guidelines when:

Defining new database tables with Drizzle ORM
Setting up primary keys (single or composite)
Creating foreign key relationships between tables
Adding indexes for query performance
Implementing constraints (unique, check, not null)
Configuring default values for columns
Setting up Drizzle relations for type-safe queries

Rule Categories by Priority

Priority	Category	Impact	Prefix
1	Schema Definition	CRITICAL

Drizzle Core Schema Patterns

When to Apply

Reference these guidelines when:

Defining new database tables with Drizzle ORM
Setting up primary keys (single or composite)
Creating foreign key relationships between tables
Adding indexes for query performance
Implementing constraints (unique, check, not null)
Configuring default values for columns
Setting up Drizzle relations for type-safe queries

Rule Categories by Priority

Priority	Category	Impact	Prefix
1	Schema Definition	CRITICAL

Drizzle Core

Drizzle Core Schema Patterns

When to Apply

Rule Categories by Priority

Drizzle Core

Drizzle Core Schema Patterns

When to Apply

Rule Categories by Priority

Quick Reference

1. Schema Definition (CRITICAL)

2. Constraints (HIGH)

3. Performance & Relations (MEDIUM-HIGH)

How to Use

Full Compiled Document

Postgres Patterns

Postgres Patterns

Database Migrations

Postgres Patterns

Postgres Patterns

Jpa Patterns