Python Connector for MongoDB
Python Connector for MongoDB boxshot
Version
1.4.0
License
Shareware
Trial Limitations
30-day free trial, evaluation use only, not for production
Operating Systems
Windows 32-bit and 64-bit, Windows Server, macOS 64-bit and ARM (Apple silicon), Linux 64-bit
System Requirements
Python 3.10 to 3.15. Windows 32/64-bit, Windows Server, macOS 64-bit and Apple silicon, Linux 64-bit. MongoDB 3.2 to 7.0. libmongoc 1.3.5 or later
File Size
5.19 MB
Release Date
10/22/2026
Last Updated
11/18/2026
4 views 0 downloads
DB API 2.0 Python connector that queries MongoDB with SQL statements

Devart Python Connector for MongoDB: Run SQL Against MongoDB from Python

Devart Python Connector for MongoDB is a paid Python module, $74.95 a year for one developer, that lets Python 3.10-3.15 code on Windows, macOS and Linux query and update MongoDB 3.2 to 7.0 with SQL statements through the Python DB API 2.0 interface. It treats collections as tables, connects over TCP/IP with optional SSL/TLS, and needs MongoDB's C driver library (libmongoc) on the machine.

Python developers normally use PyMongo, MongoDB's free official driver, and write queries as Python dictionaries. Devart's connector is for people who would rather write SELECT ... WHERE ... ORDER BY: analysts who know SQL, scripts that move MongoDB data into relational databases, and teams that use Devart's connectors for their other databases.

Quick facts

  • Version: 1.4.0, released October 22, 2026
  • Developer: Devart
  • Package: pip install devart-mongodb-connector, or wheel files from Devart's download page (5.19 MB for Windows)
  • Python: 3.10 to 3.15 (1.4 dropped 3.7 to 3.9)
  • Servers: MongoDB 3.2 to 7.0; requires the libmongoc client library 1.3.5 or later
  • Platforms: Windows 32-bit and 64-bit (and Windows Server), macOS Intel and Apple silicon, Linux 64-bit
  • Price: $74.95 a year or $149.95 perpetual for a Single (one developer) license
  • Trial: 30 days, for evaluation only, not for production use
  • Refund: the order page promises a 30-day money-back guarantee "if you are not satisfied", while Devart's ordering FAQ grants refunds within 30 days only when a technical problem support can't fix stops the product working
  • What we checked: the order page charged $74.95 for a Single license with one year of updates on a yearly subscription, and PyPI and Devart's download page both showed version 1.4.0 with Windows, macOS and Linux wheels, on November 18, 2026. We didn't connect it to a MongoDB server

Download Free Trial Buy Now

Overview

You import devart.mongodb and call connect() with Server, Database, Username and Password, plus the paths to the libmongoc and libbson libraries (ClientLibrary and BSONLibrary). Then you use a cursor, execute() with ? parameters, and fetchall().

The connector lets you work with MongoDB data either as documents or as relational tables, and maps MongoDB types, including Decimal128, to Python types with options to change the mapping. Version 1.4 fixed several Decimal128 issues, and 1.1 added MongoDB 6 and 7 support and connection pooling.

Features

SQL over MongoDB collections

Python Connector for MongoDB lets you run SELECT, INSERT, UPDATE and DELETE statements against MongoDB collections as if they were relational tables, so filtering, sorting and grouping are written in SQL instead of MongoDB's query documents.

Encrypted connections

Python Connector for MongoDB supports SSL/TLS between Python and the MongoDB server; you can specify a certificate to secure the connection.

Batched updates and pooling

Python Connector for MongoDB submits several update statements to the server as one batch, and pools connections since version 1.1.

Bug fixes that matter for real data

Python Connector for MongoDB 1.2 fixed errors when a document has a field named like its collection, 64-bit constants in SQL, inserting documents with duplicate _id values and an access violation in connect(); 1.4 fixed Decimal128 handling.

Benefits

  • SQL skills carry over. Analysts query MongoDB without learning its query syntax.
  • Easier relational exports. Rows come back ready to load into SQL databases or CSV.
  • Cross-platform. The same script runs on Windows, macOS and Linux.

Real-World Uses

  • Copying to a warehouse. A nightly script selects new orders from MongoDB and inserts them into PostgreSQL or SQL Server.
  • Ad-hoc analysis. An analyst answers a question about user documents with one SQL query in a notebook.
  • Bulk corrections. A script runs batched UPDATE statements to fix a field across many documents.

Who It's For, and Who Should Skip It

The connector suits SQL-minded developers and analysts who need to read or change MongoDB data from Python, and teams moving MongoDB data into relational systems.

