Icon

NLSQL_​Llama3.2(Ollama)

<p>Natural language to SQL chatbot. Forking mlauber71's workflow https://shorturl.at/L7jWM<br>For best results, run it on a computer with a dedicated NVIDIA/AMD GPU if possible. <br>Tested on a laptop with Intel Iris Xe graphics and Ollama 0.3.13</p>

URL: Chat with local Llama3.2 model via Ollama in KNIME https://hub.knime.com/mlauber71/spaces/LLM_Space/Ollama%20-%20Chat%20with%20LLama3~_gPUhkuAieieXCsi/current-state

Natural language to SQL chatbot. From mlauber71's workflow https://shorturl.at/L7jWM For best results, run it on a computer with a dedicated NVIDIA/AMD GPU if possible. Tested on a laptop with Intel Iris Xe graphics and Ollama 0.3.13 1- Download Ollama and install it 2- Run the following command to download the model: ollama run llama3.2 3- Execute the workflow and interact with the chat Tested on local PostGres DB with Oracle's HR schema You need to create the database using the following file before test the output codes current time reload the current saved chat with Ollama Right click to open interactive view Make sure Ollama is running in the background eg. in the Terminal Window: ollama run phi4-mini save chat as .table with timestamp scan for the latest file to store the olama* .table results ../data/chat/ Create the chat folder if not exists Node 1802 Node 1803 HR Schema Create Date&Time Range Table Reader Chat with Ollama Table Writer List Files/Folders create file name to collect Create empty Log File Create Folder PostgreSQL Connector DB Query Reader List Files/Folders Natural language to SQL chatbot. From mlauber71's workflow https://shorturl.at/L7jWM For best results, run it on a computer with a dedicated NVIDIA/AMD GPU if possible. Tested on a laptop with Intel Iris Xe graphics and Ollama 0.3.13 1- Download Ollama and install it 2- Run the following command to download the model: ollama run llama3.2 3- Execute the workflow and interact with the chat Tested on local PostGres DB with Oracle's HR schema You need to create the database using the following file before test the output codes current time reload the current saved chat with Ollama Right click to open interactive view Make sure Ollama is running in the background eg. in the Terminal Window: ollama run phi4-mini save chat as .table with timestamp scan for the latest file to store the olama* .table results ../data/chat/ Create the chat folder if not exists Node 1802 Node 1803 HR Schema Create Date&Time Range Table Reader Chat with Ollama Table Writer List Files/Folders create file name to collect Create empty Log File Create Folder PostgreSQL Connector DB Query Reader List Files/Folders

Nodes

Extensions

Links