https://supabase.com/ logo
#sql
Title
# sql
b

BigBear

07/31/2021, 11:33 PM
Hi, new Supabase user here. I'm wondering whether it's possible to connect to Supabase database using the 'regular' postgres Python libraries /ORMs (i.e. where you normally need a host/port and username, password).
s

Scott P

07/31/2021, 11:37 PM
Yep - you can connect directly to the DB using any regular PG-supporting library. For example, in JS, we can use sequelize to connect to supabase DB's
b

BigBear

07/31/2021, 11:40 PM
Maybe it's. a bit of a stupid question, but how would I do that specifically? Right now, I am connected successfully using the supabase-py library using a the url and the key as supplied by the dashboard, but the postgres library requires a username and password to authenticate.
s

Scott P

07/31/2021, 11:42 PM
The DB details are available in the dashboard. The username should be
postgres
(check the dashboard for sure), and the password will be the one you set when creating the project. Python isn't my area of experience so I can't provide any support on the code side of things
b

BigBear

07/31/2021, 11:52 PM
Okay, yep, found it and it works. Thanks!
m

magicquin

08/01/2021, 2:27 AM
Hi BigBear, im trying to do the samething, could you share with me.