All RDS instances that ClearCloud deploy are placed within the Data Subnet, within your VPC. This means that RDS can only communicate along the Private network and cannot reach the Public internet. Therefore, if you would like to connect to the RDS instance to perform work on a database, you will need to use the Linux Bastion, within your account, to SSH Tunnel to the RDS instance.
Within Sequel Pro, SSH Tunnelling is built in as standard. This makes it easy to connect to RDS.
To do this, first open up Sequel Pro and setup a new connection:
From here, fill in the following details:
| Field | Value |
| Name | A friendly name for the database connection |
| MySQL Host | Enter the hostname of the RDS instance you wish to connect to |
| Username | By default, we set this to 'admin' or 'pgadmin' (for PostgreSQL) |
| Password | This can be found in the SSM Parameter Store, under 'RDSMasterPassword' or similar |
| MySQL Server Port | By default, this should be 3306 |
| SSH Host | Enter the IP Address of the Linux Bastion |
| SSH User | This should be the IAM Username, we have setup for you |
| SSH Password | Press the Key Icon, and browse to your Private SSH Key |
From here, test the connection and press ok. You should now be able to access the RDS Instance and see the databases within.
If you have any further questions, please feel free to reach out to a member of our team.