prisma prisma db execute
Execute native commands (SQL) to your database.
Command
prisma db execute [options]
What It Does
- Connects to your database using the configured datasource
- Executes a script provided via file (
--file) or stdin (--stdin) - Useful for running raw SQL, maintenance tasks, or applying diffs from
migrate diff - Not supported on MongoDB
Options
| Option | Description |
|---|---|
--file |
Path to a file containing the script to execute |
--stdin |
Use terminal standard input as the script |
--url |
Override the datasource URL from the Prisma config file |
--config |
Custom path to your Prisma config file |
Examples
Execute from file
prisma db execute --file ./script.sql
Execute from stdin
echo "TRUNCATE TABLE User;" | prisma db execute --stdin
Execute migrate diff output
Pipe the output of migrate diff directly to the database:
prisma migrate diff \
--from-empty \
--to-schema-datamodel prisma/schema.prisma \
--script \
| prisma db execute --stdin
Configuration
Uses datasource from prisma.config.ts:
export default defineConfig({
datasource: {
url: env('DATABASE_URL'),
},
})
Use Cases
- Manual Migrations: Applying raw SQL changes
- Data Maintenance: Truncating tables, cleaning up data
- Schema Synchronization: Applying
migrate diffscripts - Debugging: Running test queries (though typically not for fetching data)
Limitations
- No Data Return: The command reports success/failure, not query results (rows). Use Prisma Client or
prisma studioto view data. - SQL Only: Primarily for SQL databases.