Cloud SQL

Find your Cloud SQL connection URL.

1. Go to your Google Cloud Console

2. Click on SQL

3. Write down the public IP address of the SQL Instance you want to user

4. Click on the instance you want to use

5. Go to "Users"

6. Make sure the user you want to use is listed here, let's take "fake_user"

NOTE: You can manage the user's password by clicking on the 3 dots

NOTE: you can add a new user by clicking "ADD USER ACCOUNT"

7. Click on "Databases" find the database inside the SQL Instance

  1. Write down the Database Name you want to use, here let's take "my_tutorial_database"

  1. In Cloud SQL the port is always 5432, The connection string will then be of the form: postgres://[USER]:[PASSWORD]@[PUBLIC_IP_ADDRESS] :5432/[DATABASE_NAME] In our example: postgres://fake_user:********@74.75.177.158:5432/my_tutorial_database- you can now paste into Stacksync

That's it! 🥳

Last updated