Amazon RDS | Connectors | Stacksync Documentation

Sign in to the AWS Management Console and open the Amazon RDS console at
https://console.aws.amazon.com/rds/
In the navigation panel, choose Databases to display a list of your DB instances.

Amazon RDS console navigation panel with "Databases" highlighted. — Navigation panel

Click on the DB you want to sync.
On the Connectivity & security tab, copy the endpoint and the port number.

Amazon RDS instance "mydb" Connectivity & security tab with the Endpoint and Port 3306 circled. — RDS endpoint and port number

Then click on the Configuration tab and view the Master username and DB name values.
If the DB name is empty as it is the case here, then use 'postgres' as DB name.
The password was set when the database was originally created. Please ask whoever set up the database for the connection password.

Amazon RDS Configuration tab with DB name, Master username "postgres" and Master password fields highlighted.

Use this template for the connection string and replace the element with your values

postgresql://USERNAME:YOUR_PASSWORD@ENDPOINT:PORT/DB_NAME

Paste the connection string into Stacksync

Stacksync Amazon RDS connection dialog with the "Connection String" field highlighted above the individual parameter fields.

If your database is in a private subnet and doesn't have any way to access it from internet currently, you can set up a jumpbox / bastion host to allow Stacksync to access your database using this tutorial:

Access a Private AWS RDS Instance via a Jumpbox