studio - Prisma — ContextQMD

The prisma studio command starts a local web server with a web app to interactively browse and manage your data.

Usage

bash

prisma studio [options]

:::info[Supported databases]

Prisma Studio currently supports PostgreSQL, MySQL, and SQLite. Support for CockroachDB and MongoDB is not available yet but may be added in future releases.

:::

Prerequisites

Configure your database connection in prisma.config.ts:

prisma

generator client {
  provider = "prisma-client"
  output   = "../generated/prisma"
}

datasource db {
  provider = "sqlite"
}

typescript

import { defineConfig, env } from "prisma/config";

export default defineConfig({
  schema: "prisma/schema.prisma",
  migrations: {
    path: "prisma/migrations",
  },
  datasource: {
    url: env("DATABASE_URL"),
  },
});

Options

Option	Description	Default
`-h`, `--help`	Display help message
`-p`, `--port`	Port number to start Studio on	`5555`
`-b`, `--browser`	Browser to auto-open Studio in	System default
`--config`	Custom path to your Prisma config file
`--url`	Database connection string (overrides Prisma config)

Examples

Start Studio on the default port

npm

npx prisma studio

Start Studio on a custom port

npm

npx prisma studio --port 7777

Start Studio in a specific browser

npm

npx prisma studio --browser firefox

Or using the BROWSER environment variable:

bash

BROWSER=firefox prisma studio

Start Studio without opening a browser

npm

npx prisma studio --browser none

Start Studio with a custom config file

npm

npx prisma studio --config=./prisma.config.ts

Start Studio with a direct database connection string

npm

npx prisma studio --url="postgresql://user:password@localhost:5432/dbname"