MIME-Version: 1.0
From: Pratik Pandit <pratikpandit5322@gmail.com>
Date: Wed, 20 May 2026 17:56:08 +0530
Message-ID: 
 <CAFchsDVMBwPJfSGkVqhwygKTJP-DqarwTyuqyvzVsKgBtKabxA@mail.gmail.com>
Subject: Looking for a native MongoDB document extension for PostgreSQL
 (similar to pgvector like extension)
To: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002dc4ba06523ee79f"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFchsDVMBwPJfSGkVqhwygKTJP-DqarwTyuqyvzVsKgBtKabxA%40mail.gmail.com>
Precedence: bulk

--0000000000002dc4ba06523ee79f
Content-Type: text/plain; charset="UTF-8"

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).

Best regards,

Pratik Pandit

--0000000000002dc4ba06523ee79f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><p>Hi everyone,</p><p>I am looking to handle document-stor=
e workloads directly inside PostgreSQL, but using MongoDB-style query patte=
rns or optimized storage structures.</p><p>To give an analogy: I=C2=A0=C2=
=A0highly appreciate how <code>pgvector</code> brings native vector data ty=
pes and specialized indexing (like HNSW) directly into Postgres, keeping ev=
erything inside the same database engine.</p><div>I know Postgres has incre=
dible <code>jsonb</code> capabilities natively, but I am looking for a Post=
greSQL extension that bridges the gap closer to MongoDB. Specifically, I=
9;m hoping to find something that provides:=C2=A0</div><div>1.=C2=A0A Nativ=
e BSON Data Type:<span class=3D"gmail-citation-12 gmail-citation-end-12"> S=
toring binary JSON natively inside Postgres for faster processing.<span></s=
pan></span><span><br></span></div><div><span>2.=C2=A0</span>MongoDB API/Que=
ry Compatibility: The ability to run Mongo-like queries directly on top of =
Postgres tables.<p>I am already aware of Foreign Data Wrappers like <code>m=
ongo_fdw</code>, but that is for querying a separate, external MongoDB inst=
ance. I want to keep the data <i>natively resident</i> inside Postgres.</p>=
<p>Are there any active open-source extensions or projects that the communi=
ty recommends for this? (I have heard brief mentions of things like <code>p=
g_documentdb</code> / FerretDB, but I&#39;d like to get the community&#39;s=
 perspective on what is production-ready extension for it).<br><br>Best reg=
ards,</p><p>Pratik Pandit</p><br></div></div>

--0000000000002dc4ba06523ee79f--