Re: Looking for a native MongoDB document extension for PostgreSQL (similar to pgvector like extension)

On Wed, May 20, 2026 at 8:26 AM Pratik Pandit
<pratikpandit5322(at)gmail(dot)com> wrote:
>
> Hi everyone,
>
> I am looking to handle document-store workloads directly inside PostgreSQL, but using MongoDB-style query patterns or optimized storage structures.
>
> To give an analogy: I highly appreciate how pgvector brings native vector data types and specialized indexing (like HNSW) directly into Postgres, keeping everything inside the same database engine.
>
> I know Postgres has incredible jsonb capabilities natively, but I am looking for a PostgreSQL extension that bridges the gap closer to MongoDB. Specifically, I'm hoping to find something that provides:
> 1. A Native BSON Data Type: Storing binary JSON natively inside Postgres for faster processing.
> 2. MongoDB API/Query Compatibility: The ability to run Mongo-like queries directly on top of Postgres tables.
>
> I am already aware of Foreign Data Wrappers like mongo_fdw, but that is for querying a separate, external MongoDB instance. I want to keep the data natively resident inside Postgres.
>
> Are there any active open-source extensions or projects that the community recommends for this? (I have heard brief mentions of things like pg_documentdb / FerretDB, but I'd like to get the community's perspective on what is production-ready extension for it).
>

This is a high quality project
https://github.com/documentdb/documentdb