Agent skill
prisma-client-api
Prisma Client API reference covering model queries, filters, operators, and client methods. Use when writing database queries, using CRUD operations, filtering data, or configuring Prisma Client. Triggers on "prisma query", "findMany", "create", "update", "delete", "$transaction".
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/other/other/prisma-client-api-devkit-stack-claude
Metadata
Additional technical details for this skill
- author
- prisma
- version
- 7.0.0
SKILL.md
Prisma Client API Reference
Complete API reference for Prisma Client. This skill provides guidance on model queries, filtering, relations, and client methods for Prisma ORM 7.x.
When to Apply
Reference this skill when:
- Writing database queries with Prisma Client
- Performing CRUD operations (create, read, update, delete)
- Filtering and sorting data
- Working with relations
- Using transactions
- Configuring client options
Client Instantiation (v7)
import { PrismaClient } from '../generated/client'
import { PrismaPg } from '@prisma/adapter-pg'
const adapter = new PrismaPg({
connectionString: process.env.DATABASE_URL
})
const prisma = new PrismaClient({ adapter })
Model Query Methods
| Method | Description |
|---|---|
findUnique() |
Find one record by unique field |
findUniqueOrThrow() |
Find one or throw error |
findFirst() |
Find first matching record |
findFirstOrThrow() |
Find first or throw error |
findMany() |
Find multiple records |
create() |
Create a new record |
createMany() |
Create multiple records |
createManyAndReturn() |
Create multiple and return them |
update() |
Update one record |
updateMany() |
Update multiple records |
updateManyAndReturn() |
Update multiple and return them |
upsert() |
Update or create record |
delete() |
Delete one record |
deleteMany() |
Delete multiple records |
count() |
Count matching records |
aggregate() |
Aggregate values (sum, avg, etc.) |
groupBy() |
Group and aggregate |
Query Options
| Option | Description |
|---|---|
where |
Filter conditions |
select |
Fields to include |
include |
Relations to load |
omit |
Fields to exclude |
orderBy |
Sort order |
take |
Limit results |
skip |
Skip results (pagination) |
cursor |
Cursor-based pagination |
distinct |
Unique values only |
Client Methods
| Method | Description |
|---|---|
$connect() |
Explicitly connect to database |
$disconnect() |
Disconnect from database |
$transaction() |
Execute transaction |
$queryRaw() |
Execute raw SQL query |
$executeRaw() |
Execute raw SQL command |
$on() |
Subscribe to events |
$extends() |
Add extensions |
Quick Examples
Find records
// Find by unique field
const user = await prisma.user.findUnique({
where: { email: '[email protected]' }
})
// Find with filter
const users = await prisma.user.findMany({
where: { role: 'ADMIN' },
orderBy: { createdAt: 'desc' },
take: 10
})
Create records
const user = await prisma.user.create({
data: {
email: '[email protected]',
name: 'Alice',
posts: {
create: { title: 'Hello World' }
}
},
include: { posts: true }
})
Update records
const user = await prisma.user.update({
where: { id: 1 },
data: { name: 'Alice Smith' }
})
Delete records
await prisma.user.delete({
where: { id: 1 }
})
Transactions
const [user, post] = await prisma.$transaction([
prisma.user.create({ data: { email: '[email protected]' } }),
prisma.post.create({ data: { title: 'Hello', authorId: 1 } })
])
Rule Files
Detailed API documentation:
rules/constructor.md - PrismaClient constructor options
rules/model-queries.md - CRUD operations
rules/query-options.md - select, include, omit, where, orderBy
rules/filters.md - Filter conditions and operators
rules/relations.md - Relation queries and nested operations
rules/transactions.md - Transaction API
rules/raw-queries.md - $queryRaw, $executeRaw
rules/client-methods.md - $connect, $disconnect, $on, $extends
Filter Operators
| Operator | Description |
|---|---|
equals |
Exact match |
not |
Not equal |
in |
In array |
notIn |
Not in array |
lt, lte |
Less than |
gt, gte |
Greater than |
contains |
String contains |
startsWith |
String starts with |
endsWith |
String ends with |
mode |
Case sensitivity |
Relation Filters
| Operator | Description |
|---|---|
some |
At least one related record matches |
every |
All related records match |
none |
No related records match |
is |
Related record matches (1-to-1) |
isNot |
Related record doesn't match |
Resources
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?