DB-GPT 本地部署数据分析场景

1.源码安装

• 版本：0.5.7
• python版本：3.10.12
• llm api: yi model

https://github.com/eosphoros-ai/DB-GPT

官方文档：

DB-GPT · 语雀

git:(main) ✗ git clone https://github.com/eosphoros-ai/DB-GPT.git

2.复制配置文件

cp .env.template  .env

修改配置文件：

我这里用的yi api

# 修改下面代码 LLM_MODEL=yi_proxyllm  ## Yi Proxyllm, https://platform.lingyiwanwu.com/docs YI_MODEL_VERSION=yi-34b-chat-0205 YI_API_BASE=https://api.lingyiwanwu.com/v1 YI_API_KEY=替换你的KEY

3. 拉取模型

(venv) ➜  DB-GPT git:(main) ✗ mkdir models & cd models  (venv) ➜  models git:(main) ✗ git clone https://huggingface.co/GanymedeNil/text2vec-large-chinese  (venv) ➜  models git:(main) ✗ du -d 1 -BM 6167M	./text2vec-large-chinese 6167M	. (venv) ➜  models git:(main) ✗  

如果被屏蔽，用国内镜像下载：

https://hf-mirror.com/

4.安装依赖包

(venv) ➜  models git:(main) ✗ pip install  -e ".[openai]"                                                                                        

5.本地脚本启动

(venv) ➜  DB-GPT git:(main) ✗ python dbgpt/app/dbgpt_server.py   =========================== WebServerParameters ===========================  host: 0.0.0.0 port: 5670 daemon: False controller_addr: None model_name: yi_proxyllm share: False remote_embedding: False remote_rerank: False log_level: INFO light: False log_file: dbgpt_webserver.log tracer_file: dbgpt_webserver_tracer.jsonl tracer_storage_cls: None disable_alembic_upgrade: False awel_dirs: None default_thread_pool_size: None  ======================================================================   , llm client class: <class 'dbgpt.model.proxy.llms.yi.YiLLMClient'> INFO:     127.0.0.1:40706 - "POST /api/controller/models HTTP/1.1" 200 OK INFO:     127.0.0.1:40720 - "POST /api/controller/models HTTP/1.1" 200 OK begin run _add_app_startup_event 2024-06-04 21:04:07 nile dbgpt.datasource.manages.connect_config_db[2963527] INFO Result: <sqlalchemy.engine.cursor.CursorResult object at 0x7ef92c111660> /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_".  You may be able to resolve this warning by setting `model_config['protected_namespaces'] = ()`.   warnings.warn( 2024-06-04 21:04:08 nile dbgpt.storage.vector_store.connector[2963527] INFO VectorStore:<class 'dbgpt.storage.vector_store.chroma_store.ChromaStore'> 2024-06-04 21:04:08 nile chromadb.api.segment[2963527] INFO Collection langchain is not created. 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 2024-06-04 21:04:08 nile dbgpt.rag.summary.db_summary_client[2963527] INFO Vector store name rag_flow_profile exist 2024-06-04 21:04:08 nile dbgpt.rag.summary.db_summary_client[2963527] INFO initialize db summary profile success... 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.分析数据