pgvector

Health v2 · maintenance only

Flags: no_releases no_license

Adoption not part of the score

22760 stars · 1297 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

pgvector is an open-source PostgreSQL extension that adds vector data types and vector similarity search, supporting exact and approximate nearest neighbor search with multiple distance metrics. It lets you store embeddings alongside relational data while retaining full Postgres features like ACID compliance and JOINs.

Use cases

• add vector similarity search to postgres
• store embeddings with relational data
• build a rag application without a separate vector database
• find nearest neighbors by cosine distance in sql
• semantic search over documents in postgres
• recommendation system with embedding similarity

When to choose

• you already use Postgres and want vector search without running a separate database
• you need ACID transactions, JOINs, and backups for your vector data
• you want a mature, widely supported extension with clients in many languages

When to avoid

• you need massive-scale vector search beyond what a single Postgres instance can handle
• you require advanced vector database features like multi-tenancy filtering at extreme scale or built-in hybrid search
• you don't use Postgres and have no reason to adopt it

Facets

library · maturity active

vector-database search-engine database databases machine-learning windows self-hosted cloud postgres-extension vector-similarity-search embeddings nearest-neighbor-search hnsw ivfflat sql search retrieval-augmented-generation linux macos docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="pgvector/pgvector")