使用OpenChatBI代理进行自然语言商业智能分析

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:
- <img src="https://github.com/1991513ccie-png/skills" alt="Demo" width="800">
- Access to a supported LLM provider (OpenAI, Anthropic, etc.)
- Data Warehouse (Database) credentials (like Presto, PostgreSQL, MySQL, etc.)

• Source: https://github.com/1991513ccie-png/skills
• Extracted from upstream docs: https://raw.githubusercontent.com/zhongyu09/openchatbi/HEAD/README.md

Documentation

• https://zhongyu09.github.io/openchatbi/