prisma-cli

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Prisma CLI Reference

Prisma CLI 参考手册

Complete reference for all Prisma CLI commands. This skill provides guidance on command usage, options, and best practices for Prisma ORM 7.x.

Prisma CLI所有命令的完整参考。本技能为Prisma ORM 7.x版本提供命令用法、选项及最佳实践指导。

When to Apply

适用场景

Reference this skill when:

Setting up a new Prisma project (
```
prisma init
```
)
Generating Prisma Client (
```
prisma generate
```
)
Running database migrations (
```
prisma migrate
```
)
Managing database state (
```
prisma db push/pull
```
)
Using local development database (
```
prisma dev
```
)
Debugging Prisma issues (
```
prisma debug
```
)

在以下场景中参考本技能：

搭建新的Prisma项目（
```
prisma init
```
）
生成Prisma Client（
```
prisma generate
```
）
执行数据库迁移（
```
prisma migrate
```
）
管理数据库状态（
```
prisma db push/pull
```
）
使用本地开发数据库（
```
prisma dev
```
）
调试Prisma问题（
```
prisma debug
```
）

Command Categories

命令分类

Category	Commands	Purpose
Setup	`init`	Bootstrap new Prisma project
Generation	`generate`	Generate Prisma Client
Validation	`validate` , `format`	Schema validation and formatting
Development	`dev`	Local Prisma Postgres for development
Database	`db pull` , `db push` , `db seed` , `db execute`	Direct database operations
Migrations	`migrate dev` , `migrate deploy` , `migrate reset` , `migrate status` , `migrate diff` , `migrate resolve`	Schema migrations
Utility	`studio` , `version` , `debug`	Development tools

分类	命令	用途
项目搭建	`init`	快速搭建新的Prisma项目
代码生成	`generate`	生成Prisma Client
验证	`validate` , `format`	架构验证与格式化
开发	`dev`	用于开发的本地Prisma Postgres
数据库操作	`db pull` , `db push` , `db seed` , `db execute`	直接数据库操作
迁移	`migrate dev` , `migrate deploy` , `migrate reset` , `migrate status` , `migrate diff` , `migrate resolve`	架构迁移
实用工具	`studio` , `version` , `debug`	开发工具

Quick Reference

快速参考

Project Setup

项目搭建

bash

undefined

bash

undefined

Initialize new project (creates prisma/ folder and prisma.config.ts)

初始化新项目（创建prisma/文件夹和prisma.config.ts）

prisma init

Initialize with specific database

使用指定数据库初始化

prisma init --datasource-provider postgresql prisma init --datasource-provider mysql prisma init --datasource-provider sqlite

Initialize with Prisma Postgres (cloud)

使用Prisma Postgres（云端）初始化

prisma init --db

Initialize with AI-generated schema

使用AI生成的架构初始化

prisma init --prompt "E-commerce app with users, products, orders"

undefined

prisma init --prompt "E-commerce app with users, products, orders"

undefined

Client Generation

客户端生成

bash

undefined

bash

undefined

Generate Prisma Client

生成Prisma Client

prisma generate

Watch mode for development

开发模式下的监听模式

prisma generate --watch

Generate without engine (for Accelerate/edge)

不生成引擎（适用于Accelerate/边缘环境）

prisma generate --no-engine

Generate specific generator only

仅生成指定的生成器

prisma generate --generator client

undefined

prisma generate --generator client

undefined

Bun Runtime

Bun 运行时

When using Bun, always add the

--bun

flag so Prisma runs with the Bun runtime (otherwise it falls back to Node.js because of the CLI shebang):

bash

bunx --bun prisma init
bunx --bun prisma generate

使用Bun时，务必添加

--bun

标志，确保Prisma使用Bun运行时（否则会因CLI shebang回退到Node.js）：

bash

bunx --bun prisma init
bunx --bun prisma generate

Local Development Database

本地开发数据库

bash

undefined

bash

undefined

Start local Prisma Postgres

启动本地Prisma Postgres

prisma dev

Start with specific name

使用指定名称启动

prisma dev --name myproject

Start in background (detached)

在后台启动（分离模式）

prisma dev --detach

List all local instances

列出所有本地实例

prisma dev ls

Stop instance

停止实例

prisma dev stop myproject

Remove instance data

删除实例数据

prisma dev rm myproject

undefined

prisma dev rm myproject

undefined

Database Operations

数据库操作

bash

undefined

bash

undefined

Pull schema from existing database

从现有数据库拉取架构

prisma db pull

Push schema to database (no migrations)

将架构推送到数据库（不执行迁移）

prisma db push

Seed database

为数据库填充初始数据

prisma db seed

Execute raw SQL

执行原始SQL

prisma db execute --file ./script.sql

undefined

