agentskillexchange Run natural-language BI analysis with OpenChatBI agents
Deploy OpenChatBI when an agent needs to turn business questions into SQL, charts, anomaly analysis, and explainable BI results.
Prerequisites
Python, pip, database connection, configured LLM provider, optional MCP tools, optional Gradio or Streamlit UI
Installation
Use the upstream install or setup path that matches your environment:
- git clone git@github.com:zhongyu09/openchatbi
- uv sync
- pip install openchatbi
- uv sync --group dev
Requirements and caveats from upstream:
- Code Execution: Execute Python code for data analysis and visualization
- multi-dimensional drill-down (Adtributor) and Python execution to cover trend forecasting, anomaly detection,
- Python 3.11 or higher
Basic usage or getting-started notes:
Access to a supported LLM provider (OpenAI, Anthropic, etc.)
Data Warehouse (Database) credentials (like Presto, PostgreSQL, MySQL, etc.)
Extracted from upstream docs: https://raw.githubusercontent.com/zhongyu09/openchatbi/HEAD/README.md