Problem: Unable to Connect to Supabase Database

[Eragbai2001]

I keep encountering the following error when trying to connect to my Supabase database:
Invalid prisma.owner.findUnique() invocation:

Can't reach database server at [your-database-url].
Please make sure your database server is running at [your-database-url].
I have checked and confirmed that my .env file is correctly set up with the proper DATABASE_URL, but the issue persists.

Steps I’ve Taken:

Verified the database URL in my .env file.
Checked my network connection.
Ensured that the Supabase project is running and accessible.
Can anyone help with troubleshooting or offer suggestions on what might be causing this issue?

Thank you!

[GaryAustin1]

Make sure you look at this guide: https://supabase.com/partners/integrations/prisma
Use the connect option to get urls as needed.

Note the default direct connection is ipv6 only and your system/router/network would all need to support ipv6.
Are you using the Supavisor connections?
Also special characters in the password can mess up the URL string if they are not URL encoded.

[Eragbai2001]

Thank you, i have resolved the issue