← Back to Home

Prisma Cheat Sheet

Essential Prisma ORM commands

npx prisma init
Initialize a new Prisma project with schema file and .env

npx prisma init

Keywords: init, initialize, setup, new, project

npx prisma generate
Generate Prisma Client based on your schema

npx prisma generate

Keywords: generate, client, types, build

npx prisma db push
Push schema changes to database without migrations

npx prisma db push

Keywords: push, database, sync, prototype

npx prisma db pull
Pull database schema into Prisma schema file

npx prisma db pull

Keywords: pull, introspect, reverse, import

npx prisma migrate dev
Create and apply migration in development

npx prisma migrate dev --name add-user-table

Keywords: migrate, migration, dev, development

npx prisma migrate deploy
Apply pending migrations in production

npx prisma migrate deploy

Keywords: migrate, deploy, production, apply

npx prisma migrate reset
Reset database and apply all migrations

npx prisma migrate reset

Keywords: reset, migrate, clean, rebuild

npx prisma studio
Open Prisma Studio database browser

npx prisma studio

Keywords: studio, gui, browser, admin

npx prisma format
Format Prisma schema file

npx prisma format

Keywords: format, prettier, style, clean

npx prisma validate
Validate Prisma schema file

npx prisma validate

Keywords: validate, check, syntax, errors

npx prisma db seed
Run database seeding script

npx prisma db seed

Keywords: seed, data, populate, fixtures

npx prisma migrate status
Check status of database migrations

npx prisma migrate status

Keywords: status, migrate, pending, applied

npx prisma migrate resolve
Resolve migration issues in production

npx prisma migrate resolve --applied 20231001000000_init

Keywords: resolve, fix, migration, issues

npx prisma db execute
Execute raw SQL against database

npx prisma db execute --file ./script.sql

Keywords: execute, sql, raw, script