prisma-cli-studio

by prisma

prisma studio. Reference when using this Prisma feature.

npx skills add https://github.com/prisma/cursor-plugin --skill prisma-cli-studio
Download ZIPGitHub
8

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

OptionDescriptionDefault
--port / -pPort to start Studio on5555
--browser / -bBrowser to open Studio inSystem default
--configCustom path to your Prisma config file-
--urlDatabase 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

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
  • No advanced queries (use Prisma Client for that)

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

More skills from prisma

prisma-cli-migrate-reset
prisma
prisma migrate reset
official
prisma-cli-validate
prisma
prisma validate. Reference when using this Prisma feature.
official
prisma-next-extension-upgrade
prisma
Upgrade Prisma Next in your extension. Bumps every `@prisma-next/*` dependency to the requested target (or npm `latest`), runs the per-transition upgrade…
official
adr-review
prisma
Review one or more ADRs with fresh eyes (as a team member without prior context), identify narrative and structural issues, then rewrite them. Use when the…
official
prisma-next-upgrade
prisma
Upgrade Prisma Next in your app. Bumps every `@prisma-next/*` dependency from the version pinned in the lockfile to the requested target (or npm `latest`),…
official
prisma-cli
prisma
Complete reference for Prisma CLI commands, options, and workflows across setup, migrations, and database operations. Covers 20+ commands organized by priority: setup ( init ), generation ( generate ), development ( dev ), database operations ( db pull/push/seed/execute ), and migrations ( migrate dev/deploy/reset/status/diff/resolve ) Includes Prisma 7.x changes: new prisma.config.ts configuration file, removed flags ( --skip-generate , --skip-seed , --schema , --url ), and explicit...
official
prisma-client-api
prisma
Complete Prisma Client API reference for model queries, CRUD operations, filtering, relations, and transactions. Covers 17 model query methods including findUnique , findMany , create , update , delete , upsert , and bulk operations with return variants Provides query options for shaping results: select , include , omit , orderBy , take , skip , cursor , and distinct Includes scalar and logical filter operators ( equals , in , contains , startsWith , lt , gt ) plus relation filters ( some ,...
official
prisma-compute
prisma
Prisma Compute deployment and hosting guide. Use whenever the user mentions Prisma Compute, `prisma.compute.ts`, `defineComputeConfig`, deploying or hosting a Prisma app, `@prisma/cli app deploy`, `compute:deploy`, `create-prisma --deploy`, `PRISMA_SERVICE_TOKEN`, `auth workspace`, Compute apps/deployments/build logs/domains, `@prisma/cli agent install`, localhost vs `0.0.0.0`, deploy port binding, or framework deploy readiness for Hono, Elysia, Next.js, TanStack Start, Astro, Nuxt, Svelte,...
developmentdevopsofficial