Solutions For Updated Staging Databases

Hi, my use case is this: I am currently looking for nifty solutions that needs to do the following things:

ENV: RDS MySQL 8.x.x with 100+ Tables and Foreign Key Constraint Galore

1. Take the Snapshot of The Production Database, mask all the columns within tables specified in some config to remove PII.
2. Look to reduce the size of the database wherever possible, for eg: Don't reduce the SKU Table but reduce the Orders Table so that all SKUs are available for testing but Orders aren't necessary because they can be recreated in staging anyway. Handle FKey constraints on deletion.

I am exploring DMS with Rule Set implementation for achieving 1 however, I was wondering if there are any tools/solutions that are being implemented in the industry currently that achieve both. What are the downsides, etc.