prisma db execute | Run SQL Scripts on Database

The prisma db execute command applies a SQL script to the database without interacting with the Prisma migrations table.

This command is currently not supported on MongoDB.

Usage

prisma db execute [options]

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

The script input must be provided using either --file or --stdin. The whole script is sent as a single command to the database.

The output is connector-specific and reports success or failure only—it's not meant for returning data.

Prerequisites

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"),
  },
});

Options

Option	Description
`-h`, `--help`	Display help message
`--config`	Custom path to your Prisma config file
`--file`	Path to a file containing the script to execute

Flags

Flag	Description
`--stdin`	Use terminal standard input as the script to execute

Either --file or --stdin is required.

Prisma v7 breaking change: The --schema and --url options have been removed. Configure your database connection in prisma.config.ts instead.

Examples

Execute a SQL file

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

Execute SQL from stdin

echo 'TRUNCATE TABLE dev;' | prisma db execute --stdin

execute