Prisma ORM AI Skill Guide (Claude)

Overview & Engine Architecture

Prisma maps a declarative schema.prisma to a generated TypeScript Client. Migrate evolves the database (SQL history in prisma/migrations); the Client provides type-safe queries. Agents treat the schema as source of truth, never hand-edit prod schema, use $transaction for multi-step writes, select/include intentionally to control cost, and split pooled runtime URLs from direct URLs for migrate/admin.