pgvector is an open-source PostgreSQL extension that introduces a vector data type and similarity indexes, letting developers store and run nearest-neighbor searches on embeddings directly inside Postgres. It provides HNSW and IVFFlat indexes so AI and recommendation workloads can use a single relational database instead of a separate vector store.