RDS SQLAlchemy Connection Strings (if all of your databases are postgreSQL)

ec2_instance_connections.py

# I'm a one trick pony, but I can do ec2 conns too
import boto3

ec2 = boto3.client('ec2')
instances : list = ec2.describe_instances()['Reservations']

def _make_string_from_instance(instance):
  key_name = instance['KeyName']
  public_dns_name = instance['NetworkInterfaces'][0]['Association']['PublicDnsName']
  
  return f"ssh -i ~/{key_name}.pem.txt ec2-user@{public_dns_name}"
  
for instance in instances:
  instance = instance['Instances'][0]
  connection_string = _make_string_from_instance(instance)
  print(connection_string)

rds_sqlalchemy_conn_strings.py

import boto3

rds = boto3.client('rds')
instances = rds.describe_db_instances()['DBInstances']
password = input("database_password: ")

def _make_string_from_instance(instance, password=password):
  host_name = instance['Endpoint']['Address']
  db_name = instance['DBName']
  user_name = instance['MasterUsername']
  port = instance['Endpoint']['Port']
  
  return f"postgresql+psycopg2://{user_name}:{password}@{host_name}:{port}/{db_name}"


for instance in instances:
  connection_string = _make_string_from_instance(instance)
  print(connection_string)