# Chatting with my movie-advisor using a langchain agent, RAG tools, Xata PostreSQL and TMDB

%[https://youtu.be/_nmiwgwRHxM] 

[Github repo](https://github.com/alexdjulin/movie-advisor)

This is a demo of my movie-advisor project: I created a chatbot driven by a langchain agent and RAG tools.

The agent is handling all conversations between me and the LLM. Based on my queries, it will search for preferences and update my watch lists stored on the postgreSQL database Xata, or fetch missing information from the movie database TMDB.

I am using my other project [ai\_chatbot](https://github.com/alexdjulin/ai_chatbot) as submodule to initialise the agent and handle voice conversations using Google STT and Edge TTS engines.

**Tools:** [Langchain](https://python.langchain.com/v0.1/docs/get_started/introduction/) | [Xa](https://www.compart.com/en/unicode/U+2B24)[ta](https://xata.io/) | [TMDB](https://www.themoviedb.org/)

Don't miss my other AI-related articles on my [dev blog](https://dev.alexdjulin.ovh/)!

Music by Denys Kyshchuk from Pixabay.
