Introduction FarmaStock AI is an academic Generative AI project focused on a real-world problem: how to make pharmacy stock analysis easier to understand and explore. In community pharmacy, stock information is not always straightforward. Sales, purchases, manual stock corrections and inventory movements can appear across different exports or operational records. This makes it difficult to quickly understand what happened with a product, why stock changed, or what kind of analytical logic should be applied before making replenishment decisions. The goal of this project was not to replace a pharmacy management system. Instead, I wanted to build a domain-specific AI assistant capable of answering questions about pharmacy stock logic, data preparation, analytical decisions and future optimization opportunities. The result is FarmaStock AI: a Retrieval-Augmented Generation assistant built with Python, LangGraph, ChromaDB, Gemini and Streamlit.…