# Prisma

> Prisma TypeScript ORM with migrations. Use for database access.

- Skill: `g1joshi/prisma` (Agent Skill)
- Install (CLI): `npx skillmds@latest add g1joshi/prisma`
- Raw SKILL.md: https://api.skillmd.com/api/skills/g1joshi/prisma/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: G1Joshi (https://skillmd.com/u/g1joshi)
- Updated: 2026-09-10
- Page: https://skillmd.com/skills/g1joshi/prisma

---


# Prisma

Prisma 6 (2025) adds multi-schema support and **Edge support** (Cloudflare Workers) via driver adapters. It is known for its type-safe client.

## When to Use

- **TypeScript**: The `PrismaClient` generated types are unmatched.
- **Relational DBs**: Postgres, MySQL, SQL Server.
- **Productivity**: `schema.prisma` is an easy-to-read source of truth.

## Core Concepts

### Schema (`schema.prisma`)

Defines models and relationships.

### Prisma Client

Auto-generated query builder. `prisma.user.findMany()`.

### Migrate

Declarative migrations. `prisma migrate dev`.

## Best Practices (2025)

**Do**:

- **Use Driver Adapters**: For serverless/edge environments (`@prisma/adapter-neon`).
- **Use `relationMode = "prisma"`**: If utilizing PlanetScale or Vitess.
- **Check generated SQL**: Use `$on('query')` to verify performance.

**Don't**:

- **Don't N+1**: Be careful with nested reads inside loops. Use `include`.

## References

- [Prisma Documentation](https://www.prisma.io/)