database-patterns

name	database-patterns
description	Database access patterns (ORM usage, repositories, transactions, and performance). Keywords: database, ORM, prisma, transactions, queries, N+1.

Database Patterns

This skill provides practical patterns for database access in backend services.

---

Core rules

1. Keep ORM usage behind a repository boundary when queries become non-trivial.
2. Prefer explicit pagination and filtering.
3. Use transactions for multi-write operations.
4. Capture slow queries with spans/traces (where supported).

---

ORM client lifecycle

Create the DB client once per process and reuse it.

---

Transactions (example)

await db.$transaction(async (tx) => {
  await tx.user.create({ data: input });
  await tx.auditLog.create({ data: { action: "user.create" } });
});

---

Performance notes

• Avoid N+1 query patterns (use joins/includes carefully).
• Add indexes for high-cardinality query patterns.
• Prefer selecting only needed fields for large tables.

---

Related Skills

• services-and-repositories
• sentry-and-monitoring