自托管需按官方文档分步部署,README 未提供一键启动命令;需自行准备 LLM 等模型服务凭据;从 v1 升级到 v2 需参考迁移指南
JamAIBase
EmbeddedLLMApache-2.0活跃维护把电子表格变成 AI 流水线:在单元格里串联提示词和模型,实时对比 LLM 输出,多人协作迭代 AI 应用。
The collaborative spreadsheet for AI. Chain cells into powerful pipelines, experiment with prompts and models, and evaluate LLM responses in real-time. Work together seamlessly to build and iterate on AI applications.
README 未给出具体安装命令,仅指向自托管部署文档 https://docs.jamaibase.com/sdk/python-sdk-documentation#ossREADME 未说明
开源 RAG 后端平台,用电子表格式 UI 和 REST API 编排 LLM 流水线
把电子表格变成 AI 流水线:在单元格里串联提示词和模型,实时对比 LLM 输出,多人协作迭代 AI 应用。
核心能力
- 用电子表格式 UI 定义列并链式调用 LLM
- 内置 SQLite 与 LanceDB 向量库管理记忆和检索
- 内置 LLM、向量嵌入与重排器编排
- 提供 REST API 端点供应用集成
- 支持查询改写、混合检索与自适应分块
容易踩的坑
- v0.4v0.4 (2025-02-14)最新正式版2025-02-13 · 2025-02-13 16:58 UTC
What's Changed (v0.4)
This is a huge release 🚀
✨ Main features:
- Python Code Execution: Unlock powerful data manipulation directly within JamAIBase workflows with Python code execution in backend
GenTablecolumns and Python SDKCodeGenConfig. - Audio Data Type Support: JamAIBase now natively supports audio data, allowing you to work with
audiodata type in UI tables and process audio in backendGenTable. - Enhanced Chat Mode: Experience smoother chat interactions with the new multi-turn chat option in UI column settings.
- Function Calling for LLMs: Extend LLM capabilities with function calling support in the backend.
- DeepSeek Model Support: Expand your LLM options with integration of DeepSeek models.
- Improved File Handling: Benefit from audio file upload support and configurable file upload size limits for various file types.
- UI/UX Improvements: Enjoy enhanced column management, improved export options, security enhancements, and bug fixes in the UI.
⚠️ There are several breaking changes and deprecations as well, some highlights are listed here, see CHANGELOG for a complete list:
- Backend (GenTable) - Breaking: Add
Pagecolumn to knowledge table. - Backend (GenTable) - Breaking: Change
filedata type toimagedata type.
Upgrade to v0.4 today to take advantage of these exciting new features and improvements!
We encourage you to explore the new features and provide feedback. Thank you for being a part of the JamAIBase community!
Contributors
- @Hoipang
- @deafnv
- @haoshan98
- @kamil-hassan201
- @noobHappylife
- @jiahuei
Full Changelog: https://github.com/EmbeddedLLM/JamAIBase/compare/v0.3.1...v0.4
- Python Code Execution: Unlock powerful data manipulation directly within JamAIBase workflows with Python code execution in backend
- v0.3.1v0.3.1 (2024-11-26)2024-11-26 · 2024-11-26 16:34 UTC
查看更新说明
Bug Fix
This is a bug fix release for frontend code to enable Projects for OSS. SDKs are not affected.
What's Changed (v0.3)
This is a huge release 🚀
Main features:
- Multimodal image input column: Now you can insert an image alongside text as input to LLMs
- OSS now supports multiple projects: You are now able to create projects to manage your tables and files
- Added ability to turn any column into multi-turn chat via the
multi_turnparameter inLLMGenConfig - Added default prompts when creating Generative Tables: Setup time from table creation to running worlflows is now even shorter.
- Support for search query when listing projects, tables, rows
- Table and project import and export
- Various improvements to backend and frontend
There are several breaking changes and deprecations as well, some highlights are listed here, see CHANGELOG for a complete list:
- Added
versionandmetato table metadata. Please run the provided migration script to upgrade your existing DB files. - Delete endpoints will return 404 if resource is not found
/v1/gen_tables/{table_type}/{table_id}/threadhas one new required query parameter:column_id- Table list endpoint now defaults to not counting table rows
- Output columns must be string type
- Deprecations:
- Endpoint
/v1/gen_tables/{table_type}/duplicate/{table_id_src}/{table_id_dst}
- Endpoint
New Contributors
- @zec0816
- @Hoipang
- @Jiaqi0602
Contributors
- @deafnv
- @haoshan98
- @kamil-hassan201
- @noobHappylife
- @jiahuei
Full Changelog
https://github.com/EmbeddedLLM/JamAIBase/compare/v0.2...v0.3.1
- v0.3v0.3 (2024-11-20)2024-11-21 · 2024-11-21 13:23 UTC
查看更新说明
What's Changed
This is a huge release 🚀
Main features:
- Multimodal image input column: Now you can insert an image alongside text as input to LLMs
- OSS now supports multiple projects: You are now able to create projects to manage your tables and files
- Added ability to turn any column into multi-turn chat via the
multi_turnparameter inLLMGenConfig - Added default prompts when creating Generative Tables: Setup time from table creation to running worlflows is now even shorter.
- Support for search query when listing projects, tables, rows
- Table and project import and export
- Various improvements to backend and frontend
There are several breaking changes and deprecations as well, some highlights are listed here, see CHANGELOG for a complete list:
- Added
versionandmetato table metadata. Please run the provided migration script to upgrade your existing DB files. - Delete endpoints will return 404 if resource is not found
/v1/gen_tables/{table_type}/{table_id}/threadhas one new required query parameter:column_id- Table list endpoint now defaults to not counting table rows
- Output columns must be string type
- Deprecations:
- Endpoint
/v1/gen_tables/{table_type}/duplicate/{table_id_src}/{table_id_dst}
- Endpoint
New Contributors
- @zec0816
- @Hoipang
Contributors
- @deafnv
- @haoshan98
- @kamil-hassan201
- @noobHappylife
- @jiahuei
Full Changelog
https://github.com/EmbeddedLLM/JamAIBase/compare/v0.2...v0.3
- v0.2.1-python[Python] v0.2.1 (2024-08-18)2024-08-18 · 2024-08-18 06:17 UTC
查看更新说明
What's Changed
- [Python] jamaibase: Bug fix: Table type is now correctly handled in Python > 3.10 by @jiahuei in https://github.com/EmbeddedLLM/JamAIBase/pull/18
Full Changelog: https://github.com/EmbeddedLLM/JamAIBase/compare/v0.2...v0.2.1-python
- v0.2v0.2 (2024-07-23)2024-07-23 · 2024-07-23 09:48 UTC
查看更新说明
What's Changed
This is a feature-packed release! Some of highlights include:
- New "Embeddings" endpoint to generate vector embeddings for texts
- Methods for importing and exporting table data via CSV or TSV
- Ability to filter table rows when listing them by searching for keywords
- Vastly reduced dependency list for Python SDK
- Many other bug fixes and improvements
New Contributors
- @eltociear made their first contribution in https://github.com/EmbeddedLLM/JamAIBase/pull/9
- @Jiaqi0602
- @wenjielee11
Contributors
- @deafnv
- @haoshan98
- @iAmir97
- @jiahuei
- @kamil-hassan201
- @noobHappylife
- @tjtanaa
Full Changelog
https://github.com/EmbeddedLLM/JamAIBase/compare/v0.1...v0.2
用户点评
登录用户的真实使用记录,可按版本和硬件筛选还没有人点评。第一个说出真实体验的人最有价值。
JamAI Base

