Any good tools for automating mySQL Queries verification?

I can't find a proper answer to this so here it goes. I work on a (sort of) big data project where we get tons of info from different sources in different shapes and forms. We then transform that into a normalized form, split that result in multiple tables, etc.

Everytime we modify or implement a new source, it goes like this. 1. I download the info. 2. I process the info. 3. I spend the whole day running queries checking data manually.

Any ideas or how do you recommend I Automate this part of my verification? (A specific tool, mySQL procedures maybe? just use workbench?) The only thing I'm trying to avoid is adding another layer, like an API or something, I should be able to do this hitting the DB directly