April 10, 2020, 5:11pm
It would be great if Retool could add Google's CloudSQL hosted database service as a resource option. This would be especially convenient in cases like mine, where the CloudSQL instance doesn't have a public IP, so instead I will need to set up a bastion host and use SSH tunneling to allow access to CloudSQL using the Retool Postgres resource.
I was able to hook up Google Cloud SQL.
Made the cloud instance IP public and whitelisted Retool’s IP per instructions here:
Retool connects to most databases, like Postgres, MySQL, MS SQL, MongoDB, etc.. Here's a list of all the currently supported data sources.To add a database, log into https://login.retool.com/ and navigate to Resources from the sidebar:Create a new...
It was for a small project though, maybe this is a security risk.
April 10, 2020, 10:12pm
Thanks for the note,
@zach-7! I’ll log this and share it with the rest of the team.
August 26, 2021, 4:03pm
I'm having trouble connecting to my Google SQL from Retool On Premise deploy.
The deploy seems to be working, as I can log in and add the Firebase resource.
But, I can't add MySQL with a connection to a Google Cloud SQL database (it times out):
I've added all of the Retool IP addresses to the Authorized networks
I've set up a static public IP address for the DB
I've created client SSL certificates for the DB
I've tested the connection with and without SSL, with and without self-signed certificates, different database users, etc
can connect via the command line using self-signed certificates, so I know my SSL certificates are working:
Any help is appreciated!
August 26, 2021, 5:50pm
Would you mind writing in to support via the chat icon in the bottom right corner of most Retool pages, or on Retool.com, as I think it will be easier for us to debug if we are able to look at your configuration (which you may not want to share on a public forum)
August 27, 2021, 1:30pm
Thanks for the reply. Will use the chat
November 7, 2022, 11:49am
Would you be able to share your solutions, please? We are facing a similar issue (with postgres though) and may be benefited from your solutions.
@Oliver! Stepping in here to try to help.
What error are you running into with your Postgres connection? Which IPs have you whitelisted?
List of IP addresses to whitelist here:
And also here (should be the same addresses for on prem instances):
Changes to Retool’s IP addresses for cloud and on-premise connections - #8 by Kabirdas