Automation for aggregation and queries

Hello,
I am working with Mongo Compass like QA and would like to automate my regression suite.
Could you please advise em what is the best approach for that .
There is not much information in the YT about running automation tests to test data. Also I thought will be great to schedule those tests to run on daily bases like I do with API tests.

I red about Mongo plugin for VSCode, but it looks like there is no opportunity to create a regression suite and run on schedule, but maybe I am missing something…

Thank you for the help and advice!

Best Regards,
Natalia