[!TIP] Explore our docs
Overview
JamAI Base is an open-source RAG (Retrieval-Augmented Generation) backend platform that integrates an embedded database (SQLite) and an embedded vector database (LanceDB) with managed memory and RAG capabilities. It features built-in LLM, vector embeddings, and reranker orchestration and management, all accessible through a convenient, intuitive, spreadsheet-like UI and a simple REST API.

Migration Guide from v1 to v2
Refer to Migration Guide
Key Features
- Embedded database (SQLite) and vector database (LanceDB)
- Managed memory and RAG capabilities
- Built-in LLM, vector embeddings, and reranker orchestration
- Intuitive spreadsheet-like UI
- Simple REST API
Generative Tables
Transform static database tables into dynamic, AI-enhanced entities.
- Dynamic Data Generation: Automatically populate columns with relevant data generated by LLMs.
- Built-in REST API Endpoint: Streamline the process of integrating AI capabilities into applications.
Action Tables
Facilitate real-time interactions between the application frontend and the LLM backend.
- Real-Time Responsiveness: Provide a responsive AI interaction layer for applications.
- Automated Backend Management: Eliminate the need for manual backend management of user inputs and outputs.
- Complex Workflow Orchestration: Enable the creation of sophisticated LLM workflows.
Knowledge Tables
Act as repositories for structured data and documents, enhancing the LLM’s contextual understanding.
- Rich Contextual Backdrop: Provide a rich contextual backdrop for LLM operations.
- Enhanced Data Retrieval: Support other generative tables by supplying detailed, structured contextual information.
- Efficient Document Management: Enable uploading and synchronization of documents and data.
Chat Tables
Simplify the creation and management of intelligent chatbot applications.
- Intelligent Chatbot Development: Simplify the development and operational management of chatbots.
- Context-Aware Interactions: Enhance user engagement through intelligent and context-aware interactions.
- Seamless Integration: Integrate with Retrieval-Augmented Generation (RAG) to utilize content from any Knowledge Table.
LanceDB Integration
Efficient management and querying of large-scale multi-modal data.
- Optimized Data Handling: Store, manage, query, and retrieve embeddings on large-scale multi-modal data efficiently.
- Scalability: Ensure optimal performance and seamless scalability.
Declarative Paradigm
Focus on defining "what" you want to achieve rather than "how" to achieve it.
- Simplified Development: Allow users to define relationships and desired outcomes.
- Non-Procedural Approach: Eliminate the need to write procedures.
- Functional Flexibility: Support functional programming through LLMs.
Key Benefits
Ease of Use
- Interface: Simple, intuitive spreadsheet-like interface.
- Focus: Define data requirements through natural language prompts.
Scalability
- Foundation: Built on LanceDB, an open-source vector database designed for AI workloads.
- Performance: Serverless design ensures optimal performance and seamless scalability.
Flexibility
- LLM Support: Supports any LLMs, including OpenAI GPT-4, Anthropic Claude 3, and Meta Llama3.
- Capabilities: Leverage state-of-the-art AI capabilities effortlessly.
Declarative Paradigm
- Approach: Define the "what" rather than the "how."
- Simplification: Simplifies complex data operations, making them accessible to users with varying levels of technical expertise.
Innovative RAG Techniques
- Effortless RAG: Built-in RAG features, no need to build the RAG pipeline yourself.
- Query Rewriting: Boosts the accuracy and relevance of your search queries.
- Hybrid Search & Reranking: Combines keyword-based search, structured search, and vector search for the best results.
- Structured RAG Content Management: Organizes and manages your structured content seamlessly.
- Adaptive Chunking: Automatically determines the best way to chunk your data.
- BGE M3-Embedding: Leverages multi-lingual, multi-functional, and multi-granular text embeddings for free.
Getting Started
Option 1: Use the JamAI Base Cloud
Sign up for a free account! Did we mention that you can get free LLM tokens?
Option 2: Launch self-hosted services
Follow our step-by-step guide.
Explore the Documentation:
Examples
Want to try building apps with JamAI Base? We've got some awesome examples to get you started! Check out our example docs for inspiration.
Here are a couple of cool frontend examples:
- Simple Chatbot Bot using NLUX: Build a basic chatbot without any backend setup. It's a great way to dip your toes in!
- Simple Chatbot Bot using NLUX + Express.js: Take it a step further and add some backend power with Express.js.
- Simple Chatbot Bot using Streamlit: Are you a Python dev? Checkout this Streamlit demo!
Let us know if you have any questions – we're here to help! Happy coding! 😊
Community and Support
Join our vibrant developer community for comprehensive documentation, tutorials, and resources:
- Discord: Join our Discord
- GitHub: Star our GitHub repository
Contributing
We welcome contributions! Please read our Contributing Guide to get started.
License
This project is released under the Apache 2.0 License. - see the LICENSE file for details.