Data Testing / REST Assured / Java Unit Testing

So in the past I have worked with rest assured and other java frameworks.

This is more an open ended question in what is the best / modern way to test data either sql / oracle ...etc

So the basics would be is you need to confirm data in a table is equal to a specific string / int / boolean ...etc. The test needs to be able to run via maven or something that can be integrated into a Jenkins type of environment so that it will be run on every build.

What would you suggest is the best way to achieve this any idea or tools that you have used would be welcome.

I have searched around and most people are just doing normal unit tests. But if i wanted to test production data that should remain static what would you suggest or are the best practices.

Thanks Flenters