Copilot-Skills prisma.instructions.md

Prisma Instructions

Auto-loaded when: Working with files matching: **/prisma/**, **/*.prisma, **/*.ts, **/*.js, **/schema.prisma

Default Behaviors

When working with Prisma:

1. Use Prisma Schema First: Define your data model in prisma/schema.prisma
2. Generate Client: Always run npx prisma generate after schema changes
3. Type Safety: Leverage generated types from Prisma Client
4. Migrations: Use npx prisma migrate for schema changes
5. Testing: Use @prisma/internals for testing databases
6. Async Patterns: Always use .disconnect() after operations

Common Workflows

Schema Definition

// prisma/schema.prisma
datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

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

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

Basic CRUD Operations

import { PrismaClient } from "@prisma/client";

const prisma = new PrismaClient();

// Create
const user = await prisma.user.create({
  data: { email: "[email protected]", name: "John" }
});

// Read
const foundUser = await prisma.user.findUnique({
  where: { id: 1 }
});

// Update
const updated = await prisma.user.update({
  where: { id: 1 },
  data: { name: "Jane" }
});

// Delete
await prisma.user.delete({ where: { id: 1 } });

await prisma.$disconnect();

With Relations

// Create with nested relations
const user = await prisma.user.create({
  data: {
    email: "[email protected]",
    posts: {
      create: [
        { title: "First Post" },
        { title: "Second Post" }
      ]
    }
  },
  include: { posts: true }
});

// Query with relations
const userWithPosts = await prisma.user.findUnique({
  where: { id: 1 },
  include: {
    posts: {
      where: { published: true },
      orderBy: { createdAt: "desc" }
    }
  }
});