MIME-Version: 1.0
References: 
 <CAFchsDVMBwPJfSGkVqhwygKTJP-DqarwTyuqyvzVsKgBtKabxA@mail.gmail.com>
In-Reply-To: 
 <CAFchsDVMBwPJfSGkVqhwygKTJP-DqarwTyuqyvzVsKgBtKabxA@mail.gmail.com>
From: Jim Mlodgenski <jimmy76@gmail.com>
Date: Wed, 20 May 2026 09:31:48 -0400
Message-ID: 
 <CAB_5SRcZaQTCG9U5jPTJ6wkGbUe6S3UkhGCR2-a2QzN7Yyv2fg@mail.gmail.com>
Subject: Re: Looking for a native MongoDB document extension for PostgreSQL
 (similar to pgvector like extension)
To: Pratik Pandit <pratikpandit5322@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CAB_5SRcZaQTCG9U5jPTJ6wkGbUe6S3UkhGCR2-a2QzN7Yyv2fg%40mail.gmail.com>
Precedence: bulk

On Wed, May 20, 2026 at 8:26=E2=80=AFAM Pratik Pandit
<pratikpandit5322@gmail.com> wrote:
>
> Hi everyone,
>
> I am looking to handle document-store workloads directly inside PostgreSQ=
L, but using MongoDB-style query patterns or optimized storage structures.
>
> To give an analogy: I  highly appreciate how pgvector brings native vecto=
r data types and specialized indexing (like HNSW) directly into Postgres, k=
eeping everything inside the same database engine.
>
> I know Postgres has incredible jsonb capabilities natively, but I am look=
ing for a PostgreSQL extension that bridges the gap closer to MongoDB. Spec=
ifically, 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 f=
or 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 communit=
y recommends for this? (I have heard brief mentions of things like pg_docum=
entdb / FerretDB, but I'd like to get the community's perspective on what i=
s production-ready extension for it).
>

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