OpenChatBI is an open-source chat-based intelligent BI tool powered by large language models, designed to help users query, analyze, and visualize data through natural language conversations.
One-Minute Overview#
OpenChatBI is an open-source chat-based intelligent BI tool that enables users to interact with data through natural language conversations, automatically generating SQL queries, analyzing data, and creating visualizations.
Core Value: Automates the entire data analysis process from query to visualization through natural language conversation
Getting Started#
Installation Difficulty: Medium - Requires Python environment and LLM API access, but configuration is straightforward
git clone git@github.com:zhongyu09/openchatbi
uv sync
Core Capabilities#
1. Natural Language Query Conversion - Lowering Data Analysis Barriers#
- Automatically converts natural language questions into accurate SQL query statements
2. Data Visualization - Intuitive Analysis Presentation#
- Automatically generates Plotly visualization charts to display analysis results
3. Data Catalog Management - Understanding Data Assets#
- Automatically discovers and indexes database table structures with vector or BM25 retrieval
4. Persistent Memory - Contextual Consistency#
- Conversation management and user feature memory based on LangGraph checkpoints
5. Time Series Forecasting - Forward-Looking Analysis#
- Built-in time series forecasting models available as tools