i want to connect my prisma db with dbbeaver.

[lament folio]

is it possible? i don't find any way on the settings

[pearl hatch]

You opted for speed from this bot. Let's conjure up an answer right now!

[pearl hatch]

Yes, it's possible to connect Prisma Postgres to DBeaver! You can do it using the @prisma/ppg-tunnel package. Here's how:

Step 1: Start the tunnel

Make sure your DATABASE_URL is set in your .env file, then run:

npx @prisma/ppg-tunnel --host 127.0.0.1 --port 52604

Keep this process running while you use DBeaver. Note the port number from the output. [viewing data guide]

Step 2: Connect in DBeaver

1. Open DBeaver and click New Database Connection (or File > New).
2. Select PostgreSQL as the database type.
3. Select the URL option in the "Connect by" section.
4. Enter the URL in this format:

   jdbc:postgresql://localhost:52604/postgres?sslmode=disable
   

   Replace 52604 with your actual port number.
5. No username or password is needed — authentication is handled by the tunnel.
6. Click Test Connection, and if successful, click Finish. [DBeaver guide]

Note: The TCP tunnel approach is deprecated in favor of direct TCP connections. Starting from Prisma 6.9, you can generate a standard TCP connection string directly from the Prisma Console and use it in DBeaver without needing the tunnel. [direct connections]

[pearl hatch]

✅ Great, thanks for letting us know that this solved your question!