# Viewing data (/docs/guides/postgres/viewing-data)
Location: Guides > Postgres > Viewing data
You can view and edit your data in Prisma Postgres using either [Prisma Studio](/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:
You can also run Prisma Studio locally by running:
#### npm
```bash
npx prisma studio
```
#### pnpm
```bash
pnpm dlx prisma studio
```
#### yarn
```bash
yarn dlx prisma studio
```
#### bun
```bash
bunx --bun prisma studio
```
This should start a live server in `http://localhost:5555` where you can visit and interact with your database.
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, Postico etc using [`@prisma/ppg-tunnel` package](https://www.npmjs.com/package/@prisma/ppg-tunnel). See the example below to connect using TablePlus.
1. Create a TCP tunnel to access Prisma Postgres directly [#1-create-a-tcp-tunnel-to-access-prisma-postgres-directly]
If you already have a `.env` file in your current directory with `DATABASE_URL` set, the tunnel CLI will automatically pick it up, no need to manually export it. However, if you haven't set up a `.env` file, you'll need to set the `DATABASE_URL` environment variable explicitly.
In your terminal, to set the environment variable `DATABASE_URL` referring to your Prisma Postgres instance which you want to connect to (be sure to replace the `API_KEY` placeholder with the connection string value for your Prisma Postgres instance):
#### macOS
```bash
export DATABASE_URL="prisma+postgres://accelerate.prisma-data.net/?api_key=API_KEY"
```
#### Linux
```bash
export DATABASE_URL="prisma+postgres://accelerate.prisma-data.net/?api_key=API_KEY"
```
#### Windows
```cmd
set "DATABASE_URL=prisma+postgres://accelerate.prisma-data.net/?api_key=API_KEY"
```
> [!NOTE]
> If you explicitly set `DATABASE_URL` in your terminal, that value will take precedence over the one in your `.env` file.
Run the following command to connect to your Prisma Postgres instance via `@prisma/ppg-tunnel` package:
#### npm
```bash
npx @prisma/ppg-tunnel --host 127.0.0.1 --port 52604
```
#### pnpm
```bash
pnpm dlx @prisma/ppg-tunnel --host 127.0.0.1 --port 52604
```
#### yarn
```bash
yarn dlx @prisma/ppg-tunnel --host 127.0.0.1 --port 52604
```
#### bun
```bash
bunx --bun @prisma/ppg-tunnel --host 127.0.0.1 --port 52604
```
```text wrap
Prisma Postgres auth proxy listening on 127.0.0.1:52604 🚀
Your connection is authenticated using your Prisma Postgres API key.
...
==============================
hostname: 127.0.0.1
port: 52604
username:
password:
==============================
```
Copy the **`port`** from the output above, you will need it in the next step.
Keep this tunnel process running while you are using the database editor to maintain the connection.
2a. Connect to Prisma Postgres using TablePlus [#2a-connect-to-prisma-postgres-using-tableplus]
Based on the database editor you are using, you can connect to your Prisma Postgres instance using the details you obtained from the output of the `@prisma/ppg-tunnel` package. To add the connection string 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**: `127.0.0.1` in this case.
* **Port**: The **`port`** number you obtained from the output of the `@prisma/ppg-tunnel` package.
* **User**: This will be ignored due to the tunnel, you can provide any value here.
* **Password**: This will be ignored due to the tunnel, you can provide any value here.
4. Click on **Connect** to connect to your Prisma Postgres instance.
2b. Connect to Prisma Postgres using DataGrip [#2b-connect-to-prisma-postgres-using-datagrip]
Based on the database editor you are using, you can connect to your Prisma Postgres instance using the details you obtained from the output of the `@prisma/ppg-tunnel` package. To add the connection string 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**: `127.0.0.1` in this case.
* **Port**: The **`port`** number you obtained from the output of the `@prisma/ppg-tunnel` package.
* **User**: This will be ignored due to the tunnel, you can keep this field empty.
* **Password**: This will be ignored due to the tunnel, you can keep this field empty.
* **URL**: In the URL append the following query parameter `?sslmode=disable` to the end of the URL.
4. Click on **Test Connection** to ensure that DataGrip can connect to your Prisma Postgres instance. Once successful, click **OK** to save the connection.
2c. Connect to Prisma Postgres using DBeaver [#2c-connect-to-prisma-postgres-using-dbeaver]
Based on the database editor you are using, you can connect to your Prisma Postgres instance using the details you obtained from the output of the `@prisma/ppg-tunnel` package. To add the connection string 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://localhost:52604/postgres?sslmode=disable`. Here make sure that you enter the port number you obtained from the output of the `@prisma/ppg-tunnel` package. In this case, the port number is `52604`. There is no need to enter Username or Password as authentication is manged by Tunnel.
5. Click on **Test Connection** to ensure that DBeaver can connect to your Prisma Postgres instance. If successful, click **Finish**.
2d. Connect to Prisma Postgres using Postico [#2d-connect-to-prisma-postgres-using-postico]
Based on the database editor you are using, you can connect to your Prisma Postgres instance using the details you obtained from the output of the `@prisma/ppg-tunnel` package. To add the connection string 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**: `127.0.0.1` in this case.
* **Port**: The **`port`** number you obtained from the output of the `@prisma/ppg-tunnel` package.
* **User**: This will be ignored due to the tunnel, you can keep this field empty.
* **Password**: This will be ignored due to the tunnel, you can keep this field empty.
3. Check "Pre-Connect Shell Script" and enter:
```sh
cat <
## 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 superpowers for Copilot agent mode