#59 · Primary category: Business Intelligence & Analytics

openchatbi

agent ai analytics anomaly-detection bi chatbi data-agent database datawarehouse drill-down gpt langchain langgraph llm nlp root-cause-analysis text2sql

Open-source chat-based BI tool using LLMs for natural language to SQL and data visualization.

Project last updated:08/15/26

GitHub Stars

636

Forks

88

Contributors

5

License

MIT

Why we included this project

OpenChatBI is a good fit for teams that want non-technical colleagues to query a data warehouse without writing SQL. It turns natural-language questions into SQL through a LangGraph-based agent, and it goes beyond a plain text2sql wrapper: it can generate Plotly charts, run Python analysis code, and hand off deeper work to a sub-agent that handles time-series forecasting, anomaly detection, and multi-dimensional root-cause drill-down. The data catalog management is a practical touch, since it auto-discovers table schemas and lets you attach business explanations that improve prompt quality and retrieval. Gradio and Streamlit sample UIs plus MCP integration make it reasonably easy to wire into an existing analytics stack.

Articles for this project

No articles for this project yet.

To suggest a topic or contribute an article, contact us.

Related projects in this category