npm

pgvector

Open-source vector similarity search extension for PostgreSQL

brewmacoslinux

Try with needOr install directly

Source

About

Open-source vector similarity search for Postgres

Commands

pgvector

Examples

Install pgvector extension in PostgreSQL database$ psql -d your_database -c 'CREATE EXTENSION vector;'

Create a table with vector column for embeddings$ psql -d your_database -c 'CREATE TABLE embeddings (id serial, embedding vector(1536));'

Query similar vectors using cosine distance$ psql -d your_database -c 'SELECT id FROM embeddings ORDER BY embedding <=> ARRAY[0.1,0.2,0.3] LIMIT 10;'