# push (Prisma CLI v7) (/docs/cli/v7/db/push)

> For the complete Prisma documentation index, see [llms.txt](https://www.prisma.io/docs/llms.txt). A markdown version of any docs page is available by appending `.md` to its URL.

Push the state from your Prisma schema to your database

Location: CLI > v7 > db > 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.

## Usage [#usage]

```bash
prisma db push [options]
```

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

## Prerequisites [#prerequisites]

Configure your database connection in `prisma.config.ts`:

```prisma file=schema.prisma
generator client {
  provider = "prisma-client"
  output   = "../generated/prisma"
}

datasource db {
  provider = "sqlite"
}
```

```typescript file=prisma.config.ts
import { defineConfig, env } from "prisma/config";

export default defineConfig({
  schema: "prisma/schema.prisma",
  migrations: {
    path: "prisma/migrations",
  },
  datasource: {
    url: env("DATABASE_URL"),
  },
});
```

## Options [#options]

| Option               | Description                                             |
| -------------------- | ------------------------------------------------------- |
| `-h`, `--help`       | Display help message                                    |
| `--config`           | Custom path to your Prisma config file                  |
| `--schema`           | Custom path to your Prisma schema                       |
| `--url`              | Override the datasource URL from the Prisma config file |
| `--accept-data-loss` | Ignore data loss warnings                               |
| `--force-reset`      | Force a reset of the database before push               |

> [!WARNING]
> In Prisma v7, `db push` no longer runs `prisma generate` automatically. Run it explicitly if needed.

## Examples [#examples]

### Push the schema to the database [#push-the-schema-to-the-database]

  

#### bun

```bash
bunx prisma db push
```

#### pnpm

```bash
pnpm prisma db push
```

#### yarn

```bash
yarn prisma db push
```

#### npm

```bash
npx prisma db push
```

### Accept data loss [#accept-data-loss]

Proceed even if the changes might result in data loss:

  

#### bun

```bash
bunx prisma db push --accept-data-loss
```

#### pnpm

```bash
pnpm prisma db push --accept-data-loss
```

#### yarn

```bash
yarn prisma db push --accept-data-loss
```

#### npm

```bash
npx prisma db push --accept-data-loss
```

### Specify a schema path [#specify-a-schema-path]

  

#### bun

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

#### pnpm

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

#### yarn

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

#### npm

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

### Force reset before push [#force-reset-before-push]

Reset the database before applying changes:

  

#### bun

```bash
bunx prisma db push --force-reset
```

#### pnpm

```bash
pnpm prisma db push --force-reset
```

#### yarn

```bash
yarn prisma db push --force-reset
```

#### npm

```bash
npx prisma db push --force-reset
```

## See also [#see-also]

* [Conceptual overview of `db push` and when to use it over Prisma Migrate](https://www.prisma.io/docs/orm/v7/prisma-migrate/workflows/prototyping-your-schema)
* [Schema prototyping with `db push`](https://www.prisma.io/docs/orm/v7/prisma-migrate/workflows/prototyping-your-schema)

## Related pages

- [`execute`](https://www.prisma.io/docs/cli/v7/db/execute): Execute native commands to your database
- [`pull`](https://www.prisma.io/docs/cli/v7/db/pull): Pull the state from the database to the Prisma schema using introspection
- [`seed`](https://www.prisma.io/docs/cli/v7/db/seed): Seed your database with test or initial data using custom scripts