For this quick verification of the 0.0.7 development branch of VillageSQL with the new vsql-vector plugin.
- Recreate the VillageSQL Percona Live presentation using MySQL version 8.4 and SVECTOR.
- Demonstrate a more detailed example using SVECTOR(1024) string embedded data.
I will be using an existing MySQL RAG demo created by Hank Tom . This was presented at COSCUP 2026 in Taiwan, which I’ve translated into English. See fork at https://github.com/ronaldbradford/coscup-mysql/tree/english
Recreating the VillageSQL Demo
- Get the VillageSQL nightly build for MySQL 8.4
- Build and install the vsql-vector plugin
- Apply some temporaray secret sauce (See Discord)
- Run the SQL that was presented
The Percona Live Demo
SELECT VERSION();
INSTALL EXTENSION vsql_vector;
SET PERSIST vsql_allow_preview_extensions = ON;
CREATE DATABASE IF NOT EXISTS vector_demo;
USE vector_demo;
CREATE TABLE demo_vectors (
id INT PRIMARY KEY,
embedding SVECTOR(3) NOT NULL,
INDEX idx_embedding (embedding hnsw_l2) USING EXTENDED(hnsw)
) ENGINE=InnoDB;
INSERT INTO demo_vectors (id, embedding) VALUES
(1, '[1.0,2.0,3.0]'),
(2, '[1.5,2.25,3.25]'),
(3, '[2.5,3.5,4.5]'),
(4, '[6.0,6.0,6.0]'),
(5, '[9.0,9.0,9.0]');
EXPLAIN FORMAT=TREE SELECT id FROM demo_vectors;
SELECT id, l2_distance(embedding, '[1.0,2.0,3.0]') AS distance
FROM demo_vectors
ORDER BY distance
LIMIT 3;
The Output
villagesql> SELECT VERSION();
+--------------------------------------------+
| version() |
+--------------------------------------------+
| 8.4.11-villagesql-0.0.7-dev-f595f2e2-debug |
+--------------------------------------------+
1 row in set (0.01 sec)
villagesql> EXPLAIN FORMAT=TREE SELECT id FROM demo_vectors
-> ORDER BY l2_distance(embedding, '[1.0,2.0,3.0]') LIMIT 3\G
*************************** 1. row ***************************
EXPLAIN: -> Limit: 3 row(s)
-> Sort: vsql_vector.l2_distance(demo_vectors.embedding,'[1,2,3]'), limit input to 3 row(s) per chunk
-> Stream results (cost=0.75 rows=5)
-> Covering index scan on demo_vectors using idx_embedding (cost=0.75 rows=5)
villagesql> SELECT id, l2_distance(embedding, '[1.0,2.0,3.0]') AS distance
> FROM demo_vectors
> ORDER BY distance
> LIMIT 3;
+----+--------------------+
| id | distance |
+----+--------------------+
| 1 | 0 |
| 2 | 0.6123724356957945 |
| 3 | 2.598076211353316 |
+----+--------------------+
What I can’t do in the mysql client which is more useful when the SVECTOR is 1024 dimensions.
villagesql> SET @search='[1.0,2.0,3.0]';
Query OK, 0 rows affected (0.00 sec)
villagesql> SELECT id, l2_distance(embedding, @search) AS distance
-> FROM demo_vectors
-> ORDER BY distance
-> LIMIT 3;
ERROR 3219 (HY000): Cannot initialize function 'l2_distance': argument 2 must be a custom type or string constant
RAG Demo
villagesql> CREATE DATABASE IF NOT EXISTS ragdemo CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
villagesql> USE ragdemo;
villagesql> CREATE TABLE IF NOT EXISTS faq_chunks (
-> id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
-> doc_id VARCHAR(64) NOT NULL, -- dataset id
-> category VARCHAR(32) NOT NULL, -- metadata: key for pre-retrieval coarse filter
-> title VARCHAR(255) NOT NULL,
-> content TEXT NOT NULL,
-> embedding SVECTOR(1024) NOT NULL,
-> created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
-> UNIQUE KEY uk_doc (doc_id),
-> KEY idx_category (id, category),
-> INDEX idx_embedding (embedding hnsw_l2) USING EXTENDED(hnsw)
-> ) ENGINE=InnoDB;
villagesql> SOURCE faq_chunks_inserts.sql
villagesql> SELECT id, doc_id, title, l2_distance(embedding,
-> '[-0.030124,-0.013043,-0.029980,-0.015625,-0.012565,-0.078460,0.035866,-0.025951,0.014485,-0.039942,0.041012,0.029253,-0.036193,0.017996,-0.003778,0.006932,-0.028776,-0.025422,-0.027 370,-0.023972,-0.056747,0.015684,0.014034,0.013369,0.033345,0.001581,-0.000823,-0.003675,0.026140,-0.012362,-0.015603,-0.022070,0.022050,-0.025312,0.006035,-0.045207,0.021296,-0.023336,-0.0 42326,0.017826,0.001806,-0.027581,-0.013038,-0.038394,0.002463,-0.020117,0.012178,-0.003197,-0.024562,-0.022259,-0.003078,0.012974,0.026011,-0.024536,0.009429,0.087321,-0.014193,-0.016808,- 0.020794,-0.002331,-0.006826,-0.005870,-0.012241,-0.016217,0.012901,0.082016,0.047139,-0.009300,0.001219,-0.016146,-0.012782,0.031874,-0.012829,-0.010538,-0.051230,0.018069,0.038741,0.00028 9,-0.038317,-0.014843,0.014826,0.007631,0.039204,0.017402,0.022695,0.044460,-0.003152,0.007366,-0.014734,0.033637,-0.008958,0.047514,0.024603,-0.007679,-0.044544,-0.008358,0.022219,-0.02567 1,0.016019,-0.031623,-0.003126,0.021648,0.025280,-0.011972,0.001402,0.006715,0.042632,0.029761,0.013583,-0.005261,-0.011052,0.000270,0.027472,-0.002823,0.020113,-0.027185,-0.016953,-0.03241 7,0.004950,-0.040131,0.004563,0.027586,0.010753,-0.036511,-0.039702,-0.004506,0.021339,0.019937,0.020125,0.004244,0.038880,0.015975,-0.007973,-0.023773,-0.035178,-0.005015,0.020670,0.037187 ,0.025379,-0.034487,0.028230,0.029077,-0.026740,-0.018222,-0.003674,-0.012692,0.038291,0.004853,0.015111,-0.006567,0.020857,0.005920,0.003225,-0.022298,-0.013240,-0.081837,0.021410,0.020262 ,-0.027282,0.031303,0.017914,0.051988,-0.082524,-0.049499,-0.013673,-0.010900,0.036365,0.014193,0.017001,0.001510,0.034483,-0.030804,0.028348,-0.021130,0.004474,0.013153,0.093977,0.008767,- 0.020692,-0.016523,-0.048034,0.030709,-0.023555,-0.074303,-0.022384,0.024188,-0.046208,-0.021532,-0.000642,0.001816,-0.001615,-0.008174,-0.018676,0.018900,0.028003,-0.029017,-0.013648,0.022 304,-0.002958,0.007394,-0.030928,0.023329,0.053425,0.010434,-0.021782,-0.010213,0.022501,-0.049263,0.019472,-0.036261,-0.034762,0.001056,-0.005366,-0.000128,-0.035656,-0.026829,0.032179,0.0 07894,-0.028114,-0.008680,-0.002534,0.037769,0.000094,-0.025278,-0.005744,0.041756,-0.017343,0.033807,0.005006,-0.059767,-0.012484,0.048368,-0.002895,-0.019351,0.011538,0.018991,-0.039860,0 .038348,0.011442,0.027307,-0.022387,-0.014958,-0.022035,-0.007219,-0.043636,0.013076,0.018523,0.022367,-0.004776,-0.016569,0.011796,-0.001680,-0.001394,-0.005663,0.008157,0.009071,0.008656, -0.013659,0.023562,-0.009410,0.051914,-0.001904,-0.024860,0.031914,0.027009,0.022257,0.027263,0.007604,0.022855,-0.006749,-0.011934,-0.039146,0.028088,0.004310,0.047726,0.037721,-0.024480,- 0.015444,0.055377,-0.026846,0.001771,0.048616,0.028522,-0.004397,0.025519,-0.005370,-0.016621,0.023074,0.018078,-0.067859,-0.049872,0.024053,0.076568,0.024527,-0.013576,-0.013123,-0.011488, -0.171776,-0.003531,-0.002667,0.025670,0.009796,0.002896,-0.066713,0.005463,-0.035566,-0.015395,-0.006626,-0.056170,-0.016880,0.035815,-0.008969,-0.019312,-0.053350,0.012903,-0.005816,-0.03 1455,-0.032192,-0.036329,0.095231,-0.040766,-0.062895,-0.026020,0.015199,-0.043778,-0.053974,0.021135,0.023553,-0.002576,0.015464,-0.002657,-0.009079,-0.021768,-0.009559,-0.040165,-0.020377 ,-0.030245,0.039976,0.001484,0.013977,0.016469,0.044784,-0.028021,-0.020747,0.015794,0.012524,0.022208,-0.053842,-0.009341,-0.011719,0.002276,-0.045670,0.003344,-0.015453,0.054123,0.002606, 0.028400,-0.031217,-0.014219,0.009921,-0.013475,-0.034071,0.018548,0.034211,-0.041292,0.026350,-0.018746,0.020287,0.029218,0.021284,-0.034857,-0.056553,0.056864,-0.053866,-0.042523,-0.01859 7,-0.172669,-0.056192,0.009714,-0.029151,0.006877,-0.042434,0.002352,0.036044,0.050582,0.069501,0.240781,0.015626,-0.005688,0.021294,0.057998,-0.065052,0.043035,0.017744,0.011320,-0.015679, 0.040512,0.037774,0.012935,-0.001761,-0.015829,0.000619,-0.036566,-0.008641,0.054333,0.014276,0.009784,0.005884,-0.009912,-0.027433,-0.078686,-0.023055,-0.020498,0.036779,-0.030244,0.044093 ,-0.018440,0.015534,0.035458,-0.024506,-0.008786,0.028078,0.016577,0.003137,-0.037105,0.030943,-0.008224,-0.036639,0.067004,0.014001,0.000861,-0.058503,-0.032226,-0.016531,-0.014037,-0.0073 65,0.022300,-0.012346,-0.006537,-0.042061,0.025998,-0.031082,-0.011701,-0.033823,-0.030223,0.085990,0.045855,-0.006534,-0.007006,0.046155,-0.001303,0.013672,0.019128,0.011425,-0.080330,0.01 4785,-0.023362,-0.021902,0.035289,-0.010442,0.032497,-0.001853,0.015702,0.052592,-0.013668,0.020307,0.006331,0.026054,-0.004366,0.041102,0.032849,-0.017707,0.006288,-0.001229,0.030536,-0.00 7538,-0.030840,-0.008077,-0.024313,0.023216,0.052864,-0.027182,0.037931,0.014476,-0.037155,-0.007414,-0.050807,0.009337,0.016105,-0.042980,0.041088,-0.032215,-0.023127,-0.000389,0.009244,-0 .006214,0.024643,0.049504,0.000980,-0.040646,0.013999,0.049980,0.016760,0.015380,0.030568,-0.006660,-0.007223,-0.016279,0.038957,0.031393,-0.029497,-0.023640,0.026171,-0.024074,-0.018933,0. 009042,-0.007734,-0.012780,0.002710,0.000426,0.036991,0.007599,-0.002248,0.014043,0.028874,0.044014,0.011450,0.006709,-0.007634,-0.002146,-0.007587,-0.009397,-0.016755,0.019435,0.009638,0.0 45362,0.013475,0.064931,-0.010472,-0.025727,-0.034406,-0.022813,0.029438,-0.014677,0.013134,-0.021538,0.000918,0.032561,-0.005764,0.099729,0.009421,0.006478,-0.031263,0.034160,0.019232,-0.0 32792,0.015316,-0.024781,-0.043407,-0.014023,-0.003208,0.017717,-0.026522,0.008074,-0.029490,-0.019937,0.012873,-0.006669,-0.048501,-0.018441,0.018014,-0.001081,-0.040530,0.006217,0.048803, -0.015718,-0.032687,0.082730,-0.004724,-0.001773,0.033535,0.045688,0.049102,0.056086,0.006418,-0.021439,-0.015927,0.023844,-0.027400,-0.027912,0.010115,0.007192,-0.001661,0.031753,0.000563, -0.004013,-0.038074,-0.011206,-0.006273,0.006745,0.005885,-0.003834,0.064881,0.010318,-0.033207,-0.014440,-0.006686,0.014139,0.032892,-0.018603,-0.018210,-0.027184,0.012968,0.011907,-0.0535 70,-0.018164,0.000591,0.016673,-0.009289,-0.020892,0.044302,-0.025202,0.001932,0.026289,-0.001671,0.016015,0.028480,0.009948,0.045890,0.026884,0.009083,0.037513,-0.009865,-0.029938,0.037471 ,0.015272,-0.014534,-0.035666,0.009052,-0.014774,-0.024715,0.007357,-0.034729,0.013790,-0.050395,-0.015345,-0.015713,-0.004615,0.018674,-0.050257,-0.019999,-0.030773,0.008517,0.016290,-0.03 5392,0.006713,0.019104,0.006479,-0.050094,-0.022478,-0.001032,-0.013791,-0.012590,0.051864,0.011577,0.010713,-0.009982,-0.029531,-0.004478,0.010800,-0.043378,0.037595,0.027924,0.039972,0.00 3356,0.001610,0.017795,0.017059,-0.046711,0.030811,-0.044061,0.003054,0.011639,0.026619,-0.034201,0.017481,0.001055,0.008400,-0.026152,-0.003718,0.007775,-0.017625,-0.020419,-0.027945,0.058 362,0.024966,-0.018904,-0.069486,-0.011790,-0.025433,0.007084,-0.023759,0.054352,0.010979,-0.068198,0.003162,0.007486,-0.011664,-0.007822,0.004652,-0.054413,-0.000019,0.001216,-0.025311,-0. 023330,0.053731,-0.020786,-0.027642,0.001183,-0.020318,-0.024653,-0.020411,0.022182,-0.029850,0.006016,0.022263,-0.019877,0.008109,0.044411,0.026000,0.017378,-0.041822,-0.001529,0.010747,-0 .004636,0.008410,-0.034179,0.018747,0.009375,-0.055623,0.029170,0.012813,-0.032796,0.035399,0.001340,0.032082,-0.041461,0.039306,-0.041612,0.000170,0.022602,0.035404,-0.013420,0.028094,-0.0 68920,-0.019555,0.027717,0.016854,-0.007904,0.043193,-0.012270,0.035055,0.003267,0.003872,0.009076,-0.007750,-0.018392,-0.022104,-0.017584,-0.027788,0.025403,0.027032,0.030627,-0.018845,0.0 11982,-0.000835,0.005143,-0.005417,-0.011466,-0.024403,-0.184620,0.030185,-0.005881,-0.022783,-0.059692,-0.006960,-0.023904,0.018336,0.019860,-0.002630,-0.036012,-0.039439,0.029408,-0.01240 5,0.028103,0.006468,-0.000316,0.024784,-0.012905,0.078487,-0.003920,0.006871,0.010495,0.025348,0.067278,-0.017756,-0.009372,0.034497,-0.031064,-0.020285,-0.066398,0.040778,0.027831,0.039908 ,0.006715,-0.025189,0.019457,-0.004781,-0.017321,-0.019331,0.021850,0.010403,-0.013669,0.006060,0.033969,0.027110,-0.039757,-0.029750,-0.027967,-0.026708,0.028292,-0.021893,-0.024141,0.0056 38,-0.007356,0.003192,-0.030448,0.031031,-0.027274,0.053648,0.027482,0.014865,-0.021752,-0.030062,-0.062190,-0.012515,-0.013036,-0.022397,-0.008476,0.011857,-0.011676,-0.032166,0.014218,-0. 021642,-0.012395,-0.024320,0.046703,-0.025360,-0.022159,-0.019353,-0.031849,0.016185,-0.051968,-0.051502,0.023051,0.033477,-0.003444,-0.017618,-0.033137,0.006456,-0.023311,0.001015,0.035386 ,0.017095,-0.019364,0.031553,-0.016004,-0.006957,-0.007973,-0.041158,-0.001224,-0.049667,0.005078,-0.009431,-0.043621,0.009495,0.042741,-0.000694,-0.039937,-0.043528,-0.032941,0.039049,-0.0 12061,-0.024153,0.003693,-0.000078,-0.019990,0.022679,0.004080,-0.005768,0.025865,0.034569,0.056000,-0.053885,0.000750,0.004387,0.036385,0.025853,0.033725,0.003620,0.013260,0.016655,0.04493 2,0.072355,0.064293,-0.017782,-0.007923,0.034830,-0.046739,-0.053568,0.004296,-0.050584,-0.005845,-0.037552,-0.002695,-0.000287,-0.046865,0.055801,-0.015838,-0.020805,0.004015,0.009470,0.07 0361,0.014612,-0.028762,0.020527,-0.011884,-0.015626,-0.000471,0.017307,-0.012716,-0.032151,-0.025675,-0.064772,0.004987,0.009666,-0.012453,-0.035716,-0.041264,0.007405,0.008175,0.014447,-0 .002128,0.016853,0.009374,-0.020323,0.013453,-0.021583,0.065662,0.020366,0.026422,-0.003030,0.060257,0.000979,0.011537,0.029652,0.010401,0.032685,0.012861,-0.022461,-0.019818,0.010740,0.007 277,0.027096,0.053632,0.000693,0.011563,0.053456,-0.012863,0.018913,-0.010575,-0.036057,-0.017634,0.018529,-0.031293,0.030732,0.011685,0.038584,0.009525,0.038385,-0.038111,0.009920,-0.02491 5,0.001010,0.046475,0.030816,0.029520,-0.008917,-0.002078,-0.002885,0.006621,0.024127,-0.017235,-0.022501,-0.046541,-0.025876,0.002467,-0.056053,-0.047967,0.016325,-0.030759,0.005945,0.0033 93,0.042127,-0.024996,-0.003728,0.024738,-0.028101,-0.002682,-0.046215,0.018618,-0.056831,-0.065534,-0.016202]'
-> ) AS distance
-> FROM faq_chunks
-> ORDER BY distance
-> LIMIT 3;
+----+-------------+-----------------------------------------------------------------------+--------------------+
| id | doc_id | title | distance |
+----+-------------+-----------------------------------------------------------------------+--------------------+
| 3 | order-003 | Can I change the order contents or shipping address? | 0.8638027757928116 |
| 26 | invoice-002 | Can I add a company tax ID to the invoice later? | 0.9447801475558247 |
| 12 | ship-006 | Tracking says delivered, but I did not receive the package. What now? | 0.9532230845639238 |
+----+-------------+-----------------------------------------------------------------------+--------------------+
3 rows in set (0.01 sec)
villagesql> select id, doc_id, category, title, content from faq_chunks where id='order-003';
+----+-----------+----------+------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | doc_id | category | title | content |
+----+-----------+----------+------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 3 | order-003 | Orders | Can I change the order contents or shipping address? | [Orders] Can I change the order contents or shipping address?
You cannot change items or quantities after checkout. Cancel the original order and place a new one. While the order is still Processing, support can help update the shipping address; once it has shipped, the address cannot be changed. If you picked the wrong convenience-store location, contact support before shipment to change it. |
+----+-----------+----------+------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
I built a little helper to generate the embedding from an Ollama bge-m3 model
$ python ./embed.py "How do I check my order status?"
[-0.038208,-0.021498,-0.035436,-0.022429,-0.001427,-0.000292,-0.012322,-0.017614,0.000218,0.008299,0.023525,0.007146,-0.024900,0.026232,0.014993,-0.006112,-0.028233,-0.045551,-0.022423,-0.015630,-0.027306,0.019715,0.016540,0.037897,0.060623,0.047402,-0.023959,-0.004842,0.028105,0.007151,0.007698,-0.018001,0.028671,-0.020626,-0.039444,-0.002076,0.060681,-0.028801,-0.042039,0.036107,-0.018014,-0.002619,-0.025033,-0.027283,0.024774,-0.021661,-0.013895,0.004311,-0.026084,-0.005713,-0.008035,-0.028186,0.034676,-0.009634,0.021666,0.074958,0.023351,-0.024244,-0.021637,-0.021166,-0.025829,-0.022149,-0.030697,0.032965,-0.007047,0.063897,0.022571,-0.025082,-0.013707,-0.006645,-0.025049,0.028424,-0.041003,0.027200,-0.050705,0.032223,0.023832,-0.025801,-0.009840,-0.028927,0.027203,0.009240,-0.005209,-0.014420,0.019607,0.044303,0.018713,0.023537,0.003646,0.017356,0.003014,0.018794,0.002509,-0.055431,-0.021344,-0.015684,-0.019629,-0.013748,0.038757,-0.018796,-0.013065,-0.039251,0.048738,-0.002848,-0.015660,0.012855,0.023862,0.008228,-0.011646,-0.033177,-0.000224,0.024562,0.024750,-0.026107,0.004614,-0.020638,-0.043486,-0.013012,-0.012966,-0.017743,0.021321,0.006467,0.004753,-0.012815,-0.077888,-0.030968,0.066813,0.014015,0.013394,0.033143,0.008960,0.051947,-0.044574,0.004676,-0.017380,0.012635,-0.000136,0.019006,-0.015465,-0.038212,0.078181,0.053996,-0.019713,-0.000420,0.016235,-0.031087,0.049767,-0.017277,0.040163,-0.034620,-0.003892,0.010605,-0.006021,-0.019636,-0.018108,-0.026219,0.004902,0.041421,-0.054360,0.037424,-0.015472,0.037400,-0.016834,0.040617,0.023943,-0.041104,0.001535,-0.014453,-0.003394,-0.008018,0.008455,-0.072524,0.024906,-0.008736,0.001151,0.027391,0.090555,0.002557,-0.012020,-0.017730,-0.019574,0.018314,-0.005414,-0.030072,-0.015975,0.057489,0.031666,0.006210,0.009412,0.024413,-0.043113,-0.008676,0.027220,-0.003992,0.006014,-0.008196,0.004532,0.021117,-0.036313,-0.016232,-0.025507,0.012557,0.068438,0.014603,-0.034650,0.004328,0.017537,-0.032372,0.007677,-0.033108,-0.027163,0.002986,-0.003412,0.022650,-0.050226,-0.001692,0.022524,0.009457,-0.056178,0.000485,-0.007244,0.022398,0.045004,-0.033356,0.027495,0.009143,0.000986,0.036654,0.018475,-0.033919,-0.027883,0.022826,-0.021807,0.014885,0.042214,-0.000846,-0.030373,0.022534,0.000899,0.035099,-0.037894,-0.018968,0.052120,0.019039,-0.066722,0.020147,0.043540,-0.010541,0.011347,-0.018898,0.009691,-0.018363,0.013488,0.012650,0.006773,0.012282,-0.004528,-0.025177,-0.004414,0.014839,0.012220,-0.031364,-0.003668,0.029477,0.008002,0.021323,-0.010821,-0.001324,0.021360,0.001522,-0.045600,0.016614,-0.007853,0.000415,-0.000029,0.059232,-0.019058,-0.001647,0.059988,-0.029102,0.017505,0.028929,0.003179,-0.023737,0.035110,-0.044521,-0.032910,-0.027052,0.019261,-0.079396,-0.020498,0.011682,0.066420,0.029169,0.008822,-0.009880,-0.000288,-0.175168,-0.056760,0.017954,0.006222,0.003175,0.002452,-0.048129,-0.028718,-0.043383,-0.002199,0.030981,-0.055649,-0.003652,0.000741,0.019452,-0.025516,-0.028450,0.009055,0.023898,-0.041459,-0.035746,-0.049130,0.025772,-0.022643,-0.033171,0.004601,0.031851,-0.016758,-0.047046,-0.001250,0.027128,-0.012020,0.005013,0.004301,0.053961,0.040561,0.028003,-0.045596,0.016960,0.022251,0.026088,0.071000,-0.001508,0.004917,-0.004475,-0.056974,-0.017393,0.017995,-0.008499,-0.003258,-0.042818,-0.003135,-0.014351,-0.019132,-0.051613,0.007672,0.001134,0.037347,-0.036517,0.019779,-0.043711,-0.069291,0.021288,-0.009777,-0.033159,-0.014637,-0.054684,-0.031442,0.024497,-0.027515,0.017415,-0.003204,-0.031252,-0.034627,0.004292,0.047189,-0.053121,-0.008867,-0.025341,-0.146836,-0.053371,0.037618,-0.038756,-0.025450,-0.008098,-0.014464,0.018715,0.047229,0.042613,0.255620,-0.023690,-0.012144,-0.019417,0.069116,-0.017058,0.014733,0.040202,-0.004384,-0.022003,0.010558,-0.051201,-0.002376,-0.008472,-0.000370,-0.022391,-0.057973,-0.009323,0.081407,0.000378,0.012001,0.020260,0.008446,-0.062177,-0.054430,-0.017425,-0.013290,0.030693,-0.021457,0.034139,-0.034279,0.006376,0.051354,-0.033223,-0.024562,0.013459,0.021929,-0.033118,-0.021328,0.013162,-0.030462,-0.020963,0.021563,-0.026640,0.017391,-0.041591,0.006747,0.060220,-0.017429,-0.005099,0.014229,-0.025591,-0.048026,-0.022295,-0.019705,-0.046122,-0.005979,-0.003516,-0.035927,0.065665,0.003057,0.017675,-0.005785,0.003727,-0.001998,0.052468,-0.018395,0.031713,-0.027384,0.019634,-0.012402,-0.011022,0.000983,0.014199,0.037624,0.032706,-0.013151,0.033992,-0.019769,0.046920,0.018714,0.047786,-0.018545,0.070560,0.009702,-0.001635,-0.018256,0.050729,0.015511,0.015184,-0.004444,-0.005525,-0.041335,-0.010702,0.008806,-0.013685,0.000826,0.010651,-0.016952,0.006481,-0.022079,0.005861,0.005984,-0.003465,0.031341,-0.000682,-0.017572,0.014330,0.034947,-0.013404,-0.063205,0.028459,0.022450,0.001702,0.003335,0.056194,0.003727,0.020590,0.054334,0.068201,-0.052012,0.010257,0.016734,-0.012658,-0.019211,-0.093694,-0.000934,-0.042262,-0.012734,0.034733,0.005092,-0.012580,0.014902,0.035366,0.035199,0.015854,0.012470,0.003258,-0.001901,0.072221,-0.004151,-0.003298,-0.036197,-0.013234,0.021182,0.016482,0.021138,-0.015243,-0.049671,-0.009919,0.001728,0.051431,0.009452,-0.038389,-0.008452,-0.038444,0.017473,-0.027414,0.007656,-0.019203,0.018143,0.008838,-0.006300,0.108892,-0.012400,-0.028264,-0.030939,0.032203,0.043925,-0.012924,0.019003,-0.059136,-0.041673,0.011672,0.001911,0.000981,-0.053870,0.003168,0.056361,-0.037625,0.048144,-0.026846,-0.034728,0.023200,-0.002797,-0.004049,-0.000186,-0.011994,-0.010472,-0.023400,-0.022951,0.090079,0.030165,-0.002143,0.023995,-0.011980,0.045822,0.028466,0.008192,-0.001068,-0.013620,-0.023543,-0.011945,-0.027571,0.020464,0.016134,0.028272,0.044381,-0.011476,0.023933,0.000420,0.016506,-0.015654,-0.047417,0.023135,-0.031683,0.045740,0.043796,0.009715,-0.007857,-0.027880,0.018097,0.063687,-0.036838,-0.024606,0.046614,0.044806,-0.040128,-0.009990,-0.021571,-0.001615,0.023252,0.035359,-0.022629,0.004986,-0.032878,0.011399,0.018468,-0.022817,-0.030430,0.034634,-0.012720,0.018900,0.032487,0.000759,0.018467,-0.006350,-0.026945,0.071120,-0.014954,-0.016770,-0.007654,0.051858,0.000551,-0.000323,0.052442,-0.039270,0.005887,-0.007366,0.010736,0.004463,0.020531,-0.003903,-0.002820,0.025212,-0.039472,0.018610,0.038946,-0.031841,-0.023653,0.022137,-0.009002,-0.032033,0.019791,-0.030774,0.000463,0.016775,0.034387,-0.040107,0.009464,-0.010942,-0.022662,-0.002929,0.022317,-0.012930,-0.000429,-0.038732,0.057041,-0.021828,0.026054,-0.027572,0.027535,-0.059970,0.019495,-0.022613,-0.006142,-0.017445,0.005655,-0.051283,0.012655,-0.028670,0.062335,-0.021018,-0.000046,0.030621,0.008055,-0.021630,0.033715,0.029223,0.044312,0.012772,-0.095034,-0.007452,0.012112,0.011429,0.000260,0.068779,-0.003291,-0.033091,-0.022929,0.009150,0.000414,0.018213,-0.005333,-0.012236,0.004744,0.012758,-0.007920,-0.014814,-0.001940,-0.005917,0.016163,-0.021355,-0.026792,-0.040524,-0.017239,0.009095,-0.031664,0.038745,-0.043469,-0.004467,0.020480,0.043714,0.014553,0.023122,-0.030418,0.017055,-0.005749,0.011989,0.003459,0.025034,0.004631,0.009315,-0.052918,0.044745,0.015050,0.002346,0.009754,0.021987,0.027769,-0.033609,0.029493,0.009562,0.010099,0.022594,0.013249,0.003828,0.018212,0.032724,0.002773,0.010221,0.005269,0.026360,0.023554,0.016600,0.035588,0.037662,-0.019373,0.001400,0.007747,-0.034796,-0.000573,-0.026088,-0.013261,-0.004818,0.031136,0.023075,-0.001368,0.001986,-0.059766,-0.022168,0.042198,-0.033920,0.002465,-0.179707,0.026285,0.026059,-0.027122,-0.016252,-0.016690,-0.005444,-0.025842,0.007667,0.019664,-0.025635,-0.020119,0.025903,-0.028187,0.045890,0.040724,-0.013655,0.016157,0.012733,0.039305,-0.004014,-0.009228,0.004061,-0.002456,0.041434,-0.033090,0.034466,0.008062,-0.027409,-0.055027,-0.021253,-0.025081,0.000822,0.060335,-0.010553,-0.011020,-0.004746,-0.011169,-0.029430,-0.018168,0.011270,0.020949,0.006023,-0.006990,0.016031,-0.027205,0.009711,0.008556,-0.008928,-0.011166,0.000260,0.004894,-0.002522,-0.020368,-0.005247,-0.043772,-0.051219,0.021828,-0.017293,0.021192,0.002847,0.022641,-0.031136,-0.069488,-0.023194,-0.021758,-0.062134,-0.003528,0.018130,-0.030564,-0.017036,0.010287,0.042246,-0.030166,-0.009489,-0.003786,0.007740,-0.055661,-0.021465,-0.011600,-0.052621,0.014276,-0.041952,0.022760,0.047561,0.016865,0.020473,0.004932,-0.041308,-0.013065,-0.044207,0.006206,0.025730,0.011635,-0.018085,0.001550,-0.009363,-0.008599,-0.030417,-0.004248,-0.011914,-0.034426,0.023584,0.033307,-0.020097,0.022058,0.075726,0.013136,-0.009492,-0.038791,-0.009610,0.013933,-0.045680,-0.005443,-0.016939,-0.034086,-0.026141,0.003470,-0.006654,-0.038036,-0.017120,0.018293,0.035311,-0.040093,-0.025608,0.015060,0.065498,-0.002059,0.041065,-0.009369,-0.006072,-0.044310,0.004768,0.049569,0.046529,-0.004557,-0.053401,0.049556,-0.032440,-0.055108,-0.009546,-0.016950,-0.014170,-0.029678,0.006630,-0.002434,0.050246,0.031357,-0.029426,-0.022467,0.009123,-0.005525,0.023982,0.033483,0.011197,-0.005191,0.010709,0.006755,0.013650,0.035249,0.030186,-0.005796,-0.033508,-0.032428,0.030287,0.063633,0.015586,-0.013756,-0.039291,-0.007939,-0.005800,-0.011768,-0.023578,0.024039,0.008340,-0.005515,0.008505,0.002318,0.037923,-0.002590,0.030531,0.010931,-0.010449,0.008165,0.056077,-0.018842,-0.001863,0.037732,-0.025916,-0.006196,0.001247,0.005105,0.000468,-0.020715,0.040898,0.029938,0.023501,0.055241,0.011743,0.048155,-0.022050,-0.012423,-0.013791,-0.001626,-0.057775,-0.008509,0.016137,-0.029523,0.000348,0.000421,-0.013593,0.001556,-0.012883,-0.036199,-0.026735,0.005109,-0.001331,-0.011973,-0.001702,0.025794,-0.008905,0.017893,-0.028609,-0.023051,-0.050745,-0.038067,-0.017681,-0.019698,-0.034410,0.046064,-0.026817,0.005465,-0.024885,0.050798,-0.009594,-0.014600,-0.010775,-0.002354,0.002981,-0.031412,0.020252,-0.063681,-0.011372,-0.054300]
What’s next
The RAG demo provides a chatbot and I want to wire in a published VillageSQL docker image to recreate this.
$ make chat
Docker VM: 6 CPUs, 16 GiB RAM (need >= 2 CPUs, 8 GiB)
cd app && python3 chatbot.py
=== LitoShop AI support (retrieval: mysql, Ctrl-C to quit) ===
💬 Your question: how long until my order ships.
[MySQL] 43 candidates | fetch 422.6 ms | rank 52.7 ms
0.7706 [order-004] My order still has not shipped. What should I do?
0.6739 [ship-003] How long do I have to pick up a convenience-store order? What if I miss it?
0.6736 [ship-006] Tracking says delivered, but I did not receive the package. What now?
🤖 LitoShop support: If your order still hasn't shipped after 3 business days, we'll send a delay email to let you know. You can also check the order notes in Member Center or contact our live chat team (Monday-Friday, 09:00-18:00) for assistance.
Here are some key facts:
* Regular items usually ship within 1-2 business days after checkout.
* Preorders follow the estimated ship date on the product page.
* If you haven't received your order after 3 business days, please check the delay email and contact live chat for help.
If you need further assistance, I can transfer you to a human agent. Would you like me to do that?
