Prisma•14mo ago

Connect Prisma Postgres without Prisma Client?

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

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

RaphaelEtim•10/24/24, 3:36 PM

Hi @fgoessler

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.

fgoesslerOP•10/24/24, 3:37 PM

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.

RaphaelEtim•10/24/24, 3:39 PM

You're welcome

brandbydan•10/30/24, 2:37 PM

@RaphaelEtim 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?

RaphaelEtim•10/30/24, 2:40 PM

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.

Tally FormsTally Forms

Direct TCP for Prisma Postgres

brandbydan•10/30/24, 2:42 PM

Awesome, will do!

brandbydan•10/30/24, 3:11 PM

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!

GitHub

prisma-examples/accelerate/nextjs-starter at latest · prisma/prisma...

Ready-to-run Prisma example projects. Contribute to prisma/prisma-examples development by creating an account on GitHub.

RaphaelEtim•10/30/24, 3:12 PM

Thank you for your kind words