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 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! - Flo8 Replies
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.
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. 🙂
You're welcome 🙏
@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?
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.
Awesome, will do!
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.
Thank you for your kind words 🙏