Команды Prisma CLI
Описывает каждую команду CLI Prisma ORM 7, от init и generate до migrate, db push и studio, и как получить согласие пользователя, прежде чем Prisma даст агенту сбросить базу. Для случаев, когда в проекте на Prisma 7 нужны миграции или команды схемы.
prisma-cli- Автор
- Prisma
- Источник
- prisma/skills/prisma-cli @ a6f1929
- Лицензия
- MIT · Copyright (c) 2025 Prisma
Об этом скилле
Что делает
Справочник по CLI Prisma ORM 7, по файлу на команду в references/: init, generate, validate, format, dev, четыре команды db, шесть команд migrate (dev, deploy, reset, status, diff, resolve), studio, mcp, complete и debug. На большинстве страниц — флаги, примеры и случаи, когда команда к месту. migrate-dev.md объясняет теневую базу и поиск дрейфа схемы, migrate-diff.md — базовую миграцию и проверку дрейфа в CI через --exit-code, dev.md — локальный Prisma Postgres, который поднимает prisma dev.
Скилл описывает и поведение Prisma 7, на котором спотыкаются по старой привычке: конфигурация живёт в prisma.config.ts, env подгружается через dotenv; migrate dev больше не запускает generate и сид; под Bun команда — bunx --bun prisma. Агент берёт версию CLI из проекта, а не плавающую prisma@latest.
agent-safety.md описывает проверку, встроенную в саму Prisma: увидев ИИ-агента, она блокирует migrate reset, db push --force-reset и db push --accept-data-loss, пока пользователь не согласится. Агент объясняет, что пропадёт, спрашивает прямо перед командой и передаёт дословный ответ пользователя в PRISMA_USER_CONSENT_FOR_DANGEROUS_AI_ACTION; --force убирает обычный вопрос, но согласием не считается. prisma mcp запускает MCP-сервер Prisma, где инструмента сброса нет намеренно.
Когда включать и когда не надо
В проекте на Prisma 7: миграции, синхронизация схемы, интроспекция, сиды, локальная база для разработки.
Первая настройка, сломанное подключение и Prisma 8 — это к скиллу Настройка Prisma ORM. Отдельный CLI платформы (@prisma/cli, бинарник prisma-cli) относится к скиллам prisma-compute и prisma-postgres-setup, которых в нашем каталоге нет.
Как поставить и вызвать
Команда установки ниже скачивает всю папку. Агент сам подхватывает скилл, когда дело доходит до команд Prisma. Вызвать вручную:
- Claude Code:
/prisma-cliили попросить скилл по имени. - Codex:
$prisma-cli. - Cursor: наберите
/в чате Agent и выберитеprisma-cli.
Пример: /prisma-cli Создай миграцию для новой модели Invoice, примени её локально и покажи, что выполнит migrate deploy на проде.
Чем отличается от похожих
Безопасные миграции БД планируют изменения на боевой базе без простоя: expand/contract, заполнение старых строк пачками, таймауты блокировок, откат. Скилл подходит к любому инструменту миграций и велит читать SQL из prisma migrate diff. Этот скилл знает команды Prisma, но о блокировках и размере таблиц молчит, так что для рискованной правки большой таблицы берите оба. Переход на Prisma ORM 7 перечисляет флаги CLI и автоматические шаги, которые убрали в v7, — для проекта, который ещё на v6.
Установка
Выполните одну команду — она сохранит SKILL.md и файлы, которые он использует, в папку скиллов агента. Claude Code и Codex подхватывают новый скилл без перезапуска; если скилл не появился, перезапустите агента.
Скилл написан на английском — агент поймёт его и ответит вам по-русски.
curl -fsSL --create-dirs -o ~/.claude/skills/prisma-cli/SKILL.md https://anymodel.org/en/skills/prisma/prisma-cli/SKILL.md -o ~/.claude/skills/prisma-cli/LICENSE https://anymodel.org/en/skills/prisma/prisma-cli/LICENSE -o ~/.claude/skills/prisma-cli/references/agent-safety.md https://anymodel.org/en/skills/prisma/prisma-cli/references/agent-safety.md -o ~/.claude/skills/prisma-cli/references/complete.md https://anymodel.org/en/skills/prisma/prisma-cli/references/complete.md -o ~/.claude/skills/prisma-cli/references/db-execute.md https://anymodel.org/en/skills/prisma/prisma-cli/references/db-execute.md -o ~/.claude/skills/prisma-cli/references/db-pull.md https://anymodel.org/en/skills/prisma/prisma-cli/references/db-pull.md -o ~/.claude/skills/prisma-cli/references/db-push.md https://anymodel.org/en/skills/prisma/prisma-cli/references/db-push.md -o ~/.claude/skills/prisma-cli/references/db-seed.md https://anymodel.org/en/skills/prisma/prisma-cli/references/db-seed.md -o ~/.claude/skills/prisma-cli/references/debug.md https://anymodel.org/en/skills/prisma/prisma-cli/references/debug.md -o ~/.claude/skills/prisma-cli/references/dev.md https://anymodel.org/en/skills/prisma/prisma-cli/references/dev.md -o ~/.claude/skills/prisma-cli/references/format.md https://anymodel.org/en/skills/prisma/prisma-cli/references/format.md -o ~/.claude/skills/prisma-cli/references/generate.md https://anymodel.org/en/skills/prisma/prisma-cli/references/generate.md -o ~/.claude/skills/prisma-cli/references/init.md https://anymodel.org/en/skills/prisma/prisma-cli/references/init.md -o ~/.claude/skills/prisma-cli/references/mcp.md https://anymodel.org/en/skills/prisma/prisma-cli/references/mcp.md -o ~/.claude/skills/prisma-cli/references/migrate-deploy.md https://anymodel.org/en/skills/prisma/prisma-cli/references/migrate-deploy.md -o ~/.claude/skills/prisma-cli/references/migrate-dev.md https://anymodel.org/en/skills/prisma/prisma-cli/references/migrate-dev.md -o ~/.claude/skills/prisma-cli/references/migrate-diff.md https://anymodel.org/en/skills/prisma/prisma-cli/references/migrate-diff.md -o ~/.claude/skills/prisma-cli/references/migrate-reset.md https://anymodel.org/en/skills/prisma/prisma-cli/references/migrate-reset.md -o ~/.claude/skills/prisma-cli/references/migrate-resolve.md https://anymodel.org/en/skills/prisma/prisma-cli/references/migrate-resolve.md -o ~/.claude/skills/prisma-cli/references/migrate-status.md https://anymodel.org/en/skills/prisma/prisma-cli/references/migrate-status.md -o ~/.claude/skills/prisma-cli/references/studio.md https://anymodel.org/en/skills/prisma/prisma-cli/references/studio.md -o ~/.claude/skills/prisma-cli/references/validate.md https://anymodel.org/en/skills/prisma/prisma-cli/references/validate.md
curl -fsSL --create-dirs -o ~/.agents/skills/prisma-cli/SKILL.md https://anymodel.org/en/skills/prisma/prisma-cli/SKILL.md -o ~/.agents/skills/prisma-cli/LICENSE https://anymodel.org/en/skills/prisma/prisma-cli/LICENSE -o ~/.agents/skills/prisma-cli/references/agent-safety.md https://anymodel.org/en/skills/prisma/prisma-cli/references/agent-safety.md -o ~/.agents/skills/prisma-cli/references/complete.md https://anymodel.org/en/skills/prisma/prisma-cli/references/complete.md -o ~/.agents/skills/prisma-cli/references/db-execute.md https://anymodel.org/en/skills/prisma/prisma-cli/references/db-execute.md -o ~/.agents/skills/prisma-cli/references/db-pull.md https://anymodel.org/en/skills/prisma/prisma-cli/references/db-pull.md -o ~/.agents/skills/prisma-cli/references/db-push.md https://anymodel.org/en/skills/prisma/prisma-cli/references/db-push.md -o ~/.agents/skills/prisma-cli/references/db-seed.md https://anymodel.org/en/skills/prisma/prisma-cli/references/db-seed.md -o ~/.agents/skills/prisma-cli/references/debug.md https://anymodel.org/en/skills/prisma/prisma-cli/references/debug.md -o ~/.agents/skills/prisma-cli/references/dev.md https://anymodel.org/en/skills/prisma/prisma-cli/references/dev.md -o ~/.agents/skills/prisma-cli/references/format.md https://anymodel.org/en/skills/prisma/prisma-cli/references/format.md -o ~/.agents/skills/prisma-cli/references/generate.md https://anymodel.org/en/skills/prisma/prisma-cli/references/generate.md -o ~/.agents/skills/prisma-cli/references/init.md https://anymodel.org/en/skills/prisma/prisma-cli/references/init.md -o ~/.agents/skills/prisma-cli/references/mcp.md https://anymodel.org/en/skills/prisma/prisma-cli/references/mcp.md -o ~/.agents/skills/prisma-cli/references/migrate-deploy.md https://anymodel.org/en/skills/prisma/prisma-cli/references/migrate-deploy.md -o ~/.agents/skills/prisma-cli/references/migrate-dev.md https://anymodel.org/en/skills/prisma/prisma-cli/references/migrate-dev.md -o ~/.agents/skills/prisma-cli/references/migrate-diff.md https://anymodel.org/en/skills/prisma/prisma-cli/references/migrate-diff.md -o ~/.agents/skills/prisma-cli/references/migrate-reset.md https://anymodel.org/en/skills/prisma/prisma-cli/references/migrate-reset.md -o ~/.agents/skills/prisma-cli/references/migrate-resolve.md https://anymodel.org/en/skills/prisma/prisma-cli/references/migrate-resolve.md -o ~/.agents/skills/prisma-cli/references/migrate-status.md https://anymodel.org/en/skills/prisma/prisma-cli/references/migrate-status.md -o ~/.agents/skills/prisma-cli/references/studio.md https://anymodel.org/en/skills/prisma/prisma-cli/references/studio.md -o ~/.agents/skills/prisma-cli/references/validate.md https://anymodel.org/en/skills/prisma/prisma-cli/references/validate.md
foreach ($f in 'SKILL.md','LICENSE','references/agent-safety.md','references/complete.md','references/db-execute.md','references/db-pull.md','references/db-push.md','references/db-seed.md','references/debug.md','references/dev.md','references/format.md','references/generate.md','references/init.md','references/mcp.md','references/migrate-deploy.md','references/migrate-dev.md','references/migrate-diff.md','references/migrate-reset.md','references/migrate-resolve.md','references/migrate-status.md','references/studio.md','references/validate.md') { $p = Join-Path "$HOME\.claude\skills\prisma-cli" $f; New-Item -ItemType Directory -Force (Split-Path $p) | Out-Null; Invoke-WebRequest "https://anymodel.org/en/skills/prisma/prisma-cli/$f" -UseBasicParsing -OutFile $p }foreach ($f in 'SKILL.md','LICENSE','references/agent-safety.md','references/complete.md','references/db-execute.md','references/db-pull.md','references/db-push.md','references/db-seed.md','references/debug.md','references/dev.md','references/format.md','references/generate.md','references/init.md','references/mcp.md','references/migrate-deploy.md','references/migrate-dev.md','references/migrate-diff.md','references/migrate-reset.md','references/migrate-resolve.md','references/migrate-status.md','references/studio.md','references/validate.md') { $p = Join-Path "$HOME\.agents\skills\prisma-cli" $f; New-Item -ItemType Directory -Force (Split-Path $p) | Out-Null; Invoke-WebRequest "https://anymodel.org/en/skills/prisma/prisma-cli/$f" -UseBasicParsing -OutFile $p }Другой агент: сохраните файл в его папку скиллов или дайте ему ссылку на файл: https://anymodel.org/en/skills/prisma/prisma-cli/SKILL.md
SKILL.md
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.
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
# 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
# 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):
bunx --bun prisma init
bunx --bun prisma generate
Local Development Database
# 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
# 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)
# 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)
# 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
# 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_ACTIONto the user's exact consent message. Do not invent the text. - The Prisma MCP server deliberately has no
migrate-resettool.
Read references/agent-safety.md before any destructive Prisma command.
Current Prisma CLI Setup
New Configuration File
Use prisma.config.ts for CLI configuration:
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 generateexplicitly aftermigrate dev,db push, or other schema syncs when you need fresh client output - Run
prisma db seedexplicitly aftermigrate devormigrate resetwhen 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:
// 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.
Подключить через AnyModel API
Скилл работает на той модели, которую использует агент. Подключите Claude Code, Codex или Cursor к AnyModel и запускайте его на Claude, GPT, Gemini и других моделях по одному ключу — оплата за токены, без подписки.
AnyModel