prisma-cli-studio

作者: prisma

prisma studio。使用此Prisma功能时的参考。

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

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

来自 prisma 的更多技能

prisma-cli-migrate-reset
prisma
prisma migrate reset
official
prisma-cli-validate
prisma
prisma 验证。使用此 Prisma 功能时的参考。
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
以全新视角(作为没有先前背景的团队成员)审查一个或多个ADR,识别叙述和结构问题,然后重写它们。适用于……
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
Prisma CLI命令、选项及工作流程的完整参考,涵盖设置、迁移和数据库操作。包含20多个按优先级组织的命令:设置(init)、生成(generate)、开发(dev)、数据库操作(db pull/push/seed/execute)和迁移(migrate dev/deploy/reset/status/diff/resolve)。包括Prisma 7.x变更:新的prisma.config.ts配置文件,已移除的标志(--skip-generate、--skip-seed、--schema、--url),以及显式...
official
prisma-client-api
prisma
完整的Prisma客户端API参考,涵盖模型查询、CRUD操作、过滤、关联和事务。包含17种模型查询方法,如findUnique、findMany、create、update、delete、upsert及批量操作及其返回变体。提供用于塑造结果的查询选项:select、include、omit、orderBy、take、skip、cursor和distinct。包括标量和逻辑过滤运算符(equals、in、contains、startsWith、lt、gt)以及关联过滤器(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