MongoDB SQL Interface: Now Available for Enterprise Advanced

Summary

MongoDB has released the general availability of the MongoDB SQL Interface for MongoDB Enterprise Advanced on self-managed deployments running MongoDB 6.0 or higher. Previously, teams relying on SQL-based business intelligence tools faced maintenance bottlenecks when learning MongoDB Query Language or creating custom extract, transform, and load pipelines. The new interface translates standard SQL queries into native MongoDB operations in real time using MongoSQL, a SQL-92 compatible dialect. Users utilize a Schema Builder CLI to generate JSON schemas that map nested document structures and store them alongside data for query validation. This native query translation replaces the MongoDB BI Connector, which will remain supported until September 2026, while offering improved performance and direct connectivity via JDBC and ODBC drivers.

Context

Organizations using SQL-based tools struggle to access MongoDB data, requiring teams to either learn MongoDB Query Language (MQL) or build and maintain custom ETL pipelines. These approaches cause fragmented reporting workflows, maintenance overhead, outdated data, and dependency bottlenecks.

Approach / What changed

MongoDB SQL Interface provides direct SQL access through custom connectors for Tableau and Power BI, as well as JDBC and ODBC drivers. A Schema Builder CLI inspects collections to generate JSON Schema definitions stored alongside data, allowing real-time translation of SQL-92 queries into MongoDB operations without server configuration changes.

Takeaways

• MongoDB SQL Interface is generally available for MongoDB Enterprise Advanced on MongoDB 6.0 or higher without requiring server configuration changes.
• The Schema Builder CLI analyzes collection patterns and nested arrays to build JSON schemas stored alongside data for query validation and type mapping.
• The interface replaces MongoDB BI Connector with native operation execution and improved performance, though BI Connector remains supported until September 2026.

Related reading