database-architect

Design normalized PostgreSQL schemas by defining Drizzle ORM tables with proper primary keys, foreign-key constraints, and relationships. Enforce 3NF normalization, use UUIDv7 primary keys, add timezone-aware timestamps, and export type-safe Select and Insert schemas for application use.

Plan migrations by versioning schema changes and defining indexes on frequently queried columns. Drizzle ORM generates migration files from schema definitions, enabling you to apply incremental updates while maintaining data integrity and query performance.

Yes, Drizzle ORM supports multi-tenant architectures through normalized schemas with tenant isolation keys, foreign-key constraints, and JSONB columns for flexible tenant-specific data. Design tables with explicit tenant references and cascade rules for data consistency.

Add optional deletedAt columns for soft deletes and createdAt/updatedAt timestamps with timezone awareness in Drizzle table definitions. Configure automatic updates on timestamps and use Drizzle's type-safe exports to ensure insert and select operations respect these fields.

Yes, Drizzle ORM fully supports PostgreSQL JSONB columns and array types. Use JSONB for semi-structured data within normalized tables and arrays for storing multiple values, enabling flexible schema design while maintaining type safety through Drizzle's type definitions.

Define explicit foreign-key constraints in Drizzle with cascade rules—CASCADE for dependent deletes, RESTRICT to prevent orphaned records, or SET NULL for optional relationships. Specify constraints in table definitions to enforce referential integrity and prevent invalid data.