Been fighting with this for some time. Normally got around this running a local copy of my database on my local machine to get around all of the Google/SSL insanity. Burned myself on at least one occasion where my databases were not in-sync.

How does one successfully connect to a Google cloud based Postgres database to run a reverse-engineer of the database?

I have been trying by setting PG environment variables ... no joy ...

I have tried adding missing connection string parameters in the connection setup (it won't accept anything I try to add -> SSL Key, Root Certificate, SSL Password)

Apparently my searching skills suck.

Any help greatly appreciated.

To flesh it out a little more ...

I am trying to provide the data connection parameters to perform the generation of the dbContext and models for my database.

This is done by selecting "Reverse Engineer"

Which then provides the dialog:

You must then add a database connection:

You enter the parameters as required with any standard database connection and you may need to use "Advanced Settings":

In any case, I cannot get a working connection. Even though I can successfully connect using ADO.Net with a connectionstring (obfuscated) like the following ... without issue:

Host=[host ipaddress];Database=[database name];Username=[user name];Password=[password];SSL Mode=Require;SSL Certificate=client.pfx;SSL Password=[ssl password];Trust Server Certificate=true;Include Error Detail=true;Persist Security Info=true;Timeout=60;

client.pfx file was generated from original client-cert.pem file using openssl. (My understanding was that earlier versions of the Npgsql implementation did not like the pem file format).

If I fill in the dialogs as necessary with my known values and press test:

Which must indicate the SSL Password because I know the user connection password is correct. But if I try to add SSL Password in the advanced settings, I get: