This paper explores the use of Large Language Model (LLM)-based agents as tools for supporting knowledge creation from Environmental, Social and Governance (ESG) data, with a specific focus on the social dimension. Despite the growing availability of ESG data, organisations still face substantial challenges in transforming quantitative indicators into actionable insights that can effectively support strategic decision-making. Current reporting tools mainly provide descriptive outputs, while more advanced AI-based solutions often require technical expertise that limits their practical adoption. This study addresses that gap by proposing an accessible, low-cost decision support system built on open-source technologies. The research adopts a Design Science Research (DSR) approach and develops a conversational ESG advisory agent built on Langflow, an open-source low-code platform, and Llama 4 Scout 17B, a large language model served free of charge via Groq. The agent receives structured ESG indicators through a guided conversational interface, computes relevant metrics, compares them against sector benchmarks derived from principal component analysis and cluster analysis of real energy-sector data, and produces a qualitative assessment report including an improvement roadmap aligned with Global Reporting Initiative (GRI) 401-406, European Sustainability Reporting Standards (ESRS) S1-S2, and Sustainable Development Goals (SDGs) 3, 5, and 10. Evaluation on a synthetic dataset of 40 fictitious energy companies shows that the agent achieves 98.1% value accuracy and 93.2% judgment accuracy on eight of the eleven variables tested. The remaining three variables, specifically the Gender Pay Gap and the two Cultural Diversity indicators, show significantly lower accuracy ranging from 33% to 45%, attributable to the model’s limited capacity to handle competing instructions and maintain parallel reasoning tracks. Through iterative DSR testing, the study finds that restructuring the input to eliminate ambiguity is a more reliable corrective strategy than refining the prompt, suggesting a broader design principle for low-code AI systems based on mid-sized models. The paper contributes to the emerging literature on AI-driven sustainability analytics by proposing and evaluating a replicable, low-cost system that bridges the gap between quantitative ESG reporting and qualitative organisational insight. From a practical standpoint, the findings demonstrate that accessible AI architectures can support meaningful ESG knowledge creation even in resource-constrained organisational settings, acting as a cognitive support tool for human decision-makers rather than replacing them.