Design
diagrams
:art: Diagram as Code for prototyping cloud system architectures
★ 42.7k starsMIT
View guide →// design · zhongyu09/openchatbi
openchatbi
openchatbi is an open-source design project by zhongyu09 (zhongyu09/openchatbi on GitHub). It has 658 GitHub stars and 92 forks, is released under the MIT license, and was last updated on GitHub on 1 October 2026.
Chat with your data — natural-language BI with SQL generation
💎 Hidden gem★ 658 stars⑂ 92 forksMITupdated 2026-10
▦ visual — this project's README ships no embeddable screenshot,
so here's a placeholder. The guide below is complete regardless.
so here's a placeholder. The guide below is complete regardless.
// project facts
Project facts
- Repository
- zhongyu09/openchatbi
- GitHub stars
- 658
- Forks
- 92
- License
- MIT
- Last updated on GitHub
- 1 October 2026
- Category
- Design
- Listing
- Hidden gem — a shorter page for a lesser-known project
- Official site
- Official site
// how it works
How it works
- Deploy OpenChatBI
Connect it to your databases.
- Ask in plain words
Type the question you want answered.
- Get SQL and charts
The agent queries and visualizes.
- Dig deeper
Follow up conversationally.
// features
Why people love it
Natural language
Ask questions, get answers.
Text-to-SQL
Automatic query generation.
Visualizations
Charts from your data.
LangGraph agents
Robust agent workflows.
Anomaly detection
Spot outliers automatically.
MIT licensed
Free for commercial use with attribution.
Advertisement
// run it
Run it yourself
- Step 1 — Clone the repo
Download the source and move into the project folder.
git clone https://github.com/zhongyu09/openchatbi.git cd openchatbi - Step 2 — Check the README
Every project documents its own setup; start with install requirements.
cat README.md | head -60 - Step 3 — Run it
Follow the project's launch command — Docker, pip, npm, or a binary release.
# see README for the exact launch command
// use cases
What you can build
- Query databases without writing SQL.
- Build dashboards conversationally.
- Detect anomalies in business data.
- Give non-technical teams self-serve BI.
Advertisement
// faq
Questions, answered
Who maintains openchatbi?
It is an open-source project at zhongyu09/openchatbi with 162 forks. Check the repo's contributors and recent commits to see how active maintenance is.
Is openchatbi free for commercial use?
MIT licensed — commercial use allowed with attribution.
Which databases work?
It is built for popular databases — check the README for the list.
How accurate is the SQL?
LLM-generated SQL needs review, like any text-to-SQL tool.
Is my data private?
You self-host it, so data stays in your infrastructure.
// keep exploring
Similar tools
Design
drawnix
开源白板工具（SaaS），一体化白板，包含思维导图、流程图、自由画等。All in one open-source whiteboard tool with mind, flowchart, freehand and etc.
★ 14.9k starsMIT
View guide →Design
whiteboard
open-source canvas for thoughtful software design
★ 2.7k starsMIT
View guide →Design
paperbanana
PaperBanana — agentic generation of publication-quality academic figures, diagrams and plots from text
★ 2.4k starsMIT
View guide →Design
ainativelang
AI-native programming language for structured, repeatable agent workflows
★ 650 starsApache-2.0
View guide →Design
GrapesJS
Free and Open source Web Builder Framework. Next generation tool for building templates without coding
★ 26.3k starsCustom (check repo)
View guide →// alternatives
Alternatives in Design
The most-starred other Design projects in the LibreAI catalogue — the realistic shortlist if openchatbi is not the right fit.
- Excalidraw★ 134.0k
Excalidraw — the virtual whiteboard with the hand-drawn look: infinite canvas, real-time collaboration and end-to-end encrypted sharing, MIT-licensed
- Screenshot To Code★ 80.0k
Drop in a screenshot and convert it to clean code (HTML/Tailwind/React/Vue)
- archify★ 79.8k
Turn any idea, plan or codebase into a beautiful interactive architecture diagram — an agent skill
- AFFiNE★ 73.2k
There can be more than Notion and Miro. AFFiNE(pronounced [ə‘fain]) is a next-gen knowledge base that brings planning, sorting and creating all together. Pri…
- draw.io Desktop★ 63.6k
draw.io Desktop — the official offline desktop app for diagrams.net: flowcharts, architecture diagrams and wireframes in an Electron app that never sends your diagram data anywhere, GPL-3.0
// more in design
More in Design
Nearby Design projects in the catalogue, closest in stars to openchatbi — keep exploring the shelf either side of it.
- pm-skills★ 708
68 plug-and-play product management skills for AI agents
- ainativelang★ 650
AI-native programming language for structured, repeatable agent workflows
- gen-ai-experiments★ 785
Jupyter notebook guide to AI tools and technologies, experiment by experiment
- kangaroo★ 518
AI-powered SQL client and admin tool for every popular database
- free-ai-resources-x★ 914
Curated collection of free AI tools, APIs, datasets and learning resources
- structurizr★ 429
Models-as-code tool for the C4 software architecture model
Get openchatbi
Free and open — grab the source, star the repo, and start creating.