prisma-cli-studio

作者： prisma

使用 Prisma Studio 時參考此功能。

npx skills add https://github.com/prisma/cursor-plugin --skill prisma-cli-studio
下載 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

來自 prisma 的更多技能

prisma-cli-migrate-reset
prisma
prisma migrate reset
official
prisma-cli-validate
prisma
prisma validate。使用此 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 Client 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