Labsco
prisma logo

prisma-cli-db-execute

✓ Official★ 8

by prisma · part of prisma/cursor-plugin

prisma db execute. Reference when using this Prisma feature.

🔥🔥🔥✓ VerifiedFreeQuick setup
#database#git
🧩 One of 7 skills in the prisma/cursor-plugin package — works on its own, and pairs well with its siblings.

prisma db execute. Reference when using this Prisma feature.

Inspect the full instructions your agent will receiveExpand

This is the exact playbook injected into your agent when the skill activates — shown here so you can audit it before installing. You don't need to read it to use the skill.

by prisma

prisma db execute. Reference when using this Prisma feature. npx skills add https://github.com/prisma/cursor-plugin --skill prisma-cli-db-execute Download ZIPGitHub8

prisma db execute

Execute native commands (SQL) to your database.

Command

Copy & paste — that's it
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

Copy & paste — that's it
prisma db execute --file ./script.sql

Execute from stdin

Copy & paste — that's it
echo "TRUNCATE TABLE User;" | prisma db execute --stdin

Execute migrate diff output

Pipe the output of migrate diff directly to the database:

Copy & paste — that's it
prisma migrate diff \
 --from-empty \
 --to-schema-datamodel prisma/schema.prisma \
 --script \
| prisma db execute --stdin

Use Cases

  • Manual Migrations: Applying raw SQL changes

  • Data Maintenance: Truncating tables, cleaning up data

  • Schema Synchronization: Applying migrate diff scripts

  • Debugging: Running test queries (though typically not for fetching data)