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.