# Viewing data (/docs/guides/postgres/viewing-data)

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

Viewing and editing data in Prisma Postgres via Prisma Studio or other database GUIs

Location: Guides > Postgres > Viewing data

You can view and edit your data in Prisma Postgres using either [Prisma Studio](https://www.prisma.io/docs/studio) or 3rd party database editors.

## Viewing and editing data in Prisma Studio [#viewing-and-editing-data-in-prisma-studio]

With Prisma Postgres, a hosted version of Prisma Studio is available in your project. In your project environment in the [Platform Console](https://console.prisma.io/?utm_source=docs\&utm_medium=content\&utm_content=guides), select the **Studio** tab in the left-hand navigation to view and edit your data:

![View of Prisma Studio open in the console.](https://www.prisma.io/img/ppg-studio.png)

You can also run Prisma Studio locally. Studio ships with the Prisma ORM 7 CLI and works with Prisma ORM 7 and Prisma ORM 8 databases alike. Point it at the **direct** connection string of your database:

  

#### bun

```bash
bunx prisma@prev studio --url="postgres://USER:PASSWORD@db.prisma.io:5432/postgres?sslmode=require"
```

#### pnpm

```bash
pnpm dlx prisma@prev studio --url="postgres://USER:PASSWORD@db.prisma.io:5432/postgres?sslmode=require"
```

#### yarn

```bash
yarn dlx prisma@prev studio --url="postgres://USER:PASSWORD@db.prisma.io:5432/postgres?sslmode=require"
```

#### npm

```bash
npx prisma@prev studio --url="postgres://USER:PASSWORD@db.prisma.io:5432/postgres?sslmode=require"
```

This should start a live server in `http://localhost:5555` where you can visit and interact with your database.

If your database is managed with [Prisma ORM](https://www.prisma.io/docs/orm), Studio also shows a **Migrations** view alongside your tables, with a visual diff of what each applied migration changed. See [Studio with Prisma ORM](https://www.prisma.io/docs/studio/prisma-next).

## Connecting to Prisma Postgres instance with 3rd party database editors [#connecting-to-prisma-postgres-instance-with-3rd-party-database-editors]

You can connect to your Prisma Postgres instance using third party database editors like pgAdmin, TablePlus, DataGrip, DBeaver or Postico with the direct connection string of your database. See the examples below.

### 1. Get your direct connection string [#1-get-your-direct-connection-string]

In the [Prisma Console](https://console.prisma.io/?utm_source=docs\&utm_medium=content\&utm_content=guides), select your database, click **Connect to your database** and generate a connection string. Copy the **direct** value, which looks like this:

```bash
postgres://USER:PASSWORD@db.prisma.io:5432/postgres?sslmode=require
```

Database editors typically ask for the individual parts of that connection string:

| Field        | Value                                        |
| ------------ | -------------------------------------------- |
| **Host**     | `db.prisma.io`                               |
| **Port**     | `5432`                                       |
| **Database** | `postgres`                                   |
| **User**     | The `USER` part of the connection string     |
| **Password** | The `PASSWORD` part of the connection string |
| **SSL mode** | `require`                                    |

Use the direct connection string for database editors, migrations and other administrative tooling. Application traffic should use the pooled connection string instead. Learn more in [Connecting to your database](https://www.prisma.io/docs/postgres/database/connecting-to-your-database).

> [!WARNING]
> Accelerate retirement
> 
> Hosted Prisma Postgres `prisma+postgres://accelerate.prisma-data.net` connections will be retired on December 1, 2026. Connecting a database editor through the `@prisma/ppg-tunnel` package with such a URL is a legacy path: generate a direct connection string in the Prisma Console and connect your editor with it instead. If your application still uses a hosted Accelerate connection, [switch to pooled TCP or the Prisma Postgres serverless driver](https://www.prisma.io/docs/postgres/database/switch-from-accelerate).

### 2a. Connect to Prisma Postgres using TablePlus [#2a-connect-to-prisma-postgres-using-tableplus]

To add the connection in TablePlus:

1. Open TablePlus and click on the **+** icon to add a new connection.
2. Select **PostgreSQL** as the database type.
3. Enter the following details:
   * **Name**: Any name you want to give to your connection.
   * **Host**: `db.prisma.io`.
   * **Port**: `5432`.
   * **User**: The `USER` part of your direct connection string.
   * **Password**: The `PASSWORD` part of your direct connection string.
   * **Database**: `postgres`.
   * **SSL mode**: `require`.
4. Click on **Connect** to connect to your Prisma Postgres instance.

![View of TablePlus connected to Prisma Postgres](https://www.prisma.io/img/ppg-tableplus.png)

### 2b. Connect to Prisma Postgres using DataGrip [#2b-connect-to-prisma-postgres-using-datagrip]

To add the connection in DataGrip:

1. Open DataGrip and click on the **+** icon and select "Datasource".
2. Select **PostgreSQL** as the database type.
3. Enter the following details:
   * **Name**: Any name you want to give to your connection.
   * **Host**: `db.prisma.io`.
   * **Port**: `5432`.
   * **Database**: `postgres`.
   * **User**: The `USER` part of your direct connection string.
   * **Password**: The `PASSWORD` part of your direct connection string.
   * **URL**: Make sure the URL ends with the query parameter `?sslmode=require`.
4. Click on **Test Connection** to ensure that DataGrip can connect to your Prisma Postgres instance. Once successful, click **OK** to save the connection.

![View of DataGrip connected to Prisma Postgres](https://www.prisma.io/img/ppg-datagrip.png)

### 2c. Connect to Prisma Postgres using DBeaver [#2c-connect-to-prisma-postgres-using-dbeaver]

To add the connection in DBeaver:

1. Open DBeaver and click on the **New Database Connection** button or **File** > **New** to add a new connection.
2. Select **PostgreSQL** as the database type.
3. Select **URL** option in Connect by section.
4. Enter the URL in this format:
   * **URL**: Your URL should be in this format: `jdbc:postgresql://db.prisma.io:5432/postgres?sslmode=require`. Enter the `USER` and `PASSWORD` parts of your direct connection string as **Username** and **Password**.
5. Click on **Test Connection** to ensure that DBeaver can connect to your Prisma Postgres instance. If successful, click **Finish**.

![View of DBeaver connected to Prisma Postgres](https://www.prisma.io/img/ppg-dbeaver.png)

### 2d. Connect to Prisma Postgres using Postico [#2d-connect-to-prisma-postgres-using-postico]

To add the connection in Postico:

1. Open Postico and click on the **New Server** button to add a new connection.
2. Enter the following details:
   * **Name**: Any name you want to give to your connection.
   * **Host**: `db.prisma.io`.
   * **Port**: `5432`.
   * **User**: The `USER` part of your direct connection string.
   * **Password**: The `PASSWORD` part of your direct connection string.
   * **Database**: `postgres`.
3. Check "Pre-Connect Shell Script" and enter:
   ```sh
   cat <<eof
   {
   "sslmode":"require",
   }
   eof
   ```
4. Click on **Test Connection** to ensure that Postico can connect to your Prisma Postgres instance. If successful, click **Connect**.

![View of Postico connected to Prisma Postgres](https://www.prisma.io/img/ppg-postico.png)

## Related pages

- [`Firebase Studio`](https://www.prisma.io/docs/guides/postgres/idx): Learn how to use Prisma Postgres in the online Firebase Studio
- [`Fly.io`](https://www.prisma.io/docs/guides/postgres/flyio): Learn how to deploy applications using Prisma Postgres to Fly.io
- [`Netlify`](https://www.prisma.io/docs/guides/postgres/netlify): Learn how to create Prisma Postgres databases via the official Netlify extension and deploy your applications with it
- [`Vercel`](https://www.prisma.io/docs/guides/postgres/vercel): Learn how to create Prisma Postgres databases via the Vercel Marketplace and deploy your Next.js, Nuxt, and SvelteKit applications.
- [`VS Code`](https://www.prisma.io/docs/guides/postgres/vscode): The Prisma VS Code extension provides a management UI for Prisma Postgres and agent-mode support for GitHub Copilot