I Built an NL2SQL Agent for IPL Cricket While Learning How AI Agents Actually Work

IPL 2026 starts this month, so I built something around it. I have been learning how to build AI agents, and one thing I kept wanting was a project that felt concrete. Not just a chatbot demo, but something that had to deal with real data, real edge cases, and real mistakes. So I built IPL Cricket Analyst . It lets you ask questions about IPL data in plain English and get back a SQL-backed answer in real time from an SQL database, along with charts, follow-up suggestions, and support for multi-turn questions. The user don't have to know the queries, LLM will generate for you. Some example questions: "Who has the best death-over economy since 2020?" "Show me a bar chart of the top 10 wicket takers." "What is Virat Kohli's strike rate at Eden Gardens after 2022?" Under the hood, the agent writes the SQL, validates it, runs it against 278,000+ ball-by-ball deliveries, and streams the result back while it works. What I built Layer Tech Frontend Next.js 14, TypeScript, Tailwind CSS Backend