Using Prisma CLI Commands
1. Formatting Schema
npx prisma format| Aspect | Detail |
|---|---|
| Alignment | Columns padded |
| Lint | Catches obvious issues |
2. Validating Schema
| Command | Use |
|---|---|
prisma validate | Detect schema errors |
| CI gate | Run on every PR |
3. Pulling Database Schema
| Command | Detail |
|---|---|
db pull | Update schema.prisma from DB |
| Idempotent | Preserves annotations |
4. Pushing Schema Changes
npx prisma db push --accept-data-loss| Aspect | Detail |
|---|---|
| No history | Direct schema sync |
| Use case | Prototyping, MongoDB |
| Risk | Can drop data without flag |
5. Seeding Database
npx prisma db seed| Config | Detail |
|---|---|
| package.json | "prisma": { "seed": "tsx prisma/seed.ts" } |
6. Opening Prisma Studio
| Command | Detail |
|---|---|
prisma studio | Default port 5555 |
--port 5566 | Custom port |
7. Generating Client
| Command | Detail |
|---|---|
prisma generate | Rebuild artifacts |
--watch | Regenerate on change |
8. Running Migrations
| Command | Stage |
|---|---|
migrate dev | Development |
migrate deploy | Production |
migrate reset | Wipe + reapply |
migrate status | Inspect |
migrate diff | Compare states |
9. Using Environment Variables
| Flag | Detail |
|---|---|
--env-file | Load specific .env file |
--schema | Override schema path |
10. Viewing CLI Version
npx prisma --version| Field | Detail |
|---|---|
| Prisma CLI | Major version |
| Engines | Query / migration / introspection / format engine hashes |