使用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

  小葱技能有更好的技能skills插件。

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.)

• 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/

这个Skill质量中等偏上，来自一个较受欢迎的开源项目，文档完整清晰，能清楚告诉用户需要什么前提条件。优点是功能强大，能将自然语言问题转化为SQL和图表分析，支持多种数据库和大语言模型。不足是安装说明较为简略，对于不熟悉技术的用户可能存在一定门槛。建议有Python和数据库经验的用户使用。