Database Integration with Prisma ORM in Next.js 15

Prisma Client Singleton Pattern

// lib/prisma.ts
import { PrismaClient } from '@prisma/client';

const globalForPrisma = global as unknown as { prisma: PrismaClient };
export const prisma = globalForPrisma.prisma || new PrismaClient();
if (process.env.NODE_ENV !== 'production') globalForPrisma.prisma = prisma;

// In any Server Component or Server Action:
export async function getTutorialBySlug(slug: string) {
    return await prisma.tutorial.findUnique({
        where: { slug },
        include: { exercises: true }
    });
}