prisma-client-api-relations

OverviewHistoryStatsSecurity

npx skills add prisma/cursor-plugin --skill prisma-client-api-relations

Documentation

SKILL.md

npx skills add ...

Documentation

SKILL.md

Relation Queries. Reference when using this Prisma feature.

npx skills add prisma/cursor-plugin --skill prisma-client-api-relations

Documentation

SKILL.mdView source

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: 'alice@prisma.io',
    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: 'alice@prisma.io' },
        create: { email: 'alice@prisma.io', 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

const user = await prisma.user.update({
  where: { id: 1 },
  data: {
    posts: {
      update: {
        where: { id: 1 },
        data: { title: 'Updated Title' }
      }
    }
  }
})

const user = await prisma.user.update({
  where: { id: 1 },
  data: {
    posts: {
      updateMany: {
        where: { published: false },
        data: { published: true }
      }
    }
  }
})

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 }]
    }
  }
})

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 } }
      }
    }
  }
})

npx skills add prisma/cursor-plugin --skill prisma-client-api-relations

Documentation

SKILL.md

Relation Queries. Reference when using this Prisma feature.

npx skills add prisma/cursor-plugin --skill prisma-client-api-relations

Documentation

SKILL.mdView source

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: 'alice@prisma.io',
    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: 'alice@prisma.io' },
        create: { email: 'alice@prisma.io', 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

const user = await prisma.user.update({
  where: { id: 1 },
  data: {
    posts: {
      update: {
        where: { id: 1 },
        data: { title: 'Updated Title' }
      }
    }
  }
})

const user = await prisma.user.update({
  where: { id: 1 },
  data: {
    posts: {
      updateMany: {
        where: { published: false },
        data: { published: true }
      }
    }
  }
})

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 }]
    }
  }
})

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 } }
      }
    }
  }
})

prisma-client-api-relations

Documentation

Documentation

prisma-client-api-relations

Documentation

Relation Queries

Include Relations

Filtered include

Nested include

Select Relations

Nested Writes

Create with relations

Create or connect

Connect existing

Update Relations

Update related records

Update many related

Upsert related

Disconnect

Delete related

Set (replace all)

Relation Filters

some

every

none

is / isNot (1-to-1)

Count Relations

Filter counted relations

Documentation

Documentation

Relation Queries

Include Relations

Filtered include

Nested include

Select Relations

Nested Writes

Create with relations

Create or connect

Connect existing

Update Relations

Update related records

Update many related

Upsert related

Disconnect

Delete related

Set (replace all)

Relation Filters

some

every

none

is / isNot (1-to-1)

Count Relations

Filter counted relations