# studio (Prisma CLI v7) (/docs/cli/v7/studio)

> For the complete Prisma documentation index, see [llms.txt](https://www.prisma.io/docs/llms.txt). A markdown version of any docs page is available by appending `.md` to its URL.

Browse and manage your database data with Prisma Studio web interface

Location: CLI > v7 > studio

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

## Usage [#usage]

```bash
prisma studio [options]
```

> [!NOTE]
> 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 [#prerequisites]

Configure your database connection in `prisma.config.ts`:

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

datasource db {
  provider = "sqlite"
}
```

```typescript file=prisma.config.ts
import { defineConfig, env } from "prisma/config";

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

## Options [#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 [#examples]

### Start Studio on the default port [#start-studio-on-the-default-port]

  

#### bun

```bash
bunx prisma studio
```

#### pnpm

```bash
pnpm prisma studio
```

#### yarn

```bash
yarn prisma studio
```

#### npm

```bash
npx prisma studio
```

### Start Studio on a custom port [#start-studio-on-a-custom-port]

  

#### bun

```bash
bunx prisma studio --port 7777
```

#### pnpm

```bash
pnpm prisma studio --port 7777
```

#### yarn

```bash
yarn prisma studio --port 7777
```

#### npm

```bash
npx prisma studio --port 7777
```

### Start Studio in a specific browser [#start-studio-in-a-specific-browser]

  

#### bun

```bash
bunx prisma studio --browser firefox
```

#### pnpm

```bash
pnpm prisma studio --browser firefox
```

#### yarn

```bash
yarn prisma studio --browser firefox
```

#### npm

```bash
npx prisma studio --browser firefox
```

Or using the `BROWSER` environment variable:

```bash
BROWSER=firefox prisma studio
```

### Start Studio without opening a browser [#start-studio-without-opening-a-browser]

  

#### bun

```bash
bunx prisma studio --browser none
```

#### pnpm

```bash
pnpm prisma studio --browser none
```

#### yarn

```bash
yarn prisma studio --browser none
```

#### npm

```bash
npx prisma studio --browser none
```

### Start Studio with a custom config file [#start-studio-with-a-custom-config-file]

  

#### bun

```bash
bunx prisma studio --config=./prisma.config.ts
```

#### pnpm

```bash
pnpm prisma studio --config=./prisma.config.ts
```

#### yarn

```bash
yarn prisma studio --config=./prisma.config.ts
```

#### npm

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

### Start Studio with a direct database connection string [#start-studio-with-a-direct-database-connection-string]

  

#### bun

```bash
bunx prisma studio --url="postgresql://user:password@localhost:5432/dbname"
```

#### pnpm

```bash
pnpm prisma studio --url="postgresql://user:password@localhost:5432/dbname"
```

#### yarn

```bash
yarn prisma studio --url="postgresql://user:password@localhost:5432/dbname"
```

#### npm

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

## Related pages

- [`db`](https://www.prisma.io/docs/cli/v7/db): Manage your database schema and lifecycle during development
- [`debug`](https://www.prisma.io/docs/cli/v7/debug): Display Prisma debug information including schema paths, engine binaries, environment variables, and cache directories for troubleshooting
- [`dev`](https://www.prisma.io/docs/cli/v7/dev): Start a local Prisma Postgres server for development
- [`format`](https://www.prisma.io/docs/cli/v7/format): Format and validate your Prisma schema file with consistent structure
- [`generate`](https://www.prisma.io/docs/cli/v7/generate): Generate artifacts like Prisma Client based on your Prisma schema