This Ruby script using the aws sdk library, check sometime if the Aurora cluster has failed over to another instance, and if so it raises a child Sensu alert.
It takes as parameter the db-cluster-id and it returns a exit code and exit message which can be interpreted by any monitoring system.
You can read and download it from my repo
here