Repolode
Submit
dataease

dataease/SQLBot

Open-source ChatBI system that turns natural-language questions into SQL queries over your databases, using LLMs and RAG.

Open-source alternative to:Tableau

View on GitHubWebsite
Stars
6,944
Forks
903
Open issues
50
Last commit
4 hours ago

What is it?

SQLBot is a conversational data analysis system that lets users ask questions in natural language and get back query results and charts. It uses large language models together with retrieval-augmented generation (RAG) to convert questions into SQL (Text-to-SQL), and it can run further analysis on the returned data.

Setup requires configuring an LLM and a data source; it is deployed with Docker, and an offline installation package is available for air-gapped environments. The system includes workspace-level resource isolation and fine-grained data permissions. Behavior can be tuned with custom prompts, a terminology glossary, and SQL example entries.

SQLBot can be embedded in web pages or pop-up windows and exposed through MCP calls, and the project lists integrations with n8n, Dify, MaxKB and DataEase.

Key features

  • 01Converts natural-language questions into SQL using LLMs with RAG.
  • 02Returns query results and visualization charts in a chat interface.
  • 03Supports workspace-level isolation and fine-grained data permissions.
  • 04Customizable prompts, terminology glossary and SQL example calibration.
  • 05Embeddable via web widget, pop-up, or MCP calls.
  • 06Deployable with Docker, including an offline installation package.

Use cases

  • Letting business users query company databases without writing SQL.
  • Adding a natural-language data query assistant to existing tools like Dify or n8n.
  • Building internal ChatBI dashboards with permission-controlled data access.

Topics

#text-to-sql#llm#rag#chatbi#data-analysis#nl2sql#docker#deepseek#sqlbot#text2sql

FAQ

What is SQLBot?
Open-source ChatBI system that turns natural-language questions into SQL queries over your databases, using LLMs and RAG. SQLBot is a conversational data analysis system that lets users ask questions in natural language and get back query results and charts. It uses large language models together with retrieval-augmented generation (RAG) to convert questions into SQL (Text-to-SQL), and it can run further analysis on the returned data.
Is SQLBot free to use? What license does it have?
SQLBot is open source under the Other license. Check the license terms before using it in commercial products.
Is SQLBot still maintained?
Actively maintained. The last commit to SQLBot was on Oct 22, 2026.
What can I use SQLBot for?
Letting business users query company databases without writing SQL. Adding a natural-language data query assistant to existing tools like Dify or n8n. Building internal ChatBI dashboards with permission-controlled data access.
Where can I get SQLBot?
The source code and installation instructions are on GitHub: https://github.com/dataease/SQLBot

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

Related projects