Connect Prisma Postgres without Prisma Client?

[proud crane]

Hi there 👋

I am right now trying out the new Prisma hosted Postgres offering. As I want to migrate a bucnh of data from my existing CockroachDB I'd love to connect with the regular psql tooling or other 3rd party SQL tools to the database. However, it seems to me that with the provided credentials I am currently required to use the Prisma client.

I build a workaround for now using a seed.js script and npx prisma db seed but having access to a proper postgres connection would still be great.

Am I missing something or is this a current(?) limitation of the Prisma hosted Postgres offering?

Thanks! - Flo

[dusk moon]

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

[dark canopy]

Hi @proud crane

Thank you for trying out Prisma Postgres.

Currently it is not possible to connect directly to your Prisma Postgres database, and this will prevent you from using tools such as Table Plus. You can use Prisma Studio instead, and we are working on providing direct database access at a future date.

[proud crane]

Ok - thanks for the quick reply! Looking forward to that feature eventually and totally get it that it's missing in this beta access state right now. 🙂

[dark canopy]

You're welcome 🙏

[pliant basin]

@dark canopy I was coming to ask this same question, I'm assuming it's still not possible to get a direct connect URL for prisma postgres dbs?

[dark canopy]

At the moment, it isn't but we do have plans to add that feature. You can also please fill this form and tell us more about your usecase.

[pliant basin]

Awesome, will do!

[pliant basin]

FYI I was trying out optimize and prisma-postgres at the same time, so I stood up the DB and used the https://github.com/prisma/prisma-examples/tree/latest/accelerate/nextjs-starter project.

It turns out everything works fine by just using the DB creds provided in the DIRECT_URL var 🤙

p.s. prisma postgres is amazing and 100% makes setting up and using dbs 1000x better!