prisma/prisma-client-api-relations
skills/prisma-client-api-relations/SKILL.md
Relation Queries. Reference when using this Prisma feature.
$ install --global
skillsauthnpx skillsauth add prisma/cursor-plugin prisma-client-api-relationsInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Error
VirusTotalMulti-engine malware detection
70%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Mar 20, 2026, 10:42 PM110.3s2 files scanned
SKILL.md
- name:
- prisma-client-api-relations
- description:
- Relation Queries. Reference when using this Prisma feature.
- license:
- MIT
- author:
- prisma
- version:
- 7.0.0
Relation Queries
Query and modify related records.
Include Relations
Load related records:
const user = await prisma.user.findUnique({
where: { id: 1 },
include: {
posts: true,
profile: true
}
})
Filtered include
const user = await prisma.user.findUnique({
where: { id: 1 },
include: {
posts: {
where: { published: true },
orderBy: { createdAt: 'desc' },
take: 5,
select: { id: true, title: true }
}
}
})
Nested include
const user = await prisma.user.findUnique({
where: { id: 1 },
include: {
posts: {
include: {
comments: {
include: { author: true }
}
}
}
}
})
Select Relations
const user = await prisma.user.findUnique({
where: { id: 1 },
select: {
name: true,
posts: {
select: { title: true }
}
}
})
Nested Writes
Create with relations
const user = await prisma.user.create({
data: {
email: '[email protected]',
posts: {
create: [
{ title: 'Post 1' },
{ title: 'Post 2' }
]
},
profile: {
create: { bio: 'Hello!' }
}
}
})
Create or connect
const post = await prisma.post.create({
data: {
title: 'New Post',
author: {
connectOrCreate: {
where: { email: '[email protected]' },
create: { email: '[email protected]', name: 'Alice' }
}
}
}
})
Connect existing
const post = await prisma.post.create({
data: {
title: 'New Post',
author: {
connect: { id: 1 }
}
}
})
// Shorthand for foreign key
const post = await prisma.post.create({
data: {
title: 'New Post',
authorId: 1
}
})
Update Relations
Update related records
const user = await prisma.user.update({
where: { id: 1 },
data: {
posts: {
update: {
where: { id: 1 },
data: { title: 'Updated Title' }
}
}
}
})
Update many related
const user = await prisma.user.update({
where: { id: 1 },
data: {
posts: {
updateMany: {
where: { published: false },
data: { published: true }
}
}
}
})
Upsert related
const user = await prisma.user.update({
where: { id: 1 },
data: {
profile: {
upsert: {
create: { bio: 'New bio' },
update: { bio: 'Updated bio' }
}
}
}
})
Disconnect
// 1-to-1 optional
const user = await prisma.user.update({
where: { id: 1 },
data: {
profile: { disconnect: true }
}
})
// Many-to-many
const post = await prisma.post.update({
where: { id: 1 },
data: {
tags: {
disconnect: [{ id: 1 }, { id: 2 }]
}
}
})
Delete related
const user = await prisma.user.update({
where: { id: 1 },
data: {
posts: {
delete: { id: 1 }
}
}
})
// Delete many
const user = await prisma.user.update({
where: { id: 1 },
data: {
posts: {
deleteMany: { published: false }
}
}
})
Set (replace all)
// Replace all related records
const post = await prisma.post.update({
where: { id: 1 },
data: {
tags: {
set: [{ id: 1 }, { id: 2 }]
}
}
})
Relation Filters
some
At least one matches:
const users = await prisma.user.findMany({
where: {
posts: { some: { published: true } }
}
})
every
All match:
const users = await prisma.user.findMany({
where: {
posts: { every: { published: true } }
}
})
none
None match:
const users = await prisma.user.findMany({
where: {
posts: { none: { published: true } }
}
})
is / isNot (1-to-1)
const users = await prisma.user.findMany({
where: {
profile: { is: { country: 'USA' } }
}
})
Count Relations
const users = await prisma.user.findMany({
select: {
name: true,
_count: {
select: { posts: true, followers: true }
}
}
})
// { name: 'Alice', _count: { posts: 5, followers: 100 } }
Filter counted relations
const users = await prisma.user.findMany({
select: {
name: true,
_count: {
select: {
posts: { where: { published: true } }
}
}
}
})
Related Skills
prisma/prisma-upgrade-v7-schema-changes
databases
VerifiedTrustedOfficial
Schema Changes. Reference when using this Prisma feature.
4SKILL.mdUpdated Mar 20, 2026
prisma/prisma-upgrade-v7-removed-features
tools
VerifiedTrustedOfficial
Removed Features. Reference when using this Prisma feature.
4SKILL.mdUpdated Mar 20, 2026
prisma/prisma-upgrade-v7-prisma-config
tools
VerifiedTrustedOfficial
Prisma Config. Reference when using this Prisma feature.
4SKILL.mdUpdated Mar 20, 2026
prisma/prisma-upgrade-v7-esm-support
tools
VerifiedTrustedOfficial
ESM Support. Reference when using this Prisma feature.
4SKILL.mdUpdated Mar 20, 2026