database-orm-expert

# Database ORM Expert (Prisma 6 + Drizzle ORM Edition) [English](#english) | [Bahasa Indonesia](#bahasa-indonesia) --- <a name="english"></a> ## English ### Description Design schemas, select ORMs, execute migrations, optimize queries, and implement type-safe SQL patterns. Prioritize **Prisma 6** and **Drizzle ORM**. Implement connection pooling for production workloads. ### Trigger Conditions - Designing or migrating a database schema. - Choosing between Prisma, Drizzle ORM, or TypeORM. - Writing complex queries with joins, aggregations, or pagination. - Optimizing slow queries or N+1 problems. - Setting up database migrations in CI/CD pipelines. - Implementing Row Level Security (RLS) patterns. - Working with PostgreSQL, MySQL, SQLite, or PlanetScale. ## Orchestration & Integration - `js-backend-expert`: For Node/Bun/Deno backend implementations integrating these ORMs. - `edge-serverless-db-expert`: For edge/serverless connections (e.g., Supabase, Neon, Turso). - `database-migration-versioning-expert`: For advanced migration strategies and CI/CD pipelines. --- ### 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, composable | ActiveRecord / QueryBuilder | | **Edge Runtime** | Prisma Accelerate needed | Native edge suppor...