Repolode
Submit
apconw

apconw/Aix-DB

Open-source ChatBI tool that turns natural-language questions into SQL queries, charts and data insights, built on LangChain/LangGraph with MCP-based multi-agent workflows.

View on GitHubWebsite
Stars
2,255
Forks
434
Open issues
3
Last commit
12 days ago

What is it?

Aix-DB is a conversational data analysis system that lets users ask questions in natural language and receive query results, tables and visualizations. It combines an LLM-driven Text2SQL engine with RAG retrieval over table structures and business knowledge, using Embedding plus BM25 hybrid search and an optional Neo4j graph to find relevant schema.

The project covers the full path from question to chart: intent parsing, SQL generation with syntax checks, execution against the target database, and automatic rendering with ECharts or AntV. It supports MySQL, PostgreSQL, Oracle, SQL Server, ClickHouse, Doris, StarRocks and CSV/Excel sources, and includes a Vue 3 web interface, a Sanic API with JWT authentication, and a command-line client.

It can be deployed with Docker or Docker Compose, and also supports a Skill mode and integration with OpenClaw. A separate commercial edition adds dashboards and a report center.

Key features

  • 01Converts natural-language questions into SQL and executes them against connected databases.
  • 02Uses hybrid Embedding and BM25 retrieval, with optional Neo4j graph context, to locate relevant schema.
  • 03Automatically generates ECharts or AntV charts from query results.
  • 04Supports MySQL, PostgreSQL, Oracle, SQL Server, ClickHouse, Doris, StarRocks, CSV and Excel sources.
  • 05Provides a Vue 3 web UI, a Sanic API with JWT authentication, and a CLI client.

Use cases

  • Letting business users query operational databases without writing SQL.
  • Adding a chat-based BI assistant to an internal data platform.
  • Running quick data lookups and trend charts from a terminal with the CLI.

Topics

#text2sql#chatbi#langchain#langgraph#mcp#data-visualization#llm#rag#bigdata#cli

FAQ

What is Aix-DB?
Open-source ChatBI tool that turns natural-language questions into SQL queries, charts and data insights, built on LangChain/LangGraph with MCP-based multi-agent workflows. Aix-DB is a conversational data analysis system that lets users ask questions in natural language and receive query results, tables and visualizations. It combines an LLM-driven Text2SQL engine with RAG retrieval over table structures and business knowledge, using Embedding plus BM25 hybrid search and an optional Neo4j graph to find relevant schema.
Is Aix-DB free to use? What license does it have?
Aix-DB has no declared license. Its code is public, but without a license you have no explicit permission to reuse it; ask the author before relying on it.
Is Aix-DB still maintained?
Actively maintained. The last commit to Aix-DB was on Oct 10, 2026.
What can I use Aix-DB for?
Letting business users query operational databases without writing SQL. Adding a chat-based BI assistant to an internal data platform. Running quick data lookups and trend charts from a terminal with the CLI.
Where can I get Aix-DB?
The source code and installation instructions are on GitHub: https://github.com/apconw/Aix-DB

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects