ChatBI is an AI-powered Business Intelligence system that allows users to analyze data through natural language conversations. It targets data analysts and business users seeking an intuitive way to explore and visualize data without extensive SQL or BI tool expertise. The system leverages Large Language Models (LLMs) for data interaction and AVA for visualization.

How It Works

ChatBI integrates with various LLMs, including OpenAI, Tongyi Qianwen, and DeepSeek, enabling conversational data analysis. It uses Ant Design X for its chat interface and AVA for data visualization, providing a user-friendly experience for querying and presenting data insights.

Quick Start & Requirements

• Server: Python 3.10+ and uv package manager.
• Client: Node.js 18+ and pnpm.
• Database: PostgreSQL (or MySQL via Docker).
• LLM: OpenAI API Key or Aliyun Lingji configuration.
• Installation:
  • Install server dependencies: pnpm install (after setting up .env).
  • Start server: make dev-server.
  • Start client: make dev-client.
• Access: http://localhost:8001
• Docs: OpenAI API Key, Node.js Installation, uv Installation, Aliyun Lingji

Highlighted Details

• Supports multiple LLM providers (OpenAI, Tongyi Qianwen, DeepSeek).
• Utilizes Ant Design X for the chat UI.
• Employs AVA for data visualization.
• Client API definitions are auto-generated from OpenAPI specs.

Maintenance & Community

• Project is open-source under GPL-3.0.
• Sponsorships are welcomed.

Licensing & Compatibility

• License: GPL-3.0.
• Compatibility: The GPL-3.0 license is copyleft, meaning derivative works must also be open-sourced under the same license. This may restrict commercial use or integration into closed-source proprietary systems without careful consideration.

Limitations & Caveats

The project requires setting up both Python and Node.js environments, along with LLM API keys and potentially a database. The GPL-3.0 license imposes significant restrictions on commercial use and integration with proprietary software.