AddRAG

Add RAG to the database you already run.

databases · Extension · checked 2026-11-21

VillageSQL Vector

Open-source, self-hosted vector search for VillageSQL, a MySQL-compatible server fork. The vsql-vector-pk extension adds an SVECTOR float32 type (up to 3072 dimensions) and an HNSW index (L2, L1, cosine, and inner product), queried with ORDER BY distance LIMIT k. Experimental / preview: the README says it is not recommended for production use.

Self-hostable
yes
License
GPLv2
Hybrid search
unverified
Metadata filtering
unverified
Works with
VillageSQL
Managed pricing
No managed pricing page. VillageSQL Server and the vsql-vector-pk extension are licensed under GPLv2.
Free tier
The homepage says VillageSQL Server is free for any use, including commercial use. The extension is built from source and run on a server you operate.
Limits
README: SVECTOR is float32 with a declared dimension up to 3072. HNSW metrics are L2 (default), L1, cosine, and inner product. Default vsql_vector.ef_search is 40 (range 1 to 65536).
Caveats
Experimental / preview. The README says the extension is under active development, is not stable, is not recommended for production use, depends on VillageSQL preview APIs that can change without notice, and must be built from source with vsql_allow_preview_extensions=ON. Once an HNSW index exists, DELETE of a row is not supported, and UPDATE cannot change the indexed vector or the primary key.

Sources