A few years ago I was desperately looking for a tool just like mosql and was initially super hopeful that this would solve my problems only to become even more frustrated that this repo is out of date and no longer actively maintained. I spent dozens of hours forking and trying to fix issues to get it to work with my company's Mongo cluster at the time but it ultimately was more trouble than it's worth.
If anyone else is in a similar boat, check out https://rockset.com/solutions/mongodb/. You literally just enter your mongo connection info and you can run SQL on it, including joins, etc.
A few years ago I was desperately looking for a tool just like mosql and was initially super hopeful that this would solve my problems only to become even more frustrated that this repo is out of date and no longer actively maintained. I spent dozens of hours forking and trying to fix issues to get it to work with my company's Mongo cluster at the time but it ultimately was more trouble than it's worth.
If anyone else is in a similar boat, check out https://rockset.com/solutions/mongodb/. You literally just enter your mongo connection info and you can run SQL on it, including joins, etc.