# Getting Started (/docs/studio/getting-started)

> 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.

Learn how to set up and use Prisma Studio to manage your database

Location: Studio > Getting Started

## Installation [#installation]

Prisma Studio comes bundled with the Prisma CLI. Make sure you have Node.js installed, then install the Prisma CLI:

  

#### bun

```bash
bun add --global prisma@prev
```

#### pnpm

```bash
pnpm add -g prisma@prev
```

#### yarn

```bash
yarn global add prisma@prev
```

#### npm

```bash
npm install -g prisma@prev
```

## Launching Studio [#launching-studio]

### With a Prisma Project [#with-a-prisma-project]

If you have an existing Prisma project, navigate to your project directory and run:

  

#### bun

```bash
bunx prisma studio
```

#### pnpm

```bash
pnpm prisma studio
```

#### yarn

```bash
yarn prisma studio
```

#### npm

```bash
npx prisma studio
```

This will start the Studio server and open it in your default browser at `http://localhost:5555`.

### Without a Prisma Project [#without-a-prisma-project]

You can also use Studio with any database by providing a connection string:

  

#### bun

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

#### pnpm

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

#### yarn

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

#### npm

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

This is also how you launch Studio for a [Prisma ORM](https://www.prisma.io/docs/orm) project, which has no `schema.prisma` to read. See [Studio with Prisma ORM](https://www.prisma.io/docs/studio/prisma-next).

## Connecting to your database [#connecting-to-your-database]

1. **Using environment variables**:
   Create a `.env` file in your project root with your database URL:

   ```
   DATABASE_URL="postgresql://user:password@localhost:5432/yourdb"
   ```

   Then run: `npx prisma studio`

2. **Using command line**:
   ```bash
   npx prisma studio --url="your-database-connection-string"
   ```

## Basic Usage [#basic-usage]

### Browsing Data [#browsing-data]

* The left sidebar lists all your database tables
* Click on a table to view its data
* Use the search bar to find tables or columns

### Editing Data [#editing-data]

* **Edit cells**: Double-click any cell to edit its value
* **Add records**: Click the "+" button to add a new record
* **Delete records**: Select records using checkboxes and click the trash icon

### Filtering and Sorting [#filtering-and-sorting]

* Click the filter icon to add filters
* Click on column headers to sort the table
* Use the search box to filter records by any field

## Common Tasks [#common-tasks]

### Viewing Table Relationships [#viewing-table-relationships]

* Related tables are shown as expandable rows
* Click the "+" icon to view related records

### Exporting Data [#exporting-data]

* Use the export button to download data as CSV or JSON
* Select specific columns to include in the export

## Next Steps [#next-steps]

* Use Studio with a [Prisma ORM project](https://www.prisma.io/docs/studio/prisma-next) to read your applied migration history in the Migrations view
* Learn how to [embed Studio in your application](https://www.prisma.io/docs/studio/integrations/embedding)
* Discover [VS Code integration](https://www.prisma.io/docs/studio/integrations/vscode-integration) features

## Related pages

- [`Studio with Prisma ORM`](https://www.prisma.io/docs/studio/prisma-next): Apply migrations to Prisma Postgres with Prisma ORM, then inspect the migration history, schema changes, executed SQL, and data in Prisma Studio.