studio
The prisma studio command starts a local web server with a web app to interactively browse and manage your data.
prisma studio [options]Configure your database connection in prisma.config.ts:
generator client {
provider = "prisma-client"
output = "../generated/prisma"
}
datasource db {
provider = "sqlite"
}import { defineConfig, env } from "prisma/config";
export default defineConfig({
schema: "prisma/schema.prisma",
migrations: {
path: "prisma/migrations",
},
datasource: {
url: env("DATABASE_URL"),
},
});| 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) |
bunx prisma studiopnpm prisma studioyarn prisma studionpx prisma studiobunx prisma studio --port 7777pnpm prisma studio --port 7777yarn prisma studio --port 7777npx prisma studio --port 7777bunx prisma studio --browser firefoxpnpm prisma studio --browser firefoxyarn prisma studio --browser firefoxnpx prisma studio --browser firefoxOr using the BROWSER environment variable:
BROWSER=firefox prisma studiobunx prisma studio --browser nonepnpm prisma studio --browser noneyarn prisma studio --browser nonenpx prisma studio --browser nonebunx prisma studio --config=./prisma.config.tspnpm prisma studio --config=./prisma.config.tsyarn prisma studio --config=./prisma.config.tsnpx prisma studio --config=./prisma.config.tsStart Studio with a direct database connection string
Section titled “Start Studio with a direct database connection string”bunx prisma studio --url="postgresql://user:password@localhost:5432/dbname"pnpm prisma studio --url="postgresql://user:password@localhost:5432/dbname"yarn prisma studio --url="postgresql://user:password@localhost:5432/dbname"npx prisma studio --url="postgresql://user:password@localhost:5432/dbname"