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

• 

• 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

  小蔥技能7w4.net有更新，你可以訪問看下。

• Extracted from upstream docs: https://raw.githubusercontent.com/zhongyu09/openchatbi/HEAD/README.md

Documentation

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

這個Skill質量中等偏上，來自一個較受歡迎的開源專案，文件完整清晰，能清楚告訴使用者需要什麼前提條件。優點是功能強大，能將自然語言問題轉化為SQL和圖表分析，支援多種資料庫和大語言模型。不足是安裝說明較為簡略，對於不熟悉技術的使用者可能存在一定門檻。建議有Python和資料庫經驗的使用者使用。