Trying to set the AWS CLoudWatch Alerting to my RDS module in our local Stash/Bitbucket

Fellas,
We have a Terraform RDS module setup in the Stash/BitBucket in-house. We have the basic RDS Setups in our Terraform Module, like creating DB’s or Clusters , mostly for Aurora.
Now we are trying to add the CLoudwatch alerting option to it so that the clients can create SNS topics within their code to create the alerts they needed.
I am trying to see if anyone here worked on this type of case before and if they did, how did they parameterized for individual DB types in AWS RDS?

Any help will be appreciated.

Thanks
Vikram