execute

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

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 is not meant for returning data.

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

  },

});

Either --file or --stdin is required.

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

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

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

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

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

• Migration troubleshooting in production