Prisma Integration

Cepress Generator offers first-class support for Prisma as the default ORM for PostgreSQL and MySQL setups.

Generated Files

  • • prisma/schema.prisma — Your data models and DB config
  • • src/models/ — Model logic (optional)
  • • .env — Contains DATABASE_URL for connection

Common Commands

Prisma commands 
# Generate Prisma client
npx prisma generate

# Run database migration
npx prisma migrate dev --name init

# Open Prisma Studio (optional)
npx prisma studio

Using Prisma Client

Once you've generated the Prisma client, you can use it to interact with your database:

Prisma client usage 
import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient();

// Use prisma to query and mutate data
const user = await prisma.user.findUnique({ where: { id: 1 } });
await prisma.user.create({ data: { name: 'John Doe' } });