push

The prisma db push command pushes the state of your Prisma schema to the database without using migrations. It creates the database if it does not exist.

This command is a good choice when you don't need to version schema changes, such as during prototyping and local development.

prisma db push [options]

The datasource URL configuration is read from the Prisma config file (e.g., prisma.config.ts).

Configure your database connection in prisma.config.ts:

generator client {

  provider = "prisma-client"

  output   = "../generated/prisma"

}

datasource db {

  provider = "sqlite"

}

import { defineConfig, env } from "prisma/config";

export default defineConfig({

  schema: "prisma/schema.prisma",

  migrations: {

    path: "prisma/migrations",

  },

  datasource: {

    url: env("DATABASE_URL"),

  },

});

bunx prisma db push

pnpm prisma db push

yarn prisma db push

npx prisma db push

Proceed even if the changes might result in data loss:

bunx prisma db push --accept-data-loss

pnpm prisma db push --accept-data-loss

yarn prisma db push --accept-data-loss

npx prisma db push --accept-data-loss

bunx prisma db push --schema=/tmp/schema.prisma

pnpm prisma db push --schema=/tmp/schema.prisma

yarn prisma db push --schema=/tmp/schema.prisma

npx prisma db push --schema=/tmp/schema.prisma

Reset the database before applying changes:

bunx prisma db push --force-reset

pnpm prisma db push --force-reset

yarn prisma db push --force-reset

npx prisma db push --force-reset

• Conceptual overview of db push and when to use it over Prisma Migrate
• Schema prototyping with db push