prisma db execute --file ./script.sql

undefined

Migrations (Development)

迁移（开发环境）

bash

undefined

bash

undefined

Create and apply migration

创建并应用迁移

prisma migrate dev

Create migration with name

创建带名称的迁移

prisma migrate dev --name add_users_table

Create migration without applying

创建迁移但不应用

prisma migrate dev --create-only

Reset database and apply all migrations

重置数据库并应用所有迁移

prisma migrate reset

undefined

prisma migrate reset

undefined

Migrations (Production)

迁移（生产环境）

bash

undefined

bash

undefined

Apply pending migrations (CI/CD)

应用待处理的迁移（CI/CD场景）

prisma migrate deploy

Check migration status

检查迁移状态

prisma migrate status

Compare schemas and generate diff

对比架构并生成差异

prisma migrate diff --from-config-datasource --to-schema schema.prisma --script

undefined

prisma migrate diff --from-config-datasource --to-schema schema.prisma --script

undefined

Utility Commands

实用工具命令

bash

undefined

bash

undefined

Open Prisma Studio (database GUI)

打开Prisma Studio（数据库可视化界面）

prisma studio

Show version info

显示版本信息

prisma version prisma -v

Debug information

调试信息

prisma debug

Validate schema

验证架构

prisma validate

Format schema

格式化架构

prisma format

undefined

prisma format

undefined

Prisma 7 Changes

Prisma 7 变更

New Configuration File

新配置文件

Prisma 7 uses

prisma.config.ts

for CLI configuration:

typescript

import 'dotenv/config'
import { defineConfig, env } from 'prisma/config'

export default defineConfig({
  schema: 'prisma/schema.prisma',
  migrations: {
    path: 'prisma/migrations',
    seed: 'tsx prisma/seed.ts',
  },
  datasource: {
    url: env('DATABASE_URL'),
  },
})

Prisma 7使用

prisma.config.ts

作为CLI配置文件：

typescript

import 'dotenv/config'
import { defineConfig, env } from 'prisma/config'

export default defineConfig({
  schema: 'prisma/schema.prisma',
  migrations: {
    path: 'prisma/migrations',
    seed: 'tsx prisma/seed.ts',
  },
  datasource: {
    url: env('DATABASE_URL'),
  },
})

Removed Flags

移除的标志

```
--skip-generate
```
removed from
```
migrate dev
```
and
```
db push
```
```
--skip-seed
```
removed from
```
migrate dev
```
```
--schema
```
and
```
--url
```
removed from
```
db execute
```
Run
```
prisma generate
```
explicitly after migrations

从
```
migrate dev
```
和
```
db push
```
中移除
```
--skip-generate
```
从
```
migrate dev
```
中移除
```
--skip-seed
```
从
```
db execute
```
中移除
```
--schema
```
和
```
--url
```
迁移后需显式运行
```
prisma generate
```

Environment Variables

环境变量

Environment variables are no longer auto-loaded. Use

dotenv

typescript

// prisma.config.ts
import 'dotenv/config'

环境变量不再自动加载，请使用

dotenv

：

typescript

// prisma.config.ts
import 'dotenv/config'

Rule Files

规则文件

See individual rule files for detailed command documentation:

rules/init.md           - Project initialization
rules/generate.md       - Client generation
rules/dev.md            - Local development database
rules/db-pull.md        - Database introspection
rules/db-push.md        - Schema push
rules/db-seed.md        - Database seeding
rules/db-execute.md     - Raw SQL execution
rules/migrate-dev.md    - Development migrations
rules/migrate-deploy.md - Production migrations
rules/migrate-reset.md  - Database reset
rules/migrate-status.md - Migration status
rules/migrate-resolve.md - Migration resolution
rules/migrate-diff.md   - Schema diffing
rules/studio.md         - Database GUI
rules/validate.md       - Schema validation
rules/format.md         - Schema formatting
rules/debug.md          - Debug info

查看各个规则文件获取详细的命令文档：

rules/init.md           - 项目初始化
rules/generate.md       - 客户端生成
rules/dev.md            - 本地开发数据库
rules/db-pull.md        - 数据库反向工程
rules/db-push.md        - 架构推送
rules/db-seed.md        - 数据库数据填充
rules/db-execute.md     - 原始SQL执行
rules/migrate-dev.md    - 开发环境迁移
rules/migrate-deploy.md - 生产环境迁移
rules/migrate-reset.md  - 数据库重置
rules/migrate-status.md - 迁移状态
rules/migrate-resolve.md - 迁移问题解决
rules/migrate-diff.md   - 架构差异对比
rules/studio.md         - 数据库可视化界面
rules/validate.md       - 架构验证
rules/format.md         - 架构格式化
rules/debug.md          - 调试信息