Duaer

Integrations

Use Postgres PGVector Store in Duaer

In Duaer, Postgres PGVector Store is an AI root node. It takes Embedding, Document, and Reranker sub-nodes. Its modes are Get Many, Insert Documents, Retrieve Documents (As Vector Store for Chain/Tool), and Retrieve Documents (As Tool for AI Agent).

Add Postgres PGVector Store to a Duaer workflow

  1. On the Duaer canvas, open the node panel, search for Postgres PGVector Store, and connect it after the previous node.
  2. Connect the sub-nodes it needs to the inputs under Postgres PGVector Store (Embedding, Document, and Reranker), starting with an Embedding.
  3. In Credential to connect with, pick or create a Postgres credential.
  4. Pick an Operation Mode: Get Many, Insert Documents, Retrieve Documents (As Vector Store for Chain/Tool), or Retrieve Documents (As Tool for AI Agent).
  5. Check Table Name on the node.
  6. If needed, select Add Option for the optional settings listed below.
  7. Select Execute step and check the output.

Postgres PGVector Store modes in Duaer

  • Get Many: Get many ranked documents from vector store for query.
  • Insert Documents: Insert documents into vector store.
  • Retrieve Documents (As Vector Store for Chain/Tool): Retrieve documents from vector store to be used as vector store with AI nodes.
  • Retrieve Documents (As Tool for AI Agent): Retrieve documents from vector store to be used as tool with AI nodes.

Postgres PGVector Store options in Duaer

Under Add Option, Postgres PGVector Store offers Collection, Column Names, and Skip Table Initialization.

Sub-nodes Postgres PGVector Store takes in Duaer

Connect sub-nodes to the inputs under Postgres PGVector Store: Embedding, Document, and Reranker. Each sub-node keeps its own credential and settings.

Questions

What do you set on Postgres PGVector Store in Duaer?

In Duaer, Postgres PGVector Store mainly takes Table Name.

Which credential does Postgres PGVector Store use in Duaer?

Duaer's Postgres PGVector Store uses a Postgres credential. The secret stays in the credential, not in node parameters.

In this section