database-orm-expert

# Unified Database & ORM Expert [English](#english) | [Bahasa Indonesia](#bahasa-indonesia) --- <a name="english"></a> ## English ### Description Design schemas, select ORMs, execute zero-downtime migrations, optimize queries, and implement edge serverless databases. Covers Prisma 6, Drizzle ORM, TypeORM, Supabase CLI workflows, and Edge DBs (Neon, Cloudflare D1, Turso, Upstash). ### Trigger Conditions - Designing or migrating a production schema (blue-green, canary). - Choosing between Prisma, Drizzle ORM, or TypeORM. - Writing complex queries with joins, aggregations, or pagination. - Optimizing slow queries or N+1 problems. - Building edge-compatible serverless database connections. - Executing Supabase migrations and RLS patterns. - Managing backward-compatible massive data backfills. ## Orchestration & Integration - `js-backend-expert`: For Node/Bun/Deno backend implementations integrating these ORMs. - `ci-cd-devops-architect`: For automated migration deployment steps. - `supabase-security-expert`: For Supabase RLS and security. - `cloud-hosting-expert`: For infrastructure integration. --- ### Core ORM & Query Strategies #### ORM Selection Guide | Criteria | Prisma 6 | Drizzle ORM | TypeORM | |---|---|---|---| | **Type Safety** | Schema-generated types | SQL-like, inferred types | Decorator-based | | **Bundle Size** | Heavy (binary client) | Lightweight (<35KB) | Medium | | **Query Style** | Fluent ORM API | SQL-first, compos...