Connecting from something like dbeaver
Hi there,
I would like to connect to my Prisma postrgres db via dbeaver. How/ where can I get a connection string that has the normal postrgres structure like postgresql://postgres:postgres@127.0.0.1:5432
Thanks
6 Replies
You chose to debug with a human. They'll tinker with your query soon. If you get curious meanwhile, hop into
#ask-ai for a quick spin!Hey @Ben Liger
You are looking for this: https://www.prisma.io/docs/postgres/tooling#2c-connect-to-prisma-postgres-using-dbeaver
Tooling | Prisma Documentation
Learn about connecting directly to your database via TCP tunnel
Thanks however after setting everything up as per the documentation I get the following error: code: 1002, reason: the auth proxy does not support client-side ssl
I do not have the "Use SSL" checkbox ticked in the SSL tab of my DBeaver connection so not sure why I'm getting this error message
Just to confirm, you have
?sslmode=disable appended to the connection string you pass in Dbeaver, right?I didn't but now it works. Thanks 🙂
I am glad to hear that 🙌