Skip to content

0.0.1 - First beta version of OpenChatBI

Choose a tag to compare

@zhongyu09 zhongyu09 released this 25 Sep 04:09
· 60 commits to main since this release

This is the first release of OpenChatBI beta version 0.0.1!

Introduction

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. Built on LangGraph and LangChain ecosystem,
it provides chat agents and workflows that support natural language to SQL conversion and streamlined data analysis.

Demo

Core Features

  1. Natural Language Interaction: Get data analysis results by asking questions in natural language
  2. Automatic SQL Generation: Convert natural language queries into SQL statements using advanced text2sql workflows
    with schema linking and well organized prompt engineering
  3. Data Visualization: Generate intuitive data visualizations (via plotly)
  4. Data Catalog Management: Automatically discovers and indexes database table structures, supports flexible catalog
    storage backends, and easily maintains business explanations for tables and columns as well as optimizes Prompts.
  5. Knowledge Base Integration: Answer complex questions by combining catalog based knowledge retrival and external
    knowledge base retrival (via MCP tools)
  6. Code Execution: Execute Python code for data analysis and visualization
  7. Interactive Problem-Solving: Proactively ask users for more context when information is incomplete
  8. Persistent Memory: Conversation management and user characteristic memory based on LangGraph checkpointing
  9. MCP Support: Integration with MCP tools by configuration
  10. Web UI Interface: Provide 2 sample UI: simple and streaming web interfaces using Gradio and Streamlit, easy to
    integrate with other web applications

Full Changelog: https://github.com/zhongyu09/openchatbi/commits/v0.0.1