Prisma

Next-generation Node.js ORM commands. Migrate databases, generate clients, seed data, and manage schemas.

40 commands

Browse by Topic

Getting Started

Quick setup and installation

3commands

Migrate

Database migrations

11commands

Generate

Client generation

9commands

Database

Database operations

10commands

Studio

Visual database browser

7commands

Install Prisma

$ npm install prisma --save-dev

Install Prisma as a dev dependency in your project

Initialize Prisma

$ npx prisma init

Initialize Prisma with a default schema and .env file

Check Prisma version

$ npx prisma --version

Display installed Prisma version and engine info

Deploy migrations

$ npx prisma migrate deploy

Apply pending migrations to production/staging

Create and apply migration

$ npx prisma migrate dev

Create migration from schema changes and apply to dev database

Create migration without applying

$ npx prisma migrate dev --name <name> --create-only

Generate migration SQL file without applying it to the database

Migration with name

$ npx prisma migrate dev --name <name>

Create named migration from schema changes

Show schema diff

$ npx prisma migrate diff --from-schema-datamodel prisma/schema.prisma --to-schema-datasource prisma/schema.prisma

Show differences between schema and database

Diff between two schemas

$ npx prisma migrate diff --from-schema-datamodel prisma/old.prisma --to-schema-datamodel prisma/schema.prisma --script

Generate SQL script of differences between two schema files

Reset database

$ npx prisma migrate reset

Reset database and apply all migrations

Reset without seeding

$ npx prisma migrate reset --skip-seed

Reset database and apply migrations without running the seed script

Resolve migration

$ npx prisma migrate resolve --applied <migration>

Mark a migration as applied (fix failed migration)

Mark migration as rolled back

$ npx prisma migrate resolve --rolled-back <migration>

Mark a failed migration as rolled back to unblock the migration table

Migration status

$ npx prisma migrate status

Check the status of migrations

Format schema

$ npx prisma format

Format the Prisma schema file

Generate Prisma Client

$ npx prisma generate

Generate Prisma Client from schema

Generate from custom schema path

$ npx prisma generate --schema ./custom/path/schema.prisma

Generate client using a schema file at a non-default location

Generate with watch

$ npx prisma generate --watch

Watch schema changes and regenerate client

Initialize Prisma

$ npx prisma init

Initialize Prisma in current project

Initialize with datasource

$ npx prisma init --datasource-provider postgresql

Initialize Prisma with specific database provider

Initialize with SQLite

$ npx prisma init --datasource-provider sqlite

Initialize Prisma with SQLite for local development

Initialize with connection URL

$ npx prisma init --url postgresql://user:pass@localhost:5432/mydb

Initialize Prisma and set the database connection URL directly

Validate schema

$ npx prisma validate

Validate the Prisma schema

Execute SQL file

$ npx prisma db execute --file script.sql

Execute raw SQL file against database

Execute SQL against specific datasource

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

Execute raw SQL using the datasource from a specific schema file

Execute SQL from stdin

$ echo "SELECT 1;" | npx prisma db execute --stdin

Execute raw SQL piped through standard input

Pull schema from database

$ npx prisma db pull

Introspect database and update schema

Force pull (overwrite schema)

$ npx prisma db pull --force

Introspect database and overwrite existing schema models

Pull with custom schema path

$ npx prisma db pull --schema ./custom/schema.prisma

Introspect database using a schema file at a custom path

Push schema to database

$ npx prisma db push

Push schema changes directly to database (no migration)

Push with data loss acceptance

$ npx prisma db push --accept-data-loss

Push schema changes that may result in data loss

Push without generating client

$ npx prisma db push --skip-generate

Push schema changes without triggering prisma generate

Seed database

$ npx prisma db seed

Run database seed script

Debug Prisma commands

$ DEBUG='*' npx prisma generate

Run any Prisma command with full debug logging output

Set Prisma log queries

$ PRISMA_LOG_LEVEL=query npx prisma studio

Start Prisma Studio with query-level logging enabled

Open Prisma Studio

$ npx prisma studio

Open visual database browser

Studio without auto-open browser

$ npx prisma studio --browser none

Launch Prisma Studio without opening a browser window

Studio on custom port

$ npx prisma studio --port 5555

Open Prisma Studio on custom port

Studio with custom schema

$ npx prisma studio --schema ./custom/schema.prisma

Open Prisma Studio using a schema file at a non-default path

Check Prisma version

$ npx prisma version

Show installed Prisma version info

Discussion

Loading comments...

Prisma

Next-generation Node.js ORM commands. Migrate databases, generate clients, seed data, and manage schemas.

40 commands

Browse by Topic

Getting Started

Quick setup and installation

3commands

Migrate

Database migrations

11commands

Generate

Client generation

9commands

Database

Database operations

10commands

Studio

Visual database browser

7commands

Install Prisma

$ npm install prisma --save-dev

Install Prisma as a dev dependency in your project

Initialize Prisma

$ npx prisma init

Initialize Prisma with a default schema and .env file

Check Prisma version

$ npx prisma --version

Display installed Prisma version and engine info

Deploy migrations

$ npx prisma migrate deploy

Apply pending migrations to production/staging

Create and apply migration

$ npx prisma migrate dev

Create migration from schema changes and apply to dev database

Create migration without applying

$ npx prisma migrate dev --name <name> --create-only

Generate migration SQL file without applying it to the database

Migration with name

$ npx prisma migrate dev --name <name>

Create named migration from schema changes

Show schema diff

$ npx prisma migrate diff --from-schema-datamodel prisma/schema.prisma --to-schema-datasource prisma/schema.prisma

Show differences between schema and database

Diff between two schemas

$ npx prisma migrate diff --from-schema-datamodel prisma/old.prisma --to-schema-datamodel prisma/schema.prisma --script

Generate SQL script of differences between two schema files

Reset database

$ npx prisma migrate reset

Reset database and apply all migrations

Reset without seeding

$ npx prisma migrate reset --skip-seed

Reset database and apply migrations without running the seed script

Resolve migration

$ npx prisma migrate resolve --applied <migration>

Mark a migration as applied (fix failed migration)

Mark migration as rolled back

$ npx prisma migrate resolve --rolled-back <migration>

Mark a failed migration as rolled back to unblock the migration table

Migration status

$ npx prisma migrate status

Check the status of migrations

Format schema

$ npx prisma format

Format the Prisma schema file

Generate Prisma Client

$ npx prisma generate

Generate Prisma Client from schema

Generate from custom schema path

$ npx prisma generate --schema ./custom/path/schema.prisma

Generate client using a schema file at a non-default location

Generate with watch

$ npx prisma generate --watch

Watch schema changes and regenerate client

Initialize Prisma

$ npx prisma init

Initialize Prisma in current project

Initialize with datasource

$ npx prisma init --datasource-provider postgresql

Initialize Prisma with specific database provider

Initialize with SQLite

$ npx prisma init --datasource-provider sqlite

Initialize Prisma with SQLite for local development

Initialize with connection URL

$ npx prisma init --url postgresql://user:pass@localhost:5432/mydb

Initialize Prisma and set the database connection URL directly

Validate schema

$ npx prisma validate

Validate the Prisma schema

Execute SQL file

$ npx prisma db execute --file script.sql

Execute raw SQL file against database

Execute SQL against specific datasource

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

Execute raw SQL using the datasource from a specific schema file

Execute SQL from stdin

$ echo "SELECT 1;" | npx prisma db execute --stdin

Execute raw SQL piped through standard input

Pull schema from database

$ npx prisma db pull

Introspect database and update schema

Force pull (overwrite schema)

$ npx prisma db pull --force

Introspect database and overwrite existing schema models

Pull with custom schema path

$ npx prisma db pull --schema ./custom/schema.prisma

Introspect database using a schema file at a custom path

Push schema to database

$ npx prisma db push

Push schema changes directly to database (no migration)

Push with data loss acceptance

$ npx prisma db push --accept-data-loss

Push schema changes that may result in data loss

Push without generating client

$ npx prisma db push --skip-generate

Push schema changes without triggering prisma generate

Seed database

$ npx prisma db seed

Run database seed script

Debug Prisma commands

$ DEBUG='*' npx prisma generate

Run any Prisma command with full debug logging output

Set Prisma log queries

$ PRISMA_LOG_LEVEL=query npx prisma studio

Start Prisma Studio with query-level logging enabled

Open Prisma Studio

$ npx prisma studio

Open visual database browser

Studio without auto-open browser

$ npx prisma studio --browser none

Launch Prisma Studio without opening a browser window

Studio on custom port

$ npx prisma studio --port 5555

Open Prisma Studio on custom port

Studio with custom schema

$ npx prisma studio --schema ./custom/schema.prisma

Open Prisma Studio using a schema file at a non-default path

Check Prisma version

$ npx prisma version

Show installed Prisma version info

Discussion

Loading comments...