When it comes to AWS remote database management, if you can't install the agent directly on the private host, you can set up a bastion running the agent.
On a recent project, we needed to add a new AWS Lambda that would touch an already existing relational database service (RDS) instance. Here's our solution.
As far as I’m aware, there isn’t a built-in solution for statically typing a configuration for CDK. So after a bit of research, I created a way of doing it!
Here's how to use the AWS command-line interface to run a database migration by leveraging a task definition for a service running on your ECS cluster.