Capabilities ​
- Dense vectors stored beside JSONB document and metadata values.
- SQL upsert on deterministic physical IDs.
- Cosine, L2, and inner-product distance operators.
- Connection through a
pgclient, pool, or connection string. - Parameterized equality and numeric comparison filters.
search,searchIds, andasTool()integration.- Runtime validation of the vector column dimension.
The adapter can create the extension and base table, but it does not create HNSW or IVFFlat indexes. It also does not manage pool shutdown, database migrations, backups, RLS, or retries.
Metadata keys beginning with __anvia_ are reserved. See the API reference.