Langchain PostgreSQL vector stores

It would help if there was a node for:

It would be great to see a PostgreSQL vector store to add to the new LangChain vector store nodes.

My use case:

I don’t want to store the embedded data on a third party server.

Any resources to support this?

Flowise.ai’s implementation could be ported over: https://github.com/FlowiseAI/Flowise/blob/main/packages/components/nodes/vectorstores/Postgres_Existing/Postgres_Exisiting.ts

Are you willing to work on this?

If anyone could point me to the code for any of the existing langchain vectorstore nodes I maybe able to build my own via the Custom - LLM Chain Node :thinking:

Hmm I’m looking into this as well. Did you found anything on this topic?

This is sort of a surprising limitation of n8n currently – @jan, can you provide any hints as to if/when n8n will support standard vector DBs in plain PostgreSQL? That tech is extremely popular and I’m puzzled why Supabase is supported before stock PostgreSQL support, to be honest. Thanks!