Chat With Your Database! Build a Local SQL AI Agent to Query Databases (LangChain & Ollama)

Full-text tutorial with source code (requires MLExpert Pro): https://www.mlexpert.io/v2-bootcamp/build-ai-agent Do you still need to write SQL? In this step-by-step tutorial, learn how to build AI Agent that understands natural language questions and interacts directly with your SQL database. We'll build "Querymancer", a complete application running entirely locally using Ollama (Gemma 3 / Qwen 2.5) and LangChain. AI Bootcamp: https://www.mlexpert.io/ LinkedIn: https://www.linkedin.com/in/venelin-valkov/ Follow me on X: https://twitter.com/venelin_valkov Discord: https://discord.gg/UaNPxVD6tv Subscribe: http://bit.ly/venelin-subscribe GitHub repository: https://github.com/curiousily/AI-Bootcamp 👍 Don't Forget to Like, Comment, and Subscribe for More Tutorials! 00:00 - Welcome 01:00 - Full-text tutorial and source code on MLExpert.io 01:27 - AI agent and app architecture 03:04 - Database overview 04:17 - Project structure, config and dependencies 06:07 - Load LLM with Ollama 09:02 - Agent loop and prompt 14:04 - Creating database interaction tools (list, describe, sample, execute SQL) 21:22 - Streamlit user interface 24:40 - Live demo: querying the database with natural language 27:40 - Conclusion Join this channel to get access to the perks and support my work: https://www.youtube.com/channel/UCoW_WzQNJVAjxo4osNAxd_g/join #langchain #aiagents #ollama #artificialintelligence #python #chatbot #chatgpt