How SoftwareMill employees went from writing complex SQL queries to asking questions in plain English.

SoftwareMill is a software consultancy specializing in custom software development and distributed systems. Readers can learn about software architecture, cloud computing, and functional programming. With case studies, blog posts, and technical analysis, SoftwareMill provides  insights and expertise for building scalable and resilient software solutions.

SoftwareMill

SoftwareMill built FinBot, an AI-powered natural language interface to their BigQuery financial data, reducing query time from 15-20 minutes to 10-60 seconds. The system uses a multi-agent architecture with LangChain and LangGraph, featuring specialized agents for query routing, entity resolution, SQL generation, and chart creation. The solution eliminated SQL barriers for non-technical users, saving approximately 2,900 hours annually across the organization by enabling conversational queries like "How much did backend development cost in Q2 2025?" instead of complex SQL. Key technical challenges included ambiguous entity matching (solved with fuzzy matching and confidence scores), temporal query handling (context manager), and performance optimization (caching with Redis).

Reducing Time-to-Insight in Company Financial Data by 90%