Prisma Relations 101

One-to-one, one-to-many, many-to-many — the three relation shapes in Prisma and when to use each.

April 11, 2026

The Three Shapes

Every relation in a relational database is one of three shapes:

One-to-one — a user has one profile
One-to-many — a user has many posts
Many-to-many — a post has many tags and a tag has many posts

Prisma has idiomatic syntax for all three. Once you see them side by side, the pattern clicks.

One-to-Many (the most common)

A User has many Post rows. The foreign key lives on the Post side.

model User {
  id    Int    @id @default(autoincrement())
  email String @unique
  posts Post[]
}

model Post {
  id       Int    @id @default(autoincrement())
  title    String
  authorId Int
  author   User   @relation(fields: [authorId], references: [id])
}

The posts field on User is virtual — Prisma uses it for queries like include: { posts: true } but there's no column for it. The real data is the authorId column on Post.

One-to-One

A User has one Profile

@unique

model User {
  id      Int      @id @default(autoincrement())
  profile Profile?
}

model Profile {
  id     Int  @id @default(autoincrement())
  bio    String
  userId Int  @unique
  user   User @relation(fields: [userId], references: [id])
}

model Post {
  id   Int       @id @default(autoincrement())
  tags PostTag[]
}

model Tag {
  id    Int       @id @default(autoincrement())
  name  String    @unique
  posts PostTag[]
}

model PostTag {
  postId Int
  tagId  Int
  post   Post @relation(fields: [postId], references: [id])
  tag    Tag  @relation(fields: [tagId], references: [id])

  @@id([postId, tagId])
}

// Fetch a user with their first 10 posts
const user = await prisma.user.findUnique({
  where: { id: 1 },
  include: {
    posts: {
      take: 10,
      orderBy: { createdAt: "desc" },
    },
  },
});

// BAD — N+1 queries
const posts = await prisma.post.findMany();
for (const post of posts) {
  const author = await prisma.user.findUnique({ where: { id: post.authorId } });
}

// GOOD — 1 query
const posts = await prisma.post.findMany({ include: { author: true } });

Prisma Relations 101

The Three Shapes

One-to-Many (the most common)

One-to-One

Related Articles

Many-to-Many (explicit)

Querying Relations

The N+1 Trap

Next.js App Router — A Practical Guide

Server Actions, Explained Simply

Tailwind CSS Without the Bloat