Home

Awesome

sqlite-vec

An extremely small, "fast enough" vector search SQLite extension that runs anywhere! A successor to sqlite-vss

<!-- deno-fmt-ignore-start -->

[!IMPORTANT] sqlite-vec is a pre-v1, so expect breaking changes!

<!-- deno-fmt-ignore-end --> <p align="center"> <a href="https://hacks.mozilla.org/2024/06/sponsoring-sqlite-vec-to-enable-more-powerful-local-ai-applications/"> <picture> <source media="(prefers-color-scheme: dark)" srcset="./.github/logos/mozilla.dark.svg"> <source media="(prefers-color-scheme: light)" srcset="./.github/logos/mozilla.svg"> <img alt="Mozilla Builders logo" width=400> </picture> </a> </p> <p align="center"> <i> <code>sqlite-vec</code> is a <a href="https://hacks.mozilla.org/2024/06/sponsoring-sqlite-vec-to-enable-more-powerful-local-ai-applications/">Mozilla Builders project</a>, with additional sponsorship from <a href="https://fly.io/"><img width=14px src="./.github/logos/flyio.small.ico"/> Fly.io </a>, <a href="https://tur.so/sqlite-vec"><img width=14px src="./.github/logos/turso.small.ico"/> Turso</a>, and <a href="https://sqlitecloud.io/"><img width=14px src="./.github/logos/sqlitecloud.small.svg"/> SQLite Cloud</a>. See <a href="#sponsors">the Sponsors section</a> for more details. </i> </p>

Installing

See Installing sqlite-vec for more details.

LanguageInstallMore Info
Pythonpip install sqlite-vecsqlite-vec with PythonPyPI
Node.jsnpm install sqlite-vecsqlite-vec with Node.jsnpm
Rubygem install sqlite-vecsqlite-vec with RubyGem
Gogo get -u github.com/asg017/sqlite-vec/bindings/gosqlite-vec with GoGo Reference
Rustcargo add sqlite-vecsqlite-vec with RustCrates.io
Datasettedatasette install datasette-sqlite-vecsqlite-vec with DatasetteDatasette
rqliterqlited -extensions-path=sqlite-vec.tar.gzsqlite-vec with rqliterqlite
sqlite-utilssqlite-utils install sqlite-utils-sqlite-vecsqlite-vec with sqlite-utilssqlite-utils
Github ReleaseGitHub tag (latest SemVer pre-release)

Sample usage

.load ./vec0

create virtual table vec_examples using vec0(
  sample_embedding float[8]
);

-- vectors can be provided as JSON or in a compact binary format
insert into vec_examples(rowid, sample_embedding)
  values
    (1, '[-0.200, 0.250, 0.341, -0.211, 0.645, 0.935, -0.316, -0.924]'),
    (2, '[0.443, -0.501, 0.355, -0.771, 0.707, -0.708, -0.185, 0.362]'),
    (3, '[0.716, -0.927, 0.134, 0.052, -0.669, 0.793, -0.634, -0.162]'),
    (4, '[-0.710, 0.330, 0.656, 0.041, -0.990, 0.726, 0.385, -0.958]');


-- KNN style query
select
  rowid,
  distance
from vec_examples
where sample_embedding match '[0.890, 0.544, 0.825, 0.961, 0.358, 0.0196, 0.521, 0.175]'
order by distance
limit 2;
/*
┌───────┬──────────────────┐
│ rowid │     distance     │
├───────┼──────────────────┤
│ 2     │ 2.38687372207642 │
│ 1     │ 2.38978505134583 │
└───────┴──────────────────┘
*/

Sponsors

Development of sqlite-vec is supported by multiple generous sponsors! Mozilla is the main sponsor through the new Builders project.

<p align="center"> <a href="https://hacks.mozilla.org/2024/06/sponsoring-sqlite-vec-to-enable-more-powerful-local-ai-applications/"> <picture> <source media="(prefers-color-scheme: dark)" srcset="./.github/logos/mozilla.dark.svg"> <source media="(prefers-color-scheme: light)" srcset="./.github/logos/mozilla.svg"> <img alt="Mozilla Builders logo" width=400> </picture> </a> </p>

sqlite-vec is also sponsored by the following companies:

<a href="https://fly.io/"> <picture> <source media="(prefers-color-scheme: dark)" srcset="./.github/logos/flyio.dark.svg"> <source media="(prefers-color-scheme: light)" srcset="./.github/logos/flyio.svg"> <img alt="Fly.io logo" src="./.github/logos/flyio.svg" width="32%"> </picture> </a> <a href="https://tur.so/sqlite-vec"> <picture> <source media="(prefers-color-scheme: dark)" srcset="./.github/logos/turso.svg"> <source media="(prefers-color-scheme: light)" srcset="./.github/logos/turso.svg"> <img alt="Turso logo" src="./.github/logos/turso.svg" width="32%"> </picture> </a> <a href="https://sqlitecloud.io/"> <picture> <source media="(prefers-color-scheme: dark)" srcset="./.github/logos/sqlitecloud.dark.svg"> <source media="(prefers-color-scheme: light)" srcset="./.github/logos/sqlitecloud.svg"> <img alt="SQLite Cloud logo" src="./.github/logos/flyio.svg" width="32%"> </picture> </a>

As well as multiple individual supporters on Github sponsors!

If your company interested in sponsoring sqlite-vec development, send me an email to get more info: https://alexgarcia.xyz

See Also