Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: dataease/SQLBot
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: main
Choose a base ref
...
head repository: nemo1991/SQLBot
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: main
Choose a head ref
Checking mergeability… Don’t worry, you can still create the pull request.
  • 3 commits
  • 24 files changed
  • 2 contributors

Commits on Aug 13, 2026

  1. feat: support MongoDB as a queryable datasource 

    ChatBI can now answer questions against MongoDB datasources by generating
and executing aggregation pipelines, mirroring the Elasticsearch DSL flow:
- LLM outputs a pipeline JSON (collection + stages) stored in the record's
  sql field and executed via pymongo (backend/apps/db/mongo_engine.py)
- add MongoDB template teaching pipeline JSON output
- register mongo type in DB enum, db.py dispatch, db_sql helpers, and
  datasource preview/field-enum/sample-data branches
- frontend datasource form, type list and icon for MongoDB
- fix UnboundLocalError in get_table_sample_data (function-local
  import json shadowed the module on the mongo branch)
- harden check_sql so non-query answers (e.g. table-structure overview)
  degrade gracefully instead of "Cannot parse sql from answer"

Co-Authored-By: Claude <noreply@anthropic.com>
    @nemo1991 @claude
    nemo1991 and claude committed Aug 13, 2026
    Configuration menu
    Copy the full SHA
    b8b35a7 View commit details
    Browse the repository at this point in the history

  2. feat: add Ollama as a model supplier 

    Allow configuring models running on a local Ollama instance:
- supplier entry (id 16, is_private, default http://127.0.0.1:11434/v1)
- new GET /system/aimodel/ollama/models endpoint that lists models from
  {root}/api/tags (admin-only)
- "Fetch local models" button in the model form populates the dropdown
- show API domain before a model is selected so the address is
  configurable first
- i18n keys for zh-CN/en/zh-TW/ko-KR

Co-Authored-By: Claude <noreply@anthropic.com>
    @nemo1991 @claude
    nemo1991 and claude committed Aug 13, 2026
    Configuration menu
    Copy the full SHA
    df0b91a View commit details
    Browse the repository at this point in the history

  3. feat: adapt Q&A flow for MongoDB aggregation pipeline datasource 

    - sql_sys_question/sql_user_question: support per-db template overrides with base fallback
- MongoDB.yaml: add NoSQL system/generate_rules/user/process_check prompts, schema-overview chat example, and exact field-name rule
- check_sql: assemble mongo pipeline from aggregation_pipeline/collection_name when model omits success/sql contract; build complete no-query message from description+schema_details
- run_task/run_analysis_or_predict_task: suppress full traceback for graceful SingleMessageError answers
- datasource schema/sample data rendered as # Collection: for mongo

Co-Authored-By: Claude <noreply@anthropic.com>
    @nemo1991 @claude
    nemo1991 and claude committed Aug 13, 2026
    Configuration menu
    Copy the full SHA
    c270ac6 View commit details
    Browse the repository at this point in the history
Loading
⌂ Proxy