DuckDB's VSS Extension Brings HNSW Vector Search Without a Separate Database

DuckDB's official VSS extension enables approximate nearest neighbor search directly within the analytics engine, eliminating the need for dedicated vector databases like Pinecone or Qdrant. The extension implements the HNSW algorithm — the same graph-based approach used by most production vector search systems — operating on DuckDB's fixed-size ARRAY columns. Users can install it with two SQL commands, create an HNSW index on an embedding column, and run standard ORDER BY queries that DuckDB automatically routes through the index. The extension supports multiple distance metrics including Euclidean, cosine, and inner product, making it suitable for RAG pipelines and semantic search using models from OpenAI or Sentence-Transformers. Because the vector index lives in the same process as the SQL engine, no separate service or network infrastructure is required.