Downloads 175this week

GitHub stars 20

Extension repository on GitHub

Extension descriptor (YAML)

Integrates DuckDB with MongoDB, enabling direct SQL queries over MongoDB collections without exporting data or ETL

Installing and Loading

INSTALL mongo FROM community;
LOAD mongo;

Example

-- Attach to MongoDB
ATTACH 'host=localhost port=27017' AS mongo_db (TYPE MONGO);

-- Query your collections
SELECT * FROM mongo_db.mydb.mycollection LIMIT 10;

About mongo

The duckdb-mongo extension provides direct SQL access to MongoDB collections without requiring data export or ETL processes. It supports both standalone MongoDB instances and MongoDB Atlas clusters, with automatic schema inference and filter pushdown for efficient querying. The extension enables you to run analytical SQL queries directly against MongoDB data, including joins, aggregations, and complex analytical operations.

Added Functions