Database Operations with Prisma

Create database operations following Pixel Studio's established patterns.

Prisma Client Import

Always use the singleton client:

import { prisma } from "~/services/prisma.server";

Never create a new PrismaClient instance directly.

Server Function Structure

Server functions go in app/server/ with .server.ts suffix: