Prisma

Database Commands

Perform direct database operations with Prisma. Push schema changes, pull existing schemas, seed data, and execute raw SQL for database management tasks.

10 commands

Pro Tips

Use 'prisma db push' for rapid prototyping — applies schema changes without creating migration files.

Use 'prisma db pull' to introspect an existing database and generate the Prisma schema from it.

Seed your database: 'prisma db seed' runs the seed script defined in package.json prisma.seed field.

Common Mistakes

'prisma db push' can drop data when removing fields or tables. It shows warnings — read them carefully.

'prisma db push' is not meant for production. It doesn't create migration history — use 'prisma migrate' instead.

Commands

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