SQL Parsing Tools for MongoDB

Apache Calcite

Apache Calcite is an industry-standard SQL parser, validator, and JDBC driver. It represents your query in relational algebra, transforms using planning rules, and optimizes according to a cost model. In addition, you can connect to third-party data sources, browse metadata, and optimize by pushing the computation to the data.

Export: -
Free edition: Yes
Query analysis: Yes
Query optimalization: Yes
Syntax validation: Yes