Methods, non-transitory computer readable media, and an apparatus that includes obtaining a database and metadata associated with the database in response to a request for data masking. Next, the obtained metadata is compared with the received request to determine when the obtained metadata validates the received request. A data masking operation is performed on the obtained database at a column level when the determination indicates the received request is validated. A record of the performance of the data masking operation on the obtained database at the column level is stored.