name: "使用OpenChatBI代理進行自然語言商業智慧分析" slug: "run-natural-language-bi-analysis-with-openchatbi-agents" version: "1.0.0" displayName: "使用OpenChatBI代理進行自然語言商業智慧分析" summary: "當代理需要將業務問題轉化為SQL、圖表、異常分析和可解釋的商業智慧結果時，部署OpenChatBI。" license: "MIT" description: "當代理需要將業務問題轉化為SQL、圖表、異常分析和可解釋的商業智慧結果時，部署OpenChatBI。" github_stars: 595 verification: "security_reviewed" source: "https://github.com/1991513ccie-png/skills" author: "1991513ccie-png" publisher_type: "individual" category: "Data Extraction & Transformation" framework: "Multi-Framework" tool_ecosystem: github_repo: "1991513ccie-png/skills" github_stars: 595

使用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
• Extracted from upstream docs: https://raw.githubusercontent.com/zhongyu09/openchatbi/HEAD/README.md

Documentation

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

  小蔥技能7w4.net有完整的技能分類。

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