skill

Prisma CLI

Prisma ORM 7 CLI reference for existing Prisma 7 applications or explicitly selected Prisma 7 workflows. Covers prisma init, generate, migrate, db, dev, studio, and mcp. For setup, connection repair, or Prisma 8, use prisma-orm-setup; not the Prisma Platform CLI.

prisma321,162+ installsVetted

About

# Prisma ORM 7 CLI reference

These commands and examples apply to **Prisma ORM 7** only. For setup, connection repair, or a Prisma 8 application, load [prisma-orm-setup](../prisma-orm-setup/SKILL.md).

Use the project's version-matched CLI. Do not install a floating `prisma@latest` to run these commands.

## Boundary: Platform and Compute

Do not confuse the stable ORM command (`prisma`) with the public-beta Platform package (`@prisma/cli`, binary `prisma-cli`). Use `prisma-compute` for Compute apps and workspace auth, and `prisma-postgres-setup` for Platform projects and databases.

## When to Apply

Reference this skill when: - Setting up an explicitly selected Prisma 7 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`) - Generating shell completions (`prisma complete`)

## Rule Categories by Priority

| Priority | Category | Impact | Prefix | |----------|----------|--------|--------| | 1 | Setup | HIGH | `init` | | 2 | Generation | HIGH | `generate` | | 3 | Development | HIGH | `dev` | | 4 | Database | HIGH | `db-` | | 5 | Migrations | CRITICAL | `migrate-` | | 6 | Utility | MEDIUM | `complete`, `studio`, `validate`, `format`, `debug`, `mcp` |

## Command Categories

| Category | Commands | Purpose | |----------|----------|---------| | Setup | `init` | Initialize a 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 | `complete`, `studio`, `mcp`, `version`, `debug` | Shell, development, and AI tooling |

## Quick Reference

### Project Setup

```bash # Initialize new project (creates prisma/ folder and 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 init --db

# Initialize with an example model prisma init --with-model

```

### Client Generation

```bash # Generate Prisma Client prisma generate

# Watch mode for development prisma generate --watch

# Generate specific generator only prisma generate --generator client ```

### Bun Runtime

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 ```

### Local Development Database

```bash # Start local 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 ```

### Database Operations

```bash # 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 prisma db execute --file ./script.sql ```

### Migrations (Development)

```bash # 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 ```

### Migrations (Production)

```bash # Apply pending migrations (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 ```

### Utility Commands

```bash # Open Prisma Studio (database GUI) prisma studio

# Start Prisma's MCP server for AI tools prisma mcp

# Show version info prisma version prisma -v

# Debug information prisma debug

# Validate schema prisma validate

# Format schema prisma format

# Generate shell completion code prisma complete zsh ```

## AI Safety Checkpoint

Prisma blocks destructive commands when it detects an AI agent until the agent has obtained explicit user consent. This covers `migrate reset`, `db push --force-reset`, and `db push --accept-data-loss`.

- Explain the exact data-loss impact and ask for consent immediately before running the command. - Do not infer consent from earlier or unrelated messages. - If automation needs the consent variable, set `PRISMA_USER_CONSENT_FOR_DANGEROUS_AI_ACTION` to the user's exact consent message. Do not invent the text. - The Prisma MCP server deliberately has no `migrate-reset` tool.

Read `references/agent-safety.md` before

Install

Run this command

npx skills add prisma/skills

Works with

claude appclaude codeclaude apicursorcodexwindsurfclinezed

Manual steps

Install with `npx skills add prisma/skills`, or clone the repository and copy the `prisma-cli` folder into your Claude skills directory.

View source
License: MITBy prisma

Frequently asked questions

What is the Prisma CLI skill?

Prisma ORM 7 CLI reference for existing Prisma 7 applications or explicitly selected Prisma 7 workflows. Covers prisma init, generate, migrate, db, dev, studio, and mcp. For setup, connection repair, or Prisma 8, use prisma-orm-setup; not the Prisma Platform CLI.

How do I install Prisma CLI?

Run this in your terminal:

npx skills add prisma/skills
Which AI tools does Prisma CLI work with?

It works with claude_app, claude_code, claude_api, cursor, codex, windsurf, cline, zed.

Who made Prisma CLI?

prisma, released under the MIT license.

Is Prisma CLI free?

Yes, it is free to use under the MIT license.

Related assets

More curated picks in Development & Code.

All Prisma CLI alternatives →
skillclaude_appclaude_codeclaude_api
git clone https://github.com/anthropics/skills && cp -r skills/skills/claude-api ~/.claude/skills/
Claude Api
Reference for the Claude API / Anthropic SDK — model ids, pricing, params, streaming, tool use, MCP, agents, caching, token counting, model migration.…★ 4.8 · 2,500+
skillclaude_appclaude_codeclaude_api
npx skills add heygen-com/hyperframes
Hyperframes CLI
The HyperFrames CLI by job - scaffold, check, look at frames, edit the timeline, preview, render locally or in the cloud, publish, project history - p…1,214,920+
skillclaude_appclaude_codeclaude_api
npx skills add mattpocock/skills
Tdd
Test-driven development. Use when the user wants to build features or fix bugs test-first, mentions "red-green-refactor", or wants integration tests.1,046,962+
skillclaude_appclaude_codeclaude_api
npx skills add mattpocock/skills
Grilling
Grill the user relentlessly about a plan, decision, or idea. Use when the user wants to stress-test their thinking, or uses any 'grill' trigger phrase…869,010+
skillclaude_appclaude_codeclaude_api
npx skills add mattpocock/skills
Diagnosing Bugs
Diagnosis loop for hard bugs and performance regressions. Use when the user says "diagnose"/"debug this", or reports something broken/throwing/failing…746,030+
skillclaude_appclaude_codeclaude_api
npx skills add mattpocock/skills
Code Review
Review the changes since a fixed point (commit, branch, tag, or merge-base) along two axes: Standards (does the code follow this repo's documented cod…696,572+

Audit before you install

Run any source through our checks - AI visibility, security, performance, and stack detection.

More in Development & Code