How to connect planetscale database using pgAdmin?

So I created a database in planetscale. Let's say the connection information looks like this...

database: mydb
username: myusername
host: aws.connect.psdb.cloud
password: mypassword

database: mydb
username: myusername
host: aws.connect.psdb.cloud
password: mypassword

I want to connect to the database using pgAdmin Under Add New Server > Connection > I enter in...

Host name/address: aws.connect.psdb.cloud
Port: 5432
username: myusername
password: mypassword

Host name/address: aws.connect.psdb.cloud
Port: 5432
username: myusername
password: mypassword

But it doesn't connect? What am I doing incorrectly? I also tried mysql://aws.connect.psdb.cloud/mydb?sslaccept=strict to no avail

2 Replies

Matvey•2y ago

PlanetScale uses MySQL and pgAdmin is for PostgreSQL there are not compatable

PaulOP•2y ago

Oh.... I was wondering why there wasn't an option on planetscale to choose between postgres vs mySQL. Thanks.