Help us improve the Prisma CLI 🚀

[nikolasburk]

Hey everyone 👋

We’re exploring ways to improve the Prisma CLI and would love your input! Whether you're a daily user or just getting started, your feedback can help us make the CLI experience even better.

Some questions to get you thinking:

• What are some CLI tools you love using?
• What cool CLI features have you seen that made your workflow smoother?
• Anything in the Prisma CLI that you’d love to see improved?

Drop your thoughts below! Your insights will directly shape the future of the Prisma CLI 💚

[andyjy]

RFC: prisma migrate commit sounds amazing

[andyjy]

Make prisma migrate resolve interactive:

• powerful command but not used often => always need to look up syntax
• shouldn't need to manually inspect _prisma_migrations table to figure what's gone wrong
• annoying to find/copy exact migration names

running interactively could instead connect to db via admin connection, display status of recent migrations, provide for selection of migrations by arrow keys and spacebar to select etc to flag as rolled back or successful.

[kensnyder]

This was my biggest request! I created my own (buggy) implementation using prompts because I couldn't remember any of the commands.

[andyjy]

native support for different environments e.g. dev / canary / staging / production - for different database admin connection URLs etc

currently have to do various gymnastics with env vars / dotenv files per environment before running prisma CLI commands (migrate, studio) - using mess of unruly package.json scripts as shorthand

much nicer to be able to do e.g. npx prisma migrate:deploy --env staging or npx prisma studio --env development etc

would then unlock adding per-environment restrictions/safeguards e.g. disallow migrate reset for staging / production environments

[kensnyder]

A full database reset seems to happen any time data needs deletion, even in cases where the deletion will not affect other tables. It would be great to minimize resets.

Before continuing, the CLI would warn you when a full database reset was required and why

[kensnyder]

Allow Prisma to use Bun. My application runs on Bun, but I must have Node installed if I want to use the CLI.

[Nabwin]

I think better revert command

[gaojie0910]

when i use npx prisma migrate dev --name xx --create-only i can't rollback/delete this migration if i don't need before dev/deploy.
i suggest add prisma migrate dev --name xx --create-rollback to complete this function @nikolasburk

[aviorp]

rds proxy full support