--- title: "Prisma ORM 7 CLI: review, setup & limitations · Undominated.ai" canonical: https://undominated.ai/skills/prisma-cli/ description: "Pins Prisma's ORM 7 CLI skill and its warning not to use these commands for Prisma 8 or for the public-beta Platform CLI." --- # Prisma ORM 7 CLI: review, setup & limitations · Undominated.ai > Pins Prisma's ORM 7 CLI skill and its warning not to use these commands for Prisma 8 or for the public-beta Platform CLI. [← Explore all skills](/skills/) DATABASES / Prisma # Prisma ORM 7 CLI Pins Prisma's ORM 7 CLI skill and its warning not to use these commands for Prisma 8 or for the public-beta Platform CLI. [See setup guidance ↓](#setup)[Original source ↗](https://github.com/prisma/skills/tree/be16a8740d01363d13552b317042431ee8dfc581/prisma-cli) SOURCE REVIEW Reviewed 2026-10-14 Evidence 4 linked sources Publisher Prisma Licence [MIT ↗](https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/LICENSE) Revision be16a8740d01 [Read what was—and wasn’t—checked ↓](#review) “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.” [Prisma · upstream description ↗](https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/prisma-cli/SKILL.md) Our analysis follows below. 01 / THE REASONING ## Why this made the selection. - The catalogue has Prisma ORM setup and client-API skills and not this ORM 7 CLI reference. - The file separates the stable prisma binary from the public-beta @prisma/cli package, which is a different tool with a similar name. ### A good fit for - Looking up prisma migrate, generate, or db commands on a project the operator has already identified as Prisma ORM 7 ### Weigh up before choosing - This review did not execute the resource. - The skill says the commands apply only to Prisma ORM 7. This review did not compare them with a Prisma 7 or Prisma 8 binary. - The rest of the command reference after the Bun section was read as part of the file and was not run. - The source requires the project version-matched CLI and explicitly rejects installing a floating prisma@latest for these commands. 02 / THE REVIEW RECORD ## What we actually inspected. Source review has boundaries. A clear record is more useful than a “safe” badge. ### Material inspected - prisma-cli/SKILL.md - README.md - LICENSE ### Our findings - The skill says its commands and examples apply to Prisma ORM 7 only and points setup, connection repair, and Prisma 8 at prisma-orm-setup. - It says not to install a floating prisma@latest to run the commands, and to use the project's version-matched CLI. - It says not to confuse the stable prisma binary with the public-beta @prisma/cli package, whose binary name is prisma-cli. ### Not established by this review - The resource was not executed and its tools were not called. - No prisma command was run. - No database was migrated. - Not executed: it was not installed or run. The review applies to the material and revision named here. A newer upstream release can change its behavior. 03 / PUT IT TO WORK ## Add a skill to your workflow. [Upstream setup instructions ↗](https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/README.md) DOCUMENTED COMMAND npx skills add prisma/skills --skill prisma-cli Copy command ↗ Run in your terminal to choose your AI tools, project or global scope, and installation method. This short command follows the current upstream version; the review covers the revision shown above. - Use the README line npx skills add prisma/skills --skill prisma-cli. - That command does not pin revision be16a8740d01363d13552b317042431ee8dfc581. Inspect the installed SKILL.md and references/agent-safety.md against that revision. - Do not run migrate reset, db push --force-reset, or db push --accept-data-loss without the user's exact consent for that command. - For manual installation instead, download the complete bundle from https://undominated.ai/resources/skills/prisma-cli/bundle.zip and extract it into a new directory. It holds SKILL.md and 20 supporting files unchanged at revision be16a874, the upstream licence and an attribution file. - Place the extracted directory in your host's documented skills directory, named prisma-cli. Keep SKILL.md and the licence together. ### Before you start - Node.js and npm for the documented Skills installer - An existing Prisma 7 project and database only if you run the commands ### Compatibility Agent Skills-compatible hosts · Prisma ORM 7 ### CLI reference for an existing Prisma 7 project - Read the skill - Run prisma only in a project the operator has selected - Does not grant database credentials ### Cost model MIT; no Prisma command was run THE COMPLETE REVIEWED DEFINITION ## Read it before you reuse it. Original source bytes, with attribution. Review the host-specific setup notes above. Copy definition ↗ [Download complete resource + licence ↗](/resources/skills/prisma-cli/bundle.zip)[Raw Markdown ↗](/resources/skills/prisma-cli/definition.md) --- name: prisma-cli description: 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. license: MIT metadata: author: prisma version: "7.9.1" --- # 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 any destructive Prisma command. ## Current Prisma CLI Setup ### New Configuration File Use `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'), }, }) ``` ### Current Command Behavior - Run `prisma generate` explicitly after `migrate dev`, `db push`, or other schema syncs when you need fresh client output - Run `prisma db seed` explicitly after `migrate dev` or `migrate reset` when you need seed data - Use `prisma db execute --file ...` for raw SQL scripts ### Environment Variables Load environment variables explicitly in `prisma.config.ts`, commonly with `dotenv`: ```typescript // prisma.config.ts import 'dotenv/config' ``` ## Rule Files See individual rule files for detailed command documentation: ``` references/init.md - Project initialization references/generate.md - Client generation references/dev.md - Local development database references/db-pull.md - Database introspection references/db-push.md - Schema push references/db-seed.md - Database seeding references/db-execute.md - Raw SQL execution references/migrate-dev.md - Development migrations references/migrate-deploy.md - Production migrations references/migrate-reset.md - Database reset references/migrate-status.md - Migration status references/migrate-resolve.md - Migration resolution references/migrate-diff.md - Schema diffing references/studio.md - Database GUI references/mcp.md - Prisma MCP server references/complete.md - Shell completion generation references/agent-safety.md - AI consent checkpoint for destructive commands references/validate.md - Schema validation references/format.md - Schema formatting references/debug.md - Debug info ``` ## How to Use Use the command categories above for navigation, then open the specific command reference file you need. The download contains SKILL.md . Extract the whole bundle; the supporting files are required. Inspect the included MANIFEST.json for file hashes. By **Prisma**. [Exact upstream source ↗](https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/prisma-cli/SKILL.md) · [Licence](/resources/skills/prisma-cli/LICENSE.txt) · [Attribution](/resources/skills/prisma-cli/ATTRIBUTION.txt) SHA-256 e20d1a307dd836ede8c3ac5f8cdd4f91d77cc6f09ee9b0621bd2efde295ae229 Read the applicable licence MIT License Copyright (c) 2025 Prisma Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. 04 / FOLLOW THE EVIDENCE ## The source trail. Our notes are separate from the original resource. Check upstream before adopting a new version. - [prisma-cli SKILL.md ↗](https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/prisma-cli/SKILL.md) Checked 2026-10-14 https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/prisma-cli/SKILL.md Supports: ORM 7 boundary and Platform CLI warning - [Repository README ↗](https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/README.md) Checked 2026-10-14 https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/README.md Supports: per-skill install line and MIT statement - [Repository LICENSE ↗](https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/LICENSE) Checked 2026-10-14 https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/LICENSE Supports: MIT License - [Pinned source review C2-W29 ↗](https://raw.githubusercontent.com/prisma/skills/be16a8740d01363d13552b317042431ee8dfc581/prisma-cli/SKILL.md) Checked 2026-10-15 https://raw.githubusercontent.com/prisma/skills/be16a8740d01363d13552b317042431ee8dfc581/prisma-cli/SKILL.md Supports: limitations, review.notTested KEEP COMPARING ## Other approaches to consider. Related by category or shared topics. These are alternatives to inspect, not a measured quality order. [### Prisma Client API ↗ Covers Prisma Client model queries, relation filtering, interactive transactions, and batching semantics.](/skills/prisma-client-api/)[### Prisma ORM Setup ↗ Guides configuring Prisma ORM across PostgreSQL, MySQL, SQLite, SQL Server, CockroachDB, MongoDB, and Prisma Postgres.](/skills/prisma-orm-setup/)[### Supabase Development ↗ Covers the full Supabase surface beyond Postgres tuning: Auth flows, client and SSR integration, CLI and MCP use, declarative or imperative schema changes, and structured debugging.](/skills/supabase-supabase/) [AI Tools ↗](/tools/)[Skills ↗](/skills/)[Agents ↗](/agents/)[MCP Servers ↗](/mcp-servers/)[Workflows ↗](/workflows/) ## Continue your investigation - [Choose a toolkit](/tools/) - [Inspect execution hosts](/agents/) - [Check tool access](/mcp-servers/) - [Check project dependencies](/check-repo/)