PGVector Vector Store icon

PGVector Vector Store

Advanced PGVector operations with full CRUD control

Actions5

Get

AI-generated

Summary

Retrieve embeddings by ID or external ID from a specified PGVector collection.

Inputs

  • collection (required) — Collection name to organize embeddings (partition value)
  • getBy — Selector for the ID type to fetch: ID or External ID
  • getIds — Comma-separated list of UUIDs to fetch. Displayed when Get By is ID.
  • getExternalIds — Comma-separated list of external IDs to fetch. Displayed when Get By is External ID.

Output shape

Each matching embedding row as a JSON object, returned as an n8n item json field. Includes configured columns (ID, content, metadata, etc.) based on schema mode.

Source code passes collection, getBy, and either getIds or getExternalIds to the vector store get operation; rows from the database query are emitted as json outputs.

Examples

Example 1: Fetch a single embedding by UUID

collection: 'myCollection', getBy: 'id', getIds: '123e4567-e89b-12d3-a456-426614174000'

Example 2: Fetch multiple embeddings by external IDs

collection: 'myCollection', getBy: 'externalId', getExternalIds: 'ext-1,ext-2'

Discussion