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.

v0.4发布于 2025-02-13 16:58 UTC1,104star48fork同步于 2026-11-10 05:56 UTC

怎么上手

由 README 提炼,执行前请确认
README 未给出具体安装命令,仅指向自托管部署文档 https://docs.jamaibase.com/sdk/python-sdk-documentation#oss
硬件要求按 README 说明

README 未说明

支持 Apple Silicon
下载:源码 zip·GitHub Releases(安装包)本站不镜像安装包

项目说明

由 README 自动翻译提炼

开源 RAG 后端平台,用电子表格式 UI 和 REST API 编排 LLM 流水线

把电子表格变成 AI 流水线:在单元格里串联提示词和模型,实时对比 LLM 输出,多人协作迭代 AI 应用。

核心能力

  • 用电子表格式 UI 定义列并链式调用 LLM
  • 内置 SQLite 与 LanceDB 向量库管理记忆和检索
  • 内置 LLM、向量嵌入与重排器编排
  • 提供 REST API 端点供应用集成
  • 支持查询改写、混合检索与自适应分块

容易踩的坑

自托管需按官方文档分步部署,README 未提供一键启动命令;需自行准备 LLM 等模型服务凭据;从 v1 升级到 v2 需参考迁移指南

内容由模型根据 README 生成,可能不完整或不准确,以官方文档为准。看原文 README

最近发版

5 个版本v0.4
  1. 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 GenTable columns and Python SDK CodeGenConfig.
    • Audio Data Type Support: JamAIBase now natively supports audio data, allowing you to work with audio data type in UI tables and process audio in backend GenTable.
    • 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 Page column to knowledge table.
    • Backend (GenTable) - Breaking: Change file data type to image data 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

  2. 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_turn parameter in LLMGenConfig
    • 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 version and meta to 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}/thread has 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}

    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

  3. 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_turn parameter in LLMGenConfig
    • 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 version and meta to 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}/thread has 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}

    New Contributors

    • @zec0816
    • @Hoipang

    Contributors

    • @deafnv
    • @haoshan98
    • @kamil-hassan201
    • @noobHappylife
    • @jiahuei

    Full Changelog

    https://github.com/EmbeddedLLM/JamAIBase/compare/v0.2...v0.3

  4. v0.2.1-python[Python] v0.2.1 (2024-08-18)2024-08-18 · 2024-08-18 06:17 UTC
    查看更新说明

    What's Changed

    Full Changelog: https://github.com/EmbeddedLLM/JamAIBase/compare/v0.2...v0.2.1-python

  5. 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

    Contributors

    • @deafnv
    • @haoshan98
    • @iAmir97
    • @jiahuei
    • @kamil-hassan201
    • @noobHappylife
    • @tjtanaa

    Full Changelog

    https://github.com/EmbeddedLLM/JamAIBase/compare/v0.1...v0.2

用户点评

登录用户的真实使用记录,可按版本和硬件筛选
共 0 条

    还没有人点评。第一个说出真实体验的人最有价值。

    README 原文

    未翻译

    JamAI Base

    JamAI Base Cover

    Linting CI

    [!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.

    JamAI Base Demo

    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:

    1. Simple Chatbot Bot using NLUX: Build a basic chatbot without any backend setup. It's a great way to dip your toes in!
    2. Simple Chatbot Bot using NLUX + Express.js: Take it a step further and add some backend power with Express.js.
    3. 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:

    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.

    Contact

    Follow us on X and LinkedIn for updates and news.