orm

Activate When

• /godmode:orm, "which ORM", "Prisma vs Drizzle"
• "N+1 query", "connection pool", "transaction"
• ORM usage audit for performance issues

Workflow

1. Detect Environment

grep -r "prisma\|drizzle-orm\|typeorm\|sqlalchemy" \
  package.json requirements.txt go.mod 2>/dev/null
grep -r "include:\|select_related\|joinedload" \
  --include="*.ts" --include="*.py" -l 2>/dev/null

Language: <TS|Python|Go|Ruby|Java>
ORM: <Prisma|Drizzle|TypeORM|SQLAlchemy|Django|GORM>
Database: <PostgreSQL|MySQL|SQLite>
Connection: <direct|pooler|serverless>

2. ORM Selection

TypeScript/JavaScript:

• Prisma: max type safety, great DX, schema-first. Heavy engine (~2MB). Best for most projects.
• Drizzle: SQL-first, ~30KB, edge-ready. Best for performance-critical or serverless.
• TypeORM: decorator-based, NestJS integration.

Python: SQLAlchemy 2.0 (FastAPI), Django ORM. Go: GORM, Ent, sqlc. Ruby: ActiveRecord.

IF edge/serverless: Drizzle (smallest bundle). IF max type safety: Prisma.

3. N+1 Detection & Resolution

Enable query logging, load list page, count queries. If count = 1 + N, you have N+1.

// BAD (N+1): queries in loop
const posts = await prisma.post.findMany();
for (const p of posts) {
  await prisma.user.findUnique({
    where: { id: p.authorId }
  });
}

// GOOD (1 query with JOIN)
const posts = await prisma.post.findMany({
  include: { author: true }
});

ORM equivalents: Django select_related/prefetch, SQLAlchemy joinedload/selectinload, Rails includes/eager_load, GORM Preload/Joins.

4. Connection Pooling

Formula: pool_size = (core_count * 2) + 1
Typical: 10-20 connections per instance
         | Dev  | Prod
min      | 1    | 5
max      | 5    | 20
idle_timeout | 30s | 300s

WARNING: PostgreSQL degrades above ~100 connections. Use PgBouncer/RDS Proxy for multiplexing. Coordinate: pool * instances < max_conn * 0.8.

IF pool utilization > 80%: alert and investigate.