Skip it if you're comfortable with PyMongo, which is free, maintained by MongoDB and supports every server feature including aggregation pipelines and change streams. Skip it too if you run MongoDB 8: Devart lists support up to 7.0.

Usage Guide

  1. Install MongoDB's C driver (libmongoc and libbson) on the machine.
  2. Install the connector with pip install devart-mongodb-connector.
  3. After buying, run devart.mongodb.license.activate("<key>") with the key from the order email or customer portal.
  4. Connect: conn = mongodb.connect(Server="...", Database="shop", Username="...", Password="...", ClientLibrary="path/to/libmongoc", BSONLibrary="path/to/libbson").
  5. Query: cur.execute("SELECT name, total FROM orders WHERE status = ?", ["paid"]) and cur.fetchall().

Before you buy

Unlike Devart's direct-mode connectors, this one needs MongoDB's libmongoc and libbson libraries installed and their paths set in the connection, which adds a deployment step on every machine. Check your server version too: Devart lists MongoDB 3.2 to 7.0.

Where it falls short

  • No MongoDB 8 listed. Compatibility stops at MongoDB 7.0.
  • Extra native libraries. libmongoc 1.3.5 or later must be installed separately.
  • SQL hides MongoDB features. Aggregation pipelines, change streams and other native features are PyMongo territory.
  • No asyncio API. It's a synchronous DB API 2.0 driver.

Comparisons

Devart vs. PyMongo

PyMongo is MongoDB's free, official Python driver, with full support for every server feature and new versions as they ship. Devart Python Connector for MongoDB costs $74.95 a year and adds an SQL interface through DB API 2.0, batching and vendor support. Choose Devart only if SQL access is what you need.

Python connector vs. Devart's ODBC driver for MongoDB

Devart's ODBC driver for MongoDB also serves Excel, Power BI and other ODBC tools, as well as Python through pyodbc. If Python is the only consumer, the Python connector is cheaper; if reports need MongoDB too, the ODBC driver covers both.

Editions and Pricing

License1-year subscriptionPerpetualWho can use it
Single$74.95$149.95One developer at one company site
Team$189.95On the order pageUp to 4 developers at one company site
Site$339.95On the order pageUnlimited developers at one company site

Buy Now opens the order for Python Connector for MongoDB with a Single license on a 1-year subscription; Team, Site, the perpetual license and 2- or 3-year terms are chosen on the order page. An OEM license for shipping the connector inside your own product is arranged with Devart separately.

FAQs

Does Python Connector for MongoDB support MongoDB 8?

Not officially. Devart lists MongoDB 3.2 to 7.0 as supported for Python Connector for MongoDB; test a newer server in the 30-day trial before buying.

Do I need to install anything besides Python Connector for MongoDB?

Yes. Python Connector for MongoDB uses MongoDB's libmongoc client library (1.3.5 or later) and libbson, whose paths you pass when connecting.

Can it write to MongoDB?

Yes. Python Connector for MongoDB supports INSERT, UPDATE and DELETE statements and can send several updates as one batch.

Does it run on Apple silicon Macs?

Yes. Python Connector for MongoDB ships macOS wheels for Intel and Apple silicon, plus Windows and 64-bit Linux wheels.

Which Python versions does Python Connector for MongoDB support?

Python Connector for MongoDB 1.4 supports Python 3.10 to 3.15.

Can I get a refund on Python Connector for MongoDB?

Possibly. Python Connector for MongoDB's order page offers a 30-day money-back guarantee if you're not satisfied, but Devart's ordering FAQ describes refunds within 30 days only for technical problems its support can't fix. Use the 30-day trial to be sure before you buy.

System Requirements

  • Python 3.10 to 3.15 with pip
  • Windows 32-bit or 64-bit, Windows Server, macOS (Intel or Apple silicon) or 64-bit Linux
  • MongoDB 3.2 to 7.0, and libmongoc 1.3.5 or later with libbson
  • Internet access for activating and checking a subscription license

Conclusion

Devart Python Connector for MongoDB is worth $74.95 a year to SQL-minded teams who need to query or move MongoDB data from Python without learning MongoDB's query language. Everyone else should use PyMongo, which is free and supports more of MongoDB, and anyone on MongoDB 8 should test carefully first since Devart lists support up to 7.0. The 30-day trial is the place to check both.

Download Free Trial Buy Now

Submit Your Review
Your Name:
Rating:
(Please click on one of the stars to indicate your rating.)
One Line Summary:
Review:
No html tags are allowed.
Submit Review
We may earn a commission when you buy through links on this page.
Copyright © 2026, Ivertech. All rights reserved.