BigHugger
sk Skill · affaan-m

prisma-patterns

Prisma ORM patterns for TypeScript backends — schema design, query optimization, transactions, pagination, and critical traps like updateMany returning count not records, $transaction timeouts, migrate dev resetting the DB, @updatedAt skipped on bulk writes, and serverless connection exhaustion. Use when writing a Prisma schema or query, or debugging transactions, migrations, or serverless connection limits.

installs 8w
1,536
30-day movement
starts with the next reading
Related entries
3
Connections
0
typescriptprismabashJavaScript

An agent skill (SKILL.md) that documents Prisma ORM patterns for TypeScript backends, covering schema design, query optimization, transactions, pagination, and common traps like updateMany returning counts, $transaction timeouts, and serverless connection exhaustion. It is structured with sections on when to use, core concepts, code examples, anti-patterns, troubleshooting, and rules.

Reach for it when writing or debugging Prisma schemas, queries, transactions, or migrations so you avoid documented pitfalls like checksum mismatches and stale @updatedAt on bulk writes.

Use it to

  • Design or modify a Prisma schema with proper indexes and ID strategy
  • Write cursor pagination and avoid N+1 queries
  • Choose the right $transaction form and handle its timeout
  • Plan safe migrations, including expand-and-contract for breaking changes
  • Configure connection pooling for serverless deployments

For TypeScript backend developers using Prisma ORM

Host repository
affaan-m/ECC
Installs, lifetime
2,900
Installs, 8 weeks
1,536
Host stars
261k
Host language
JavaScript
topicsprismatypescriptormdatabasemigrationstransactions