Hi, I want to do something like a MYSQL to MYSQL replication with some timestamp conversions as transformations in between. Can i do that using Airbyte using CDC similar to Streamsets?

I think so, you probably need to use custmo transformation to add the additional steps and conversions you want to apply