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.
A description of using pipes with ssh in a way that allows the results of mysqldump on a remote machine to be stored locally without creating a temporary file.