IT评测·应用市场-qidao123.com

标题: DB-GPT 当地部署数据分析场景 [打印本页]
作者: 东湖之滨    时间: 2024-7-16 14:50
标题: DB-GPT 当地部署数据分析场景
1.源码安装


https://github.com/eosphoros-ai/DB-GPT
官方文档：
DB-GPT · 语雀
  1. git:(main) ✗ git clone https://github.com/eosphoros-ai/DB-GPT.git
复制代码



2.复制设置文件

  1. cp .env.template  .env
复制代码
修改设置文件：
我这里用的yi api
  1. # 修改下面代码
  2. LLM_MODEL=yi_proxyllm
  4. ## Yi Proxyllm, https://platform.lingyiwanwu.com/docs
  5. YI_MODEL_VERSION=yi-34b-chat-0205
  6. YI_API_BASE=https://api.lingyiwanwu.com/v1
  7. YI_API_KEY=替换你的KEY
复制代码
3. 拉取模型

  1. (venv) ➜  DB-GPT git:(main) ✗ mkdir models & cd models
  3. (venv) ➜  models git:(main) ✗ git clone https://huggingface.co/GanymedeNil/text2vec-large-chinese
  5. (venv) ➜  models git:(main) ✗ du -d 1 -BM
  6. 6167M        ./text2vec-large-chinese
  7. 6167M        .
  8. (venv) ➜  models git:(main) ✗
复制代码
假如被屏蔽，用国内镜像下载：
https://hf-mirror.com/
4.安装依赖包

  1. (venv) ➜  models git:(main) ✗ pip install  -e ".[openai]"                                                                                       
复制代码
5.当地脚本启动

  1. (venv) ➜  DB-GPT git:(main) ✗ python dbgpt/app/dbgpt_server.py
  4. =========================== WebServerParameters ===========================
  6. host: 0.0.0.0
  7. port: 5670
  8. daemon: False
  9. controller_addr: None
  10. model_name: yi_proxyllm
  11. share: False
  12. remote_embedding: False
  13. remote_rerank: False
  14. log_level: INFO
  15. light: False
  16. log_file: dbgpt_webserver.log
  17. tracer_file: dbgpt_webserver_tracer.jsonl
  18. tracer_storage_cls: None
  19. disable_alembic_upgrade: False
  20. awel_dirs: None
  21. default_thread_pool_size: None
  23. ======================================================================
  26. , llm client class: <class 'dbgpt.model.proxy.llms.yi.YiLLMClient'>
  27. INFO:     127.0.0.1:40706 - "POST /api/controller/models HTTP/1.1" 200 OK
  28. INFO:     127.0.0.1:40720 - "POST /api/controller/models HTTP/1.1" 200 OK
  29. begin run _add_app_startup_event
  30. 2024-06-04 21:04:07 nile dbgpt.datasource.manages.connect_config_db[2963527] INFO Result: <sqlalchemy.engine.cursor.CursorResult object at 0x7ef92c111660>
  31. /home/nile/data2/agents_wk/DB-GPT/venv/lib/python3.10/site-packages/pydantic/_internal/_fields.py:160: UserWarning: Field "model_name" has conflict with protected namespace "model_".
  33. You may be able to resolve this warning by setting `model_config['protected_namespaces'] = ()`.
  34.   warnings.warn(
  35. 2024-06-04 21:04:08 nile dbgpt.storage.vector_store.connector[2963527] INFO VectorStore:<class 'dbgpt.storage.vector_store.chroma_store.ChromaStore'>
  36. 2024-06-04 21:04:08 nile chromadb.api.segment[2963527] INFO Collection langchain is not created.
  37. 2024-06-04 21:04:08 nile dbgpt.storage.vector_store.chroma_store[2963527] INFO Check persist_dir: /home/nile/data2/agents_wk/DB-GPT/pilot/data/rag_flow_profile.vectordb
  38. 2024-06-04 21:04:08 nile dbgpt.rag.summary.db_summary_client[2963527] INFO Vector store name rag_flow_profile exist
  39. 2024-06-04 21:04:08 nile dbgpt.rag.summary.db_summary_client[2963527] INFO initialize db summary profile success...
  40. 2024-06-04 21:04:08 nile dbgpt.rag.summary.db_summary_client[2963527] INFO db summary embedding success
复制代码
6.web


7.测试数据下载

链接: https://pan.baidu.com/s/1ZILia9paCRd_HN7zk8s1xQ?pwd=2cki
提取码: 2cki 
 
8.导入数据到mysql





9.分析数据







免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。



欢迎光临 IT评测·应用市场-qidao123.com (https://dis.qidao123.com/) Powered by Discuz! X3.4