If you go towards DevOps, automated provisioning, you definetely will need to do things in automation.
Here is the command line, in case you need the new automated provisioned server to be added in your RDS security group:
aws rds rds-authorize-db-security-group-ingress –db-security-group-name mydbsecuritygroup –cidrip 192.168.1.10/27