openchatbi

Overview of openchatbi

What it is

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. It is built on the LangGraph and LangChain ecosystem, providing chat agents and workflows that support natural language to SQL conversion and streamlined data analysis.

Key features

• Natural Language Interaction: Get data analysis results by asking questions in natural language - Automatic SQL Generation: Convert natural language queries into SQL statements using advanced text2sql workflows with schema linking and prompt engineering - Data Visualization: Generate intuitive data visualizations via plotly - Data Catalog Management: Automatically discovers and indexes database table structures, supports flexible catalog storage backends with vector-based or BM25-based retrieval - Time Series Forecasting: In-house forecasting models accessed through the data analysis agent - Code Execution: Execute Python code for data analysis and visualization - Interactive Problem-Solving: Proactively ask users for more context when information is incomplete

Use cases

• Querying databases using natural language - Generating automated data visualizations and reports - Performing time series forecasting and trend analysis - Conducting anomaly detection and root cause analysis - Integrating with knowledge bases to answer complex questions

Getting started

bash git clone [email protected]:zhongyu09/openchatbi uv sync cp example/config.yaml openchatbi/config.yaml sed -i 's/YOUR_API_KEY_HERE/[YOUR OPENAI API KEY]/g' openchatbi/config.yaml python run_streamlit_ui.py

License and pricing

License: MIT. Open source (free to use).

Based on the project's public README and repository metadata.