skilld
All skills
prisma avatar

/prisma-cli

@b491588 official
by prismaprisma/skills66 stars
7

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.

Ask your Agent

Use this Skill: https://skilld.dev/gh/prisma/skills/prisma-cli

This session only. Nothing lands on disk.

referencesstudio.md

≈667 tokens on demand. Your agent reads this file only when SKILL.md points to it.

prisma studio

Opens a visual database browser for viewing and editing data.

Command

prisma studio [options]

What It Does

  • Starts a web-based database GUI
  • View all your models and records
  • Create, update, and delete records
  • Filter and sort data
  • Navigate relations

Options

Option Description Default
--port / -p Port to start Studio on 5555
--browser / -b Browser to open Studio in System default
--config Custom path to your Prisma config file -
--url Database connection string (overrides the one in your Prisma config) -

Examples

Open Studio

prisma studio

Opens at http://localhost:5555

Custom port

prisma studio --port 3000

Specific browser

prisma studio --browser firefox

Don't open browser

BROWSER=none prisma studio

Useful for remote servers.

Features

View Records

  • See all records in table format
  • Pagination for large datasets
  • Column sorting

Filter Data

  • Filter by any field
  • Multiple conditions
  • Relation filtering

Edit Records

  • Click to edit inline
  • Add new records
  • Delete records (with confirmation)

Navigate Relations

  • Click relations to view related records
  • See counts of related items
  • Follow relation links

Recent Studio Capabilities

Recent Prisma Studio releases added richer editor workflows:

  • multi-cell selection and editing
  • full-table search and more intuitive filtering
  • command palette shortcuts
  • dark mode
  • copy selections as Markdown
  • back-relation navigation
  • SQL workflows including raw SQL queries

Some recent builds also expose AI-assisted SQL authoring. Treat these as interactive Studio features rather than a replacement for checked-in migrations or application queries.

Use Cases

  • Development: Quick data inspection
  • Debugging: Check data state
  • Testing: Verify seed data
  • Demo: Show data to stakeholders

Limitations

  • Development tool only
  • Not for production use
  • Limited to configured database
  • Prisma Studio in Prisma 7 currently targets PostgreSQL, MySQL, and SQLite first
  • For reproducible application logic, prefer Prisma Client and checked-in SQL scripts

Common Workflow

  1. Run migrations:

    prisma migrate dev

  2. Seed data:

    prisma db seed

  3. Open Studio to verify:

    prisma studio

  4. Make manual edits if needed

Security Note

Studio provides direct database access. Only run on:

  • Local development machines
  • Secure internal networks
  • Never expose publicly

Source: SKILL.md on GitHub

Third-party checks

No alerts1d5 checks · Risk SAFE
  • Gen Agent Trust Hub1d

    This skill provides a comprehensive reference for Prisma ORM CLI commands, covering project initialization, migrations, and database management. It includes specific safety guidelines to prevent AI agents from executing destructive commands without explicit user consent. No security issues were detected.

  • Socket1d

    No alerts

  • Snyk1d

    Risk: LOW · No issues

  • Runlayer7mo

    4/18 files flagged

  • ZeroLeaks5mo

    Score: 93/100 · 2 sections analyzed

Provenance

Signed by skilld at b491588. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub yesterday.

Activeupdated 2 days ago

Capability

metadata
{
  "author": "prisma",
  "version": "7.9.1"
}

Topics

README badge

README badge for prisma/skills/prisma-cli

What it does

Provides reference documentation and guidance for Prisma ORM CLI commands including init, generate, migrate, db operations, studio, and mcp. Use this skill for Prisma project setup, migrations, schema management, and local development workflows; do not use it for Prisma Compute app deployment.

Generated from the current SKILL.md.

Frequently asked

Does this skill cover Prisma Compute deployment?
No. This skill covers Prisma ORM CLI commands only (init, generate, migrate, db, studio, etc.). Use the prisma-compute skill for app deploy, compute:deploy, and Compute-related commands.
What database systems does this skill support?
Prisma ORM with PostgreSQL, MySQL, SQLite, and Prisma Postgres (cloud). The skill documents provider-specific initialization flags.
Does this skill work with Bun?
Yes. The skill documents that you must use the `--bun` flag when running Prisma commands via Bun (e.g. `bunx --bun prisma generate`) so Prisma runs with the Bun runtime instead of falling back to Node.js.
Does this skill cover development workflows only, or production too?
Both. It covers development commands (prisma dev, migrate dev) and production workflows (prisma migrate deploy for CI/CD, prisma db push for schema sync).
What version of Prisma does this skill target?
Prisma 7.6.0 and current releases. It documents the current prisma.config.ts configuration format and CLI behavior.

Generated from the current SKILL.md. These answers refresh after source changes.