mongo_fdw
A PostgreSQL foreign data wrapper that enables querying and manipulating MongoDB data directly from PostgreSQL.
What is mongo_fdw?
MongoDB Foreign Data Wrapper (mongo_fdw) is a PostgreSQL extension that allows PostgreSQL to query and manipulate MongoDB data as if it were native PostgreSQL tables. It solves the problem of integrating document-based NoSQL data with relational SQL queries, enabling seamless cross-database operations without data migration.
Database administrators and developers working in environments that use both PostgreSQL and MongoDB, who need to perform unified queries or data integration between the two systems.
Developers choose mongo_fdw for its performance optimizations like query push-down and connection pooling, its write capabilities, and its ability to leverage PostgreSQL's powerful SQL features on MongoDB data without custom ETL pipelines.
Overview
PostgreSQL foreign data wrapper for MongoDB
Use Cases
Best For
- Querying MongoDB data with complex SQL joins from PostgreSQL
- Performing aggregate analytics on MongoDB collections using PostgreSQL
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
