Pattern for streaming changes from RDS

You can simply integrate database to stream changes to Kinesis of MSK. The best practices would surround across the no. of tables you like to stream and what are the use cases. I have done a similar configuration for making data available to multiple consumers as well as generating real-time alerts for a specific use case. The stream will be near real-time and does not require major code implementation. See the reference architecture : https://aws.amazon.com/blogs/database/use-the-aws-database-migration-service-to-stream-change-data-to-amazon-kinesis-data-streams/