Build AI sql assistant with LLM. LanghChain tutorial. Streamlit Tutorial. LLM Tutorial . ChatGPT.

This video showcases how to build your personal AI sql assistant which takes user input in natural language and internally prepares sql for it and returns the final results post execution in database. #ai #llm #sql #database #datascience #artificialintelligence #largelanguagemodels #langchain #streamlit #python #pythonprogramming #llmapplication #robot #robotics #entrepreneur #enterprisesolutions #innovation #innovative #promptengineer #promptengineering

[polly-]

How about huge database? We send the huge schema of the huge database with the initial prompt, which costs a lot? What will be the solution for huge database?

[saiveeramalla]

Also can you make seperate tab in which the results you got can be plotted may be like piechart or graph dynamically based on user prompt

[deeplearning]

Great work, looking forward to more videos from you.

[Manjubhati]

Thanks for making such knowledgeable videos👍

[sachinprakash]

Please share the link for prompt creation and load process video

[AliAlias]

Thanks very nice 🌹,
How to use open source LLM from hugging face locally using ctransformer or lamacpp library with Pandas Ai in offline mode? for example codellama or pandalytic gguf type

[quvlzgq]

Hello thanks for sharing the video. I am currently working with MongoDB databases. Could you please create a similar video on MongoDB? Unfortunately, I haven't found a MongoDB agent in the Lang chain, so I was wondering if you could help me with that.

[kauserperwez]

In one of the column in database, if I have personal information that I want to mask and show in results, can someone please explain how do I do that

[leedsshri]

Hello, is it possible to connect to Teradata database from Langchain ? If yes, could you pls show that ?

[kamilpatel]

This is gonna working with smaller database smoothly and very effeciently but when we talk about the bigger database or the enterprise level database then this code is break in to Execute the simple query.

I have tried this method earlier and it was not work well with the bigger database.

[channelShutter]

Hey, Thanks for this video. Could you please tell me how you got the Analytics database in this video?

[manaskalra]

Hi
Great project
Can you explain me how can I change the prompt? like what if I want it to generate queries for a different db?

[anagai]

How do you get it to display result in nice table format like that. I have json output and just displays the json

[the_student_chef]

Can you please add the conversational memory to the sql generator using ConversationBufferMemory and post the video or code (in the git repo).

Also, if for any reason there are error(s) in the generated SQL
Queries, can you get OpenAI to regenerate the query and solve the errors by providing some
additional context if necessary ?

[the_student_chef]

how have you created the database in snowflake ? is there any video for the snowflake analytics db creation ?

[GeriFitrah]

i have question, if user want ask something outside the database for ex user ask USD rate in january 2020, can it handle with same prompt ? or we need to make another prompt to handle question outside the database ? thx for the tutorial

[renaudgg]

when you wrote this line: llm = OpenAI(temperature=0.9) what is the default model it uses? if instead I write: llm = OpenAI(model="gpt-4", temperature=0.9) im getting error: Error: Error code: 404 - {'error': {'message': 'This is a chat model and not supported in the v1/completions endpoint. Did you mean to use v1/chat/completions?', 'type': 'invalid_request_error', 'param': 'model', 'code': None}}

how can we make it so that its gpt4?

[waseem]

is that prompts.yml file necessary? what if I have to query on my SQLite.db? how i will write that all stuff in that yml file.?