> For the complete MongoDB documentation index, see www.mongodb.com/docs/llms.txt # SQL Interface Changelog **Note: Release Notes Mention Only Releases with Feature Changes** MongoDB releases SQL Interface drivers and connectors in a continuous deployment manner. This release cadence allows us to continuously improve SQL Interface performance and stability. These release notes capture only those releases that contain direct user feature changes. If a particular SQL Interface release contains only performance and stability improvements, it is not included in these release notes. *Released September 29, 2026* - Introduces general availability of the MongoDB SQL Interface (Atlas Dedicated). You can now enable the SQL Interface directly on an Atlas dedicated cluster, `M10` and above, running MongoDB 6.0 or later, with no federated database instance required. - Enable or disable the SQL Interface per cluster from the cluster configuration form in the Atlas UI or with the Atlas Administration API. To learn more, see [SQL Interface Server Setup.](https://www.mongodb.com/docs/sql-interface/connect-with-sql-composable.md#std-label-connect-with-sql-composable) - Manage schemas for a dedicated cluster with the MongoDB SQL Schema Builder CLI. To learn more, see [Schema Management.](https://www.mongodb.com/docs/sql-interface/schema-management.md#std-label-sql-schema-management) - The SQL Interface supports dedicated clusters on both the Atlas Core Database Edition and the Atlas Infinite Database Edition. Atlas Infinite Database Edition is available as a public preview. - The Atlas Administration API endpoints for the SQL Interface are available in preview. Requests must send the `Accept: application/vnd.atlas.preview+json` header. - Updates the ODBC (Open Database Connectivity) driver to version 3.0.0. - To connect to the MongoDB SQL Interface (Atlas Dedicated) with the ODBC (Open Database Connectivity) driver, you must use version 3.0.0. - Updates the MongoSQL engine that the driver uses to version 2.0.1. - Updates the JDBC (Java Database Connectivity) driver to version 4.0.0. - To connect to the MongoDB SQL Interface (Atlas Dedicated) with the JDBC (Java Database Connectivity) driver, you must use version 4.0.0. - Updates the MongoSQL engine that the driver uses to version 2.0.1. *Released September 25, 2026* - Updates the MongoSQL engine to version 2.0.1. - Fixes an issue where the `IN` operator applied implicit type conversion to the values in the list even when the compared field is a string. This caused queries, such as `WHERE employeeId IN ('0035759', '1033282')`, to return incomplete results. *Released September 10, 2026* - Updates the MongoSQL engine to version 2.0.0. - Changes how MongoSQL translates `WHERE` clauses that compare a field to a literal value, such as `WHERE x > 20`. These comparisons are now translated to MongoDB match language instead of `$expr` expressions. MongoDB match language applies type bracketing. With type bracketing, MongoDB compares only values that have the same type as the predicate of your query. This change encourages index usage, but it may affect the results of your queries if your fields are polymorphic. MongoSQL queries that run through Atlas Data Federation are not affected. Consider the following collection, where one document stores `age` as the number `25` and the other stores it as the string `"25"`: ```javascript [ { "_id": 1, "name": "John Doe", "age": 25 }, { "_id": 2, "name": "Jane Doe", "age": "25" } ] ``` To return all users where `age` is greater than `20`, you can write the aggregation pipeline with `$expr`: ```javascript [ { $match: { $expr: { $gt: [ "$age", 20 ] } } } ] ``` This pipeline returns both documents, even though the `$gt` clause compares against a number: ```javascript [ { _id: 1, name: 'John Doe', age: 25 }, { _id: 2, name: 'Jane Doe', age: '25' } ] ``` You can also write the same query using match language: ```javascript [ { $match: { age: { $gt: 20 } } } ] ``` This pipeline returns only the document where `age` is a number. The `{ $gt: 20 }` condition matches only numbers. MongoDB returns only documents that contain numbers greater than `20`: ```javascript [ { _id: 1, name: 'John Doe', age: 25 } ] ``` Compare the results of your queries as you upgrade to version 2.0. To learn more about type bracketing, see [Type Bracketing.](https://www.mongodb.com/docs/manual/reference/method/db.collection.find/#type-bracketing) - Adds support for the higher order functions `MAP`, `FILTER`, and `REDUCE`. Also adds the following functions, which wrap `MAP`, `FILTER`, or `REDUCE` functionality: `ARRAY_CAST`, `ARRAY_EXTRACT`, `ARRAY_COMPACT`, `ARRAY_COUNT_IF`, `ARRAY_REMOVE`, `ARRAY_SUM`, `ARRAY_PRODUCT`, `ARRAY_AVG`, `ARRAY_ALL`, `ARRAY_ANY`, and `ARRAY_JOIN`. - Fixes a bug in `LEFT JOIN` and `RIGHT JOIN` operations that meet certain criteria. Specifically, the query used a `LEFT JOIN` or `RIGHT JOIN` with a single field-to-field equality condition in the `ON` predicate, where one field was from the left join source and the other was from the right join source. If the schema indicated that both fields were nullable, the result set omitted some rows. For `LEFT JOIN`, rows from the left source where the join key value was nullish (`NULL` or `MISSING`) were omitted from the result set even though they should have been included. Likewise, the same issue affects `RIGHT JOIN` for rows from the right source. Non-nullish rows that did not have a match were still included in the result sets. Only rows with nullish values were omitted. *Released August 26, 2026* - Updates the MongoSQL Transition Readiness Tool to version 1.1.3. - Escapes database, collection, and field names supplied by the server before the tool writes them to the generated HTML reports. Previously, a name that contained HTML markup could run script in the browser of the user who opened a report. This fix addresses [CVE-2026-76798](https://www.cve.org/CVERecord?id=CVE-2026-76798) and [CVE-2026-76794.](https://www.cve.org/CVERecord?id=CVE-2026-76794) - Escapes query text and user names read from Atlas BI Connector logs before the tool writes them to the generated HTML reports. - Neutralizes formula elements in the cell values of the generated CSV reports. Previously, a collection or field name that began with `=`, `+`, `-`, or `@` could run as a formula when the user opened the report in a spreadsheet application. This fix addresses [CVE-2026-76797.](https://www.cve.org/CVERecord?id=CVE-2026-76797) *Released July 30, 2026* - Updates the JDBC (Java Database Connectivity) driver to version 3.0.8 and the ODBC (Open Database Connectivity) driver to version 2.0.10. - Upgrades the SQL translation engine to the latest version, which adds query optimizations and fixes an intermittent error that occurred when resolving the right-hand side schema of a lateral join. *Released July 23, 2026* - Updates the ODBC (Open Database Connectivity) driver to version 2.0.9. - Adds support for Linux arm64 architectures. - Fixes an error that occurred when an application passed a null `catalogName` argument to `SQLTablesW`. The driver now treats a null pattern argument as equivalent to `%`, as the ODBC specification requires. - Fixes an issue where the driver could launch an operating system protocol handler for an OIDC authorization endpoint that did not use `https`. The driver now validates the endpoint scheme before opening the URL. This fix addresses [CVE-2026-19502.](https://www.cve.org/CVERecord?id=CVE-2026-19502) - Removes the OpenSSL requirement. The driver now uses `rustls` for secure connections. *Released July 9, 2026* - Updates the MongoDB SQL Schema Builder CLI to version 1.2.1. The following fixes in this release address [CVE-2026-19502:](https://www.cve.org/CVERecord?id=CVE-2026-19502) - Fixes an issue where the CLI could launch an arbitrary operating system protocol handler from an unchecked path scheme. - Fixes an issue where the CLI logged the connection string and password in plain text to the terminal and to the log file. The CLI now redacts these values. *Released June 9, 2026* - Updates the MongoDB SQL Schema Builder CLI to version 1.2.0. *Released June 4, 2026* - Updates the ODBC (Open Database Connectivity) driver to version 2.0.8. - Fixes a connection failure that occurred when using the LDAP (deprecated) authentication mechanism with a password containing a reserved symbol (`:`, `/`, `?`, `#`, `[`, `]`, or `@`). - Upgrades third-party dependencies. *Released April 20, 2026* - Updates the JDBC (Java Database Connectivity) driver to version 3.0.6. - Upgrades third-party dependencies. *Released April 14, 2026* - Updates the ODBC (Open Database Connectivity) driver to version 2.0.7. - Improves compatibility with applications such as SAS that look up the data source name during connection setup. - Fixes an error that could occur when your Business Intelligence tool retrieves the list of databases from your MongoDB data source and tries to retrieve more rows after exhausting the result set. - Upgrades third-party dependencies. *Released April 13, 2026* - Updates the MongoDB SQL Schema Builder CLI to version 1.1.3. - Directs schema reads to a secondary or analytics node when one is available and falls back to the primary node otherwise. - Fixes an error that caused the CLI to crash if a view referenced a collection that didn't exist. The CLI now reports the error and continues. *Released March 17, 2026* - Updates the MongoDB SQL Schema Builder CLI to version 1.1.2. - Fixes an error that prevented the CLI from generating schemas for time series collections. *Released March 16, 2026* - Updates the ODBC (Open Database Connectivity) driver to version 2.0.6. - Improves connection performance on Windows by caching the DNS resolver after the initial fallback. The driver now performs DNS fallback only once and reuses the cached resolver for subsequent connections. - Adds automatic retry logic for transient errors. The driver now retries failed operations up to three times with exponential backoff, improving reliability when connections fail due to network instability or idle connection timeouts. *Released February 26, 2026* - Updates the MongoDB SQL Schema Builder CLI to version 1.1.1. - Directs schema reads to an analytics node when one is available and falls back to another available node otherwise. - Improves the schema production for large datasets with unstable data fields. - Limits the number of concurrent tasks that the CLI runs, which reduces memory use and the number of in-flight queries. *Released February 19, 2026* - Updates the ODBC (Open Database Connectivity) driver to version 2.0.5. - Fixes connectivity issues for SRV connection strings on Windows by ensuring the driver correctly falls back to the system DNS resolver if the primary Cloudflare DNS fails. *Released February 10, 2026* - Updates the JDBC (Java Database Connectivity) driver to 3.0.5 and the ODBC (Open Database Connectivity) driver to version 2.0.4. - Fixes an issue where SQL queries containing an `OR` condition in a `WHERE` clause incorrectly filtered out rows. This occurred when one operand of the `OR` condition evaluated to `UNKNOWN` (due to a `NULL` or missing value in a nullable field) while the other evaluated to `TRUE`. This behavior deviated from standard three-valued SQL semantics and could result in incomplete result sets. **Important:** - On-premises (EA) users should upgrade to the latest driver versions (JDBC (Java Database Connectivity) driver 3.0.5 or later and ODBC (Open Database Connectivity) driver 2.0.4 or later). - Atlas SQL users receive this fix automatically. However, you should refresh impacted dashboards or re-execute queries to update existing results. - For the JDBC (Java Database Connectivity) driver, connection validation failures now include more descriptive error messages that tell you the underlying cause. This improvement specifically assists Tableau Cloud users in diagnosing issues where driver or system logs are not directly accessible. - Fixes the ODBC (Open Database Connectivity) driver compatibility issue with Power BI introduced by the previous version. - Updates the ODBC (Open Database Connectivity) driver to version 2.0.3. - Upgrades third-party dependencies. *Released January 8, 2026* - Updates the ODBC (Open Database Connectivity) driver to version 2.0.2. - Adds DNS resolver fallback logic on Windows. The ODBC (Open Database Connectivity) driver now reverts to the system default resolver if the primary Cloudflare resolver fails, ensuring reliable connectivity in restricted network environments. *Released November 24, 2025* **Important:** If you use Kerberos, OIDC (OpenID Connect), or x509 authentication methods, upgrade to JDBC (Java Database Connectivity) 3.0.4 or later and the Tableau custom connector to 1.4.5 or later. - Updates the Tableau custom connector (for the MongoDB JDBC driver) to version 1.4.5. - Adds sections to the connection dialog for specific authentication mechanisms: Username and Password, X509, GSSAPI, and OIDC. - Updates the JDBC (Java Database Connectivity) driver to version 3.0.4. - Introduces support for OIDC (OpenID Connect) machine flow authentication. This enables Tableau Server users to publish and refresh reports securely without relying on embedded usernames and passwords. The driver now natively supports machine flow authentication for Kubernetes, Google Cloud, and Azure (Microsoft Azure) environments, via the `authMechanismProperties` connection URI (Uniform Resource Identifier) parameter. - Introduces Kerberos support for Tableau Desktop. This includes the addition of the following configuration properties: - `jaasconfigpath` - `gssnativemode` - `gssapilogincontextname` - `gssapiserverauth` *Released October 23, 2025* - Updates the JDBC (Java Database Connectivity) driver to version 3.0.3. - Adds new option `tlsCaFile` support in the URI and as a property `tlscafile`. *Released October 14, 2025* - Updates the ODBC (Open Database Connectivity) driver to version 2.0.1. - Fixes a local privilege escalation vulnerability ([CVE-2025-11575](https://www.cve.org/CVERecord?id=CVE-2025-11575)) in the Windows installer by correcting permissions for custom installation paths. *Released September 17, 2025* - Introduces general availability of MongoDB SQL Interface. This modern toolset replaces the legacy [MongoDB Connector for BI](https://www.mongodb.com/docs/bi-connector/current/) and provides a unified and consistent set of SQL drivers and connectors for both Atlas and on-premises deployments. This feature is now available for all MongoDB Enterprise Advanced customers with the introduction of the schema builder for on-premises schema management. To learn more, see [MongoDB SQL Interface Overview.](https://www.mongodb.com/docs/sql-interface/index.md#std-label-connect-with-sql-overview) - Introduces MongoDB SQL Schema Builder 1.1.0 for on-premises schema management. - Updates the ODBC (Open Database Connectivity) driver to version 2.0.0. - Introduces on-premises connectivity support. - Introduces support for Kerberos (GSSAPI) authentication, enabling secure connections in enterprise environments and providing a critical feature for users migrating from the legacy [MongoDB Connector for BI](https://www.mongodb.com/docs/bi-connector/current/). - Fixes an issue that prevented tables from being listed when connecting via certain tools, such as Microsoft SQL Server Linked Server. The driver now correctly handles `SQLTables` calls with null `TableType` parameters. - Updates the JDBC (Java Database Connectivity) driver to version 3.0.1. - Introduces on-premises connectivity support. *Released August 12, 2025* - Updates the ODBC (Open Database Connectivity) driver to version 1.4.6. - Fixes error in the ODBC (Open Database Connectivity) driver version 1.4.5 that caused the driver to panic when a user with the minimum set of permissions retrieves the list of accessible tables. *Released July 29, 2025* - Updates the Tableau custom connector (for the MongoDB JDBC (Java Database Connectivity) driver) to version 1.4.4. - Removes log-related fields from the connection dialog to enhance security. You can still configure logging options `loglevel` and `logdir` in Tableau using the properties file (`mongodb_jdbc.properties`) to customize the connection. See the [Tableau documentation](https://help.tableau.com/current/pro/desktop/en-us/connect_customize.htm#use-a-properties-file-to-customize-a-jdbc-connection) for more details. *Released July 15, 2025* - Updates the ODBC (Open Database Connectivity) driver to version 1.4.5. - Updates ODBC (Open Database Connectivity) OIDC (OpenID Connect) default scope to send `openid` with `offline_access` and only intersect with IdP reported scopes if the set is not empty. - Makes `SQLEndTran` a no-op. - Updates the Rust driver to version 3.2.4. *Released June 18, 2025* - Updates the JDBC (Java Database Connectivity) driver to 2.3.0. - Introduces a new property `disableclientcache` to disable client caching in the JDBC driver. You must use this property with care and it is intended for server environments where the JDBC (Java Database Connectivity) driver is used to connect to a variable number of customer databases to run queries at varying frequencies. **Warning:** To avoid recurring re-authentication flows, do not use this property with the OIDC authentication mechanism. *Released June 12, 2025* - Updates the JDBC (Java Database Connectivity) driver to version 2.2.4. - Fixes an issue with the JDBC (Java Database Connectivity) driver so that it now rejects invalid values for `setFetchSize` and provides a clear error message. - Adds OIDC (OpenID Connect) default scope to support more IdPs configurations (for example, Azure OIDC (OpenID Connect)). *Released April 30, 2025* - Updates the ODBC (Open Database Connectivity) driver to version 1.4.4. *Released April 9, 2025* - Updates the JDBC (Java Database Connectivity) driver to version 2.2.3. - Fixes an issue with OIDC authentication not opening the browser for sign-on on macOS. - Enhances logging capabilities with additional information for the JDBC driver. *Released March 28, 2025* - Updates the ODBC (Open Database Connectivity) driver to version 1.4.3. - Fixes a bug in `SQLDriverConnect` where the driver crashes if `StringLength2Ptr` is `null`. *Released March 5, 2025* - Updates the Tableau custom connector (for the MongoDB JDBC driver) to version 1.4.2. - Renamed the connector from MongoDB Atlas to MongoDB SQL Interface. *Released January 6, 2025* - Updates the ODBC (Open Database Connectivity) driver to version 1.4.2. - Updates internal ODBC (Open Database Connectivity) processing to improve BI (Business Intelligence) tools integration. *Released Dec 18, 2024* - Updates the JDBC (Java Database Connectivity) driver to version 2.2.1. - Implements `getCursorName()` to improve compatibility with database tools. - Improves error message for authentication failures. *Released December 6, 2024* - Updates the Tableau custom connector (for the MongoDB JDBC driver) to version 1.4.0. - Moves the logging information UI for the Tableau Connector into an Advanced tab. *Released August 15, 2024* - Releases version 2.2.0 of the JDBC driver. - Introduces driver support for jBoss Log Manager for logging. - Updates UUID string representation to the extended json uuid format `{$uuid : "val"}` instead of the generic base64 binary data format `{ "$binary":{"base64": "base64val", "subType": "xx"}`. For `subType 03`, you can use the [uuidRepresentation](https://www.mongodb.com/docs/manual/reference/connection-string/#mongodb-urioption-urioption.uuidRepresentation) connection option. *Released July 8, 2024* - Introduces OIDC (OpenID Connect) authentication for the ODBC (Open Database Connectivity) driver. - Updates the ODBC (Open Database Connectivity) driver to version 1.4.1. - Adds conversion support for `wlongvarchar` and `wvarcchar` in the ODBC (Open Database Connectivity) driver. - Addresses the low and medium static code analysis findings for the ODBC (Open Database Connectivity) driver. *Released June 27, 2024* - Updates the JDBC (Java Database Connectivity) driver to version 2.1.4. - Updates the ODBC (Open Database Connectivity) driver to version 1.3.4. - Publishes checksum for validating the signed msi for ODBC (Open Database Connectivity). *Released June 24, 2024* - Updates the Tableau custom connector (for the MongoDB JDBC driver) to version 1.3.0. - Adds the ability to choose between two authentication types: - `Certificate / Token` - `Username and Password` If you choose `Certificate / Token`, the username and password are not required. *Released June 21, 2024* - Updates the JDBC (Java Database Connectivity) driver to version 2.1.3. - Introduces oidc authentication for the JDBC (Java Database Connectivity) driver. - Adds caching of `MongoClient` instances. *Released May 22, 2024* - Updates the ODBC (Open Database Connectivity) driver to version 1.3.3. - Adds a checkbox on the ODBC (Open Database Connectivity) driver DSN configuration UI to indicate whether to limit the maximum string length to 4000 characters. To work with BI tools, like Microsoft SQL Server Linked Server, which can't handle variable length string data with no known maximum length, you must enable this option. *Released April 24, 2024* - Updates the JDBC (Java Database Connectivity) driver to version 2.1.2, which now ignores both "true" and "false" `setAutoCommit` values instead of returning an exception when "true". *Released April 22, 2024* - Updates the ODBC (Open Database Connectivity) driver to version 1.3.0. - Adds support for result set data column-wise binding. - Adds support for SQLCancel. - Changes the non-standard data type (such as `document` and `oid`) default mapping from `SQL_UNKNOWN_TYPE` to `SQL_WVARCHAR`. This change affects only programmatic integrations relying on SQL type names; it doesn't affect Power BI. *Released March 4, 2024* - Updates the Power BI connector to version 1.2.0. - Adds support for Direct Query. Direct Query capabilities require ODBC (Open Database Connectivity) driver version 1.2.0 or later. *Released March 1, 2024* - Updates the ODBC (Open Database Connectivity) driver to version 1.2.0. - Adds support for ODBC (Open Database Connectivity) clients requesting the driver to exhibit ODBC (Open Database Connectivity) 2.0 behavior. - Adds support for `SQLFreeStatement`. - Adds support for `SQLFetchScroll`. - The column order in result sets now adheres to the SQL-92 specification. Result set columns appear in the order they are listed in the `SELECT` query. For `SELECT *`, the result set column order is unchanged. - Updates the information returned by `SQLGetInfo` to report all supported date functions, time functions, and join capabilities. - Removes log level configuration at the DSN and connection level. The log level can now only be set as a driver property. - Changes the BSON (Binary Javascript Object Notation)-to-SQL mapping of `Decimal128` from `SQL_DECIMAL` to `SQL_UNKNOWN` due to incompatibilities between `Decimal128` and `SQL_DECIMAL`. *Released February 23, 2024* - Updates the JDBC (Java Database Connectivity) driver to version 2.1.1, which removes the SnakeYaml dependency and fixes an issue introduced in version 2.1.0 where data retrieved by column name was pointing to the incorrect index. The driver now retrieves the data under the correct index or reports an error if there are duplicate column names. *Released January 22, 2024* - Updates the JDBC (Java Database Connectivity) driver to version 2.1.0, which returns result set columns in the same order as the one provided in the select list instead of the alphabetical order. - Fixes the logger to only apply the logging configuration to the driver handlers and not other applications handlers. *Released October 20, 2023* - Updates the Power BI connector to version 1.1.1, which fixes a bug where JSON values displayed as binary instead of JSON strings. *Released October 17, 2023* - Updates the Power BI connector to version 1.1.0, which adds the ability to pass a native query when you connect. To learn more, see [Connect to Atlas SQL from Power BI.](https://www.mongodb.com/docs/sql-interface/connect.md#std-label-connect-powerbi) - Removes the log-level selector to comply with the Microsoft logging policy for Power BI. *Released August 17, 2023* - Updates the Power BI connector to version 1.0.1, which adds a log-level selector to allow setting the logging level for each connection. *Released June 16, 2023* - Updates the Power BI connector to version 1.0.0. *Released October 24, 2022* - Updates the Tableau custom connector (for the MongoDB JDBC driver) to version 1.2.0. *Released September 19, 2022* - Updates the Tableau custom connector (for the MongoDB JDBC driver) to version 1.1.0. *Released June 7, 2022* - Preview availability.