database-schema-expert

Normalized database schemas in Drizzle ORM separate concerns across multiple tables with foreign key relationships, UUID primary keys, and JSONB fields for flexible metadata. Define schemas in /lib/db/schema.ts using Drizzle's table and relation helpers, then apply migrations to Supabase Postgres.

Drizzle Migrate workflows generate and apply migrations incrementally, tracking schema versions safely. Create migrations from your /lib/db/schema.ts definitions, review generated SQL, then deploy to Supabase Postgres in order to maintain consistency across environments.

Use helper functions like getUserProfile to construct optimized queries across normalized user tables with proper joins and filtering. Drizzle's query builder constructs type-safe SQL, reducing N+1 problems and improving performance in Supabase Postgres.

Yes, Drizzle supports JSONB columns natively in Postgres schemas, allowing flexible metadata storage alongside structured relational data. JSONB enables indexing and querying nested data while maintaining schema normalization for core entities.

Soft deletes and cascade relationships preserve referential integrity and audit trails while removing data logically. Configure cascade delete policies in Drizzle schemas to automatically clean up related records, protecting data consistency in multi-table environments.

Drizzle ORM integrates seamlessly with Supabase Postgres, supporting transactions, normalized schemas, and migrations. Supabase's real-time subscriptions work independently of the ORM layer, allowing you to combine Drizzle's type-safe queries with Postgres' native event broadcasting.