sqlite-vec

A vector database in a single C file, sqlite-vec is an SQLite extension by Alex Garcia that stores and queries float, int8, and binary vectors in vec0 virtual tables using plain SQL. It has zero dependencies, so it runs anywhere SQLite runs: Linux, macOS, Windows, Raspberry Pi class devices, and browsers through WASM. Bindings exist for Python, JavaScript, Ruby, Go, and Rust, alongside Datasette, sqlite-utils, and rqlite integrations, and installation is as simple as pip install sqlite-vec or the npm, gem, and cargo equivalents. Queries currently run exhaustive scans rather than approximate indexes, fast enough for the small-to-medium collections the tool targets, with int8 and binary vector types available to shrink storage; the project is pre-v1, so breaking changes are possible. Development is backed by the Mozilla Builders program with sponsorship from Fly.io, Turso, and SQLite Cloud, and both Turso and SQLite Cloud ship it in their products as the successor to sqlite-vss. Dual licensed MIT or Apache-2.0, it has around 7,900 GitHub stars.