--- title: Vector Similarity Search in DuckDB | daily.dev description: The blog post introduces the vss extension in DuckDB, which adds support for vector similarity search using HNSW indexes. It explains the motivation behind... canonical: https://daily.dev/posts/vector-similarity-search-in-duckdb-0pmks4ib3 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Vector Similarity Search in DuckDB | daily.dev og:description: The blog post introduces the vss extension in DuckDB, which adds support for vector similarity search using HNSW indexes. It explains the motivation behind... og:url: https://daily.dev/posts/vector-similarity-search-in-duckdb-0pmks4ib3 og:image: https://api.daily.dev/og/posts/0pMkS4iB3.png og:image:alt: Vector Similarity Search in DuckDB og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Vector Similarity Search in DuckDB **[Community Picks](https://daily.dev/sources/community)** · 6 min read · 3 upvotes · 0 comments ## Summary The blog post introduces the vss extension in DuckDB, which adds support for vector similarity search using HNSW indexes. It explains the motivation behind adding the ARRAY data type and the new distance metric functions, as well as the implementation and limitations of the vss extension. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: --- Tags: [#duckdb](https://daily.dev/tags/duckdb) [View this post on daily.dev](https://daily.dev/posts/vector-similarity-search-in-duckdb-0pmks4ib3) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Vector Similarity Search in DuckDB","url":"https://daily.dev/posts/vector-similarity-search-in-duckdb-0pmks4ib3","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/vector-similarity-search-in-duckdb-0pmks4ib3"},"datePublished":"2024-05-04T04:54:36.298Z","dateModified":"2024-05-09T08:43:33.910Z","description":"The blog post introduces the vss extension in DuckDB, which adds support for vector similarity search using HNSW indexes. It explains the motivation behind...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/d2c1f394c53d580338600175da3e5baa?_a=AQAEuiZ","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/d2c1f394c53d580338600175da3e5baa?_a=AQAEuiZ","isAccessibleForFree":true,"articleSection":"Community Picks","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Community Picks","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1655817725/logos/community","url":"https://daily.dev/sources/community"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/vector-similarity-search-in-duckdb-0pmks4ib3","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":3},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"duckdb","timeRequired":"PT6M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Community Picks","item":"https://daily.dev/sources/community"},{"@type":"ListItem","position":3,"name":"Vector Similarity Search in DuckDB"}]} ```