Building an Gen AI SQL Assistant from Scratch with Vanna LLM: Training and Querying Your Database

[@kenchang3456]

Thank you very much for this helpful video. I find it interesting that your vn.ask() questions always reference the dbo from your SQL db and given that you only had trained on one table was that necessary? Also I was hoping, that if I had trained multiple tables with multiple complex SQL queries and their accompanying questing, that Vanna would be able to infer what tables and attributes to use based on the question my user is asking. Is that asking too much of Vanna and the LLM I'm using?

[@musicphimhan7530]

Thank you for your lecture

[@BinFangRE]

Please help to answer my question. At 4:30, you mentioned API key. Is it API key of LLM(OpenAI)? or it is API key of Vanna?

[@ProgrammingIsFunn]

This is vanna api key

[@ProgrammingIsFunn]

You can register your self on vanna platform and get api key. vanna.ai/docs/vanna.html#getting-an-api-key

[@tabbasumnaz4757]

@@ProgrammingIsFunn Is it paid one?

[@KarthikBhat-j4r]

Is it compulsory to provide the data base name in the question ? Some times we might not know the database name hence

[@datasciencetoday7127]

you are so egzited bro its so nice

[@emptyslot6972]

I guess this only works, if you have meaningful table names and column names. And also a lot of foreign keys

[@ProgrammingIsFunn]

I have not tried, but I believe you are right.

[@Himansh29]

❤

[@himanisingh3335]

hi I have tried your steps. I am getting below error while running vn.train(plan = plan) SSLError: HTTPSConnectionPool(host='ask.vanna.ai', port=443): Max retries exceeded with url: /rpc (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self-signed certificate in certificate chain (_ssl.c:1006)')))

[@ProgrammingIsFunn]

You can run n number of time I think 💭.

[@amotorcyclerider3230]

Excellent. I was working on vanna today and trying out some stuff. Just now found this video. Very helpful. I also have MSSQL database and used the same sql to pull schema and train. But I was not able to successfully train. So I had to use ddl fora selected tables and that worked. Now, here does it use a vector database? And I guess you are using chromadb.

[@rajdeepsingh-xc6wx]

vn.ask returns none

[@ProgrammingIsFunn]

Help me with your prompt.

[@KarthikBhat-j4r]

Is it compulsory to provide the data base name in the question ? Some times we might not know the database name hence

[@KarthikBhat-j4r]

Is it compulsory to provide the data base name in the question ? Some times we might not know the database name in pool of many

[@ProgrammingIsFunn]

It's not always necessary to provide the database name, but it can help to narrow down the context for a more accurate response.