deepinsight-ai / deepbi Goto Github PK

LLM based data scientist, AI native data application. AI-driven infinite thinking redefines BI.

Shell 0.82% Makefile 0.02% Python 39.16% HTML 2.09% JavaScript 35.82% CSS 2.24% Less 5.72% TypeScript 14.13%

csv gpt gpt-4 mysql redis ai analisis bi data llm

deepbi's Introduction

DeepBI

DeepBI is an AI-native data analysis platform. DeepBI leverages the power of large language models to explore, query, visualize, and share data from any data source. Users can use DeepBI to gain data insight and make data-driven decisions.

Languages： English 中文
Developer：[email protected] Business：[email protected]

If you think DeepBI is helpful to you, please help by clicking here on the ⭐ Star and Fork in the upper right corner. Your support is the greatest driving force for DeepBI to become better.

Video example

demo.mov

user manual

DeepBI user manual

✨ Features

1 Conversational data analysis: Users can get arbitrary data results and analysis results through dialogues.
2 Conversational query generation: Generates persistent queries and visualizations through dialogues.
3 Dashboard : Assemble persistent visualizations into dashboards.
4 Automated data analysis reports (to be developed) : Complete data analysis reports automatically according to user instructions.
5 Support multiple data sources, including MySQL, PostgreSQL, Doris, StarRocks, CSV/Excel, etc.
6 Multi-platform support, support Windows-WSL,Windows, Linux, Mac.
7 International, support Chinese, English.

🚀 Supported Databases

The database connections supported by DeepBI are:

MySQL
PostgreSQL
csv/Excel Import
Doris
StarRocks
MongoDB

📦 Windows exe installation

Download window_install_exe_EN.zip from the tag list.The current test supports Win10 and Win11
Unzip the zip package and double-click the.exe file to run DeepBI
Local installation instructions Installl exe

📦 Docker build

The local environment needs to have docker and docker-compose.
Installl docker
Download project files by git:git clone https://github.com/DeepInsight-AI/DeepBI.git
or drirect download zip file, unzip it.
Enter the project directory:cd DeepBI
Just run./Install.shdirectly
Default port: 8338 8339
Web access: http://ip:8338

DeepBI docker command

Enter project DeepBI dir:

    docker-compose start # start DeepBI servie
    docker-compose stop # stop DeepBI servie
    docker-compose ps # see DeepBI servie states

If it appears... PermissionError ... ' or ' Permission denied', please add 'sudo' before executing the command

    sudo docker-compose start # start DeepBI servie
    sudo docker-compose stop # stop DeepBI servie
    sudo docker-compose ps # see DeepBI servie states

Ubuntu build

Install directly on the ubuntu system, you need to install redis, postgresql python3.8.17 environment.

Redis can be accessed directly through the 127.0.0.1 password-free command line.
Require python version 3.8.x
Recommend using virtual environments such as pyenv coda
postgresql needs to install postgresql-16 version
Download the DeepBI code by the command

git clone https://github.com/DeepInsight-AI/DeepBI.git

If the download fails to replace the protocol, run the following code

git clone http://github.com/DeepInsight-AI/DeepBI.git

Just run . ubuntu_install.sh directly (note that you run . ubuntu_install.sh instead of sh xxx here, because you need to run the python virtual environment)
Default port is 8338 and 8339
Web access: http://ip:8338

Contact Us

📑 Other

We have tested on Mac OS 12.7/13.X /14.1.1, Ubuntu 20.04/22.04, and Windows11 WSL 22.04.
Windows 10 requires version 22H2 or higher to install WSL
The minimum memory requirement for server operation is 1 core 2G memory, and 2 core 4G memory is recommended
If you have any question, please contact us at [email protected]
Issue

deepbi's People

Contributors

Stargazers

Watchers

Forkers

syaikhipin axin2015 wholeworld-timothy friendmine jianjun159 gujincheng asanlittleboss yioyoiyioys222 ikechukwuabuah rivonsen softiger stophobia johnson7788 chenmingyi1 blueroutecn dm520 tel9980 zhch158 feibohr cxs86621 cnlitiejun alanshen1 lizhengli10086 qingzhongli wc99 webhxx ericsongyl n0wwa d3p10y bear1990jx maigone mrhx97 vamoko gaslights huangtianan closegoingaway lycokie juanlianren0515 hs991023 mistyr0se thatwho paramedick masemxiao zaku-zaku billionerd hisstar monsterdove s8xy aiaicaptain82 martincooperbiz luxinming tansy-tansy iam20cm tufo830 0x8235 molierflower jameschangz coder-drinker spicyguml fskeo dameng101 augiot luluchou obsidian6s tutuna dreddman yuweny1 windb3ll turbo-byte farmingtong e-kiss-me xupercoin wensiyuansix 305538436 jbluv moguijoe hay-man weizhang418 newcluge minisoco cerviny chuangyeshuo wushengyeyouya ntt720 taffar awekling nicbair piapplepi nanpusher klaymr excelisa ymzhang96 w90o0u isperfee hotafa kimyokang betterds xuzuoyun vgtom sixbanks

deepbi's Issues

Unable to find data to plot

Q:Which city in Beijing, Shanghai, Guangzhou, and Shenzhen is more active in terms of "virtual transaction quantity" and "virtual transaction unit price"?
Provided required fields for analysis and drawing failed, unable to find data

Initialization data encoding error in windows 11 home version exe1.2.1

Can the docker-compose.yml file be changed to version

Version: "2.0" is too old in the docker-compose.yml file. Can we change it to 2.0? If possible, we can propose a PR to fix this problem.

The pie chart does not display proper categorization

Issue Description:
I encountered a problem with the generation of pie charts in the reporting functionality. Specifically, when attempting to represent the number and percentage of male and female loan recipients, the pie chart does not display proper categorization.

Steps to Reproduce:
Navigate to the reporting section.
Ask：Represent the number and percentage of male and female loan recipients with a pie chart
Generate a pie chart.

Expected Behavior:
The pie chart should accurately represent the number and percentage of male and female loan recipients, providing a clear and distinct categorization.

Actual Behavior:
The generated pie chart lacks proper classification, making it challenging to discern the distribution of male and female loan recipients.

The English version of DeepBI contains Chinese text.

Set up the registration account for DeepBI in English text.

The API key testing prompt is in Chinese text.

Function {'task_base'} not found

There is a problem with drawing pictures for months and quarters

Q:How does spending behavior differ from month to month? Analyze it visually

Q:How does consumer behavior differ from quarter to quarter? Analyze it visually

There is no problem with the quarter drawing, but there is an error when drawing the month

Exception caused by empty report name

The report name generated by AI is empty and cannot be accessed by clicking or deleted.

When AI apikey is selected, openai should not display the recharge address

NameError: name 'df ' is not defined. I got this error, but I didn't ask any question with unknown database

Under the new server, the python version is not accurate

Unable to draw word clouds

Q：What is the distribution of click, favorite, add-on, and payment data? Represent and analyze with word clouds

Correlation between questioning indicators

Q：What is the relationship between the simulated transaction quantity (Virtual_transaction_quantity) and the suggested transaction price (Suggested_transaction_price)? And visually display it

Can't answer the question about the correlation between two indicators

Q:Is there a significant difference in the success rate of patent applications for different applicant types?

Ask if there is a difference between two indicators, calculate the relevant values, and it indicates that there is a significant difference, but the explanation is poor.

An encoding error will occur when the window exe installation file is installed on the system using US code 437

The consumption token record is more detailed

The consumption token record is more detailed,list the input cost tokens and the output cost tokens

Starrocks source usage problem

Table information cannot be displayed when using the Starrocks database source

The scale setting of the generated graph is unreasonable

The maximum value of data in the image does not exceed 0.2M, resulting in low utilization of the image and unclear differences in image data

The windows task log displays a coding error

It should be stopped when the installation is wrong, and it will not stop halfway

Designing multi category drawings in reports can lead to errors

(Report dialogue) Use a bar chart to represent the cumulative number of patent applications and authorizations in Beijing, Shanghai, Guangzhou, and Shenzhen each year

Need a shell start and stop script for ubuntu and docker～

Ubuntu and docker startup and shutdown too laborious, can write a shell operation?

QQ mailbox can not create users

Drawing geographical map error report

Q：Using geographical maps to represent patent applications in Beijing, Shanghai, Guangzhou, and Shenzhen
Unable to draw a map with geographic space

Q:Display the patent application status of these four regions on a geospatial map of China
After modifying the semantics, the website crashed

sql code execution timeout

Agent wrote a piece of sql code, which prompted an execution timeout error. It tried to optimize and solve it, but failed in the end.

Holidays are not recognized

Q：What are the sales like during the holidays? Analyze it visually

It is not possible to directly search for user transaction behavior data on holidays based on the year, month and day

How can I solve this problem when install

when sudo sh ./Install_cn.sh

Error:

#HOLMES environment variables
#log level
HOLMES_LOG_LEVEL=INFO
# use other redis config; default: docker redis://redis:6379/0
# HOLMES_REDIS_URL=redis://127.0.0.1:6379/0
# session encryption string
HOLMES_COOKIE_SECRET=b3da006876108d19dda000134e4025fe
# database encryption string, same with HOLMES_SECRET_KEY, you can change
HOLMES_SECRET_KEY=b3da006876108d19dda000134e4025fe
# use other postgresql database; default docker postgresql://postgres@postgres/postgres
# HOLMES_DATABASE_URL="postgresql://user:pwd@ip/database"
# allow custom js visualizations
HOLMES_FEATURE_ALLOW_CUSTOM_JS_VISUALIZATIONS=True
# Language CN/EN, only ip address ,no
WEB_LANGUAGE=CN
# web server ip address or domain,for ai get database config option. port 5000,same with Docker
WEB_SERVER=127.0.0.1:8338
# api secret key for ai get database config option
DB_API_SECRET_KEY=b3da006876108d19dda000134e4025fe
# web content security policy
HOLMES_CONTENT_SECURITY_POLICY="style-src 'self' 'unsafe-inline'; font-src 'self' data:; img-src 'self' http: https: data: blob:; object-src 'none'; frame-ancestors 'none';"
# socket dir, need set Localhost ip
REACT_APP_SOCKET_URL=127.0.0.1:8339/chat/
# static file CDN
CDN_DOMAIN=
--------------------------------
下面将开始 通过docker-compose 拉取创建镜像，可能需要60分钟，主要根据你的网络情况，请耐心等待。 
或者，你修改本地docker 镜像源地址，比如更改为阿里云等
[+] Building 159.0s (27/28)                                                                                                 docker:default
 => [server internal] load build definition from Dockerfile                                                                           0.0s
 => => transferring dockerfile: 2.99kB                                                                                                0.0s
 => [server internal] load .dockerignore                                                                                              0.0s
 => => transferring context: 263B                                                                                                     0.0s
 => [server internal] load metadata for docker.io/library/python:3.8.18-slim                                                          1.9s
 => [server internal] load metadata for docker.io/library/node:14.17                                                                  1.9s
 => [server frontend-builder  1/10] FROM docker.io/library/node:14.17@sha256:40aa86fa97c6cb85af15ecdd67798f7578c5c20e8d16f99d5b4f8f1  0.0s
 => => resolve docker.io/library/node:14.17@sha256:40aa86fa97c6cb85af15ecdd67798f7578c5c20e8d16f99d5b4f8f14196a0568                   0.0s
 => [server internal] load build context                                                                                              0.1s
 => => transferring context: 124.77kB                                                                                                 0.1s
 => [server stage-1  1/13] FROM docker.io/library/python:3.8.18-slim@sha256:19e07fa24813e88b04e606772213bd03ba044637cc939a211e28ccf9  0.0s
 => => resolve docker.io/library/python:3.8.18-slim@sha256:19e07fa24813e88b04e606772213bd03ba044637cc939a211e28ccf997a9162a           0.0s
 => CACHED [server stage-1  2/13] RUN useradd --create-home holmes                                                                    0.0s
 => CACHED [server stage-1  3/13] RUN apt-get update                                                                                  0.0s
 => CACHED [server stage-1  4/13] RUN apt-get clean && apt-get update &&   apt-get install -y --no-install-recommends   curl   gnupg  0.0s
 => CACHED [server stage-1  5/13] RUN pip config set global.index-url https://pypi.tuna.tsinghua.edu.cn/simple                        0.0s
 => CACHED [server stage-1  6/13] RUN pip install --upgrade pip                                                                       0.0s
 => [server stage-1  7/13] COPY --chown=holmes . /app                                                                                 0.2s
 => CACHED [server frontend-builder  2/10] RUN npm install --global --force [email protected]                                              0.0s
 => CACHED [server frontend-builder  3/10] RUN useradd -m -d /frontend holmes                                                         0.0sl
 => CACHED [server frontend-builder  4/10] WORKDIR /frontend                                                                          0.0s
 => CACHED [server frontend-builder  5/10] COPY --chown=holmes package.json yarn.lock .yarnrc /frontend/                              0.0sl
 => CACHED [server frontend-builder  6/10] COPY --chown=holmes client /frontend/client                                                0.0s
 => CACHED [server frontend-builder  7/10] COPY --chown=holmes package.json /frontend/                                                0.0sl
 => CACHED [server frontend-builder  8/10] COPY --chown=holmes webpack.config.js /frontend/                                           0.0s
 => [server frontend-builder  9/10] COPY --chown=holmes .env /frontend/                                                               0.0s
 => [server frontend-builder 10/10] RUN yarn && yarn build                                                                          146.8s
 => [server stage-1  8/13] WORKDIR /app                                                                                               0.0s
 => [server stage-1  9/13] COPY --from=frontend-builder /frontend/client/dist /app/client/dist                                        0.2s
 => [server stage-1 10/13] RUN pip install pip==20.2.4                                                                                1.8s
 => [server stage-1 11/13] RUN if [ "xyes" = "x" ] ; then pip install -r requirements_dev.txt ; fi                                    0.3s
 => ERROR [server stage-1 12/13] RUN pip install -r requirements.txt && pip install -r requirements_ai.txt                            7.7s
------
 > [server stage-1 12/13] RUN pip install -r requirements.txt && pip install -r requirements_ai.txt:
0.400 Looking in indexes: https://pypi.tuna.tsinghua.edu.cn/simple
0.650 Collecting Flask==1.1.1
0.717   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/9b/93/628509b8d5dc749656a9641f4caf13540e2cdec85276964ff8f43bbb1d3b/Flask-1.1.1-py2.py3-none-any.whl (94 kB)
0.899 Collecting Jinja2==2.10.3
0.952   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/65/e0/eb35e762802015cab1ccee04e8a277b03f1d8e53da3ec3106882ec42558b/Jinja2-2.10.3-py2.py3-none-any.whl (125 kB)
1.077 Collecting itsdangerous==1.1.0
1.131   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/76/ae/44b03b253d6fade317f32c24d100b3b35c2239807046a4c953c7b89fa49e/itsdangerous-1.1.0-py2.py3-none-any.whl (16 kB)
1.242 Collecting click==6.7
1.297   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/34/c1/8806f99713ddb993c5366c362b2f908f18269f8d792aff1abfd700775a77/click-6.7-py2.py3-none-any.whl (71 kB)
1.471 Collecting MarkupSafe==1.1.1
1.524   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/83/66/ec77a7000486d4d6acb599993b58dc4c97d510e3f2c37b81d31fb7632c4f/MarkupSafe-1.1.1-cp38-cp38-manylinux2014_aarch64.whl (33 kB)
1.606 Collecting pyOpenSSL==19.0.0
1.659   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/01/c8/ceb170d81bd3941cbeb9940fc6cc2ef2ca4288d0ca8929ea4db5905d904d/pyOpenSSL-19.0.0-py2.py3-none-any.whl (53 kB)
1.744 Collecting httplib2==0.14.0
1.797   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/d2/84/f97b9efdb17c9b73e133bdbf2b4bfd09cd0be655e36e3ee3c4bec9095048/httplib2-0.14.0-py3-none-any.whl (94 kB)
1.892 Collecting wtforms==2.2.1
1.946   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/9f/c8/dac5dce9908df1d9d48ec0e26e2a250839fa36ea2c602cc4f85ccfeb5c65/WTForms-2.2.1-py2.py3-none-any.whl (166 kB)
2.106 Collecting Flask-RESTful==0.3.7
2.162   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/17/44/6e490150ee443ca81d5f88b61bb4bbb133d44d75b0b716ebe92489508da4/Flask_RESTful-0.3.7-py2.py3-none-any.whl (24 kB)
2.239 Collecting Flask-Login==0.4.1
2.291   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/c1/ff/bd9a4d2d81bf0c07d9e53e8cd3d675c56553719bbefd372df69bf1b3c1e4/Flask-Login-0.4.1.tar.gz (14 kB)
2.548 Collecting Flask-SQLAlchemy==2.4.1
2.606   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/1e/65/226d95466c75e34e291a76890ed0e27af2e46ab913002847856f11d4d59d/Flask_SQLAlchemy-2.4.1-py2.py3-none-any.whl (17 kB)
2.682 Collecting Flask-Migrate==2.5.2
2.733   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/4b/22/d20a105f13c58fe590ef38ac59d5cabc1a917549ea8f90b0ca7b4e84f6be/Flask_Migrate-2.5.2-py2.py3-none-any.whl (13 kB)
2.810 Collecting flask-mail==0.9.1
2.871   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/05/2f/6a545452040c2556559779db87148d2a85e78a26f90326647b51dc5e81e9/Flask-Mail-0.9.1.tar.gz (45 kB)
3.075 Collecting flask-talisman==0.7.0
3.128   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/88/cd/b4e2be50bfc53607e2359d12899a105a3b18ae68cb6a573d70c535ebeca5/flask_talisman-0.7.0-py2.py3-none-any.whl (12 kB)
3.236 Collecting Flask-Limiter==0.9.3
3.292   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/9b/1b/23841342194bdd55e33d85a6f2e023c69d837fb69cee173352b7edba3c1f/Flask-Limiter-0.9.3.tar.gz (82 kB)
3.475 Collecting Flask-WTF==0.14.3
3.527   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/36/a9/8c01171066bd7a524ee005d81bb4a8aa446ab178043a1ad6cb5dc8f0bd83/Flask_WTF-0.14.3-py2.py3-none-any.whl (13 kB)
3.596 Collecting passlib==1.7.1
3.649   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/ee/a7/d6d238d927df355d4e4e000670342ca4705a72f0bf694027cf67d9bcf5af/passlib-1.7.1-py2.py3-none-any.whl (498 kB)
3.807 Collecting aniso8601==8.0.0
3.861   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/eb/e4/787e104b58eadc1a710738d4e418d7e599e4e778e52cb8e5d5ef6ddd5833/aniso8601-8.0.0-py2.py3-none-any.whl (43 kB)
3.947 Collecting blinker==1.4
4.003   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/1b/51/e2a9f3b757eb802f61dc1f2b09c8c99f6eb01cf06416c0671253536517b6/blinker-1.4.tar.gz (111 kB)
4.268 Collecting psycopg2==2.8.3
4.320   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/5c/1c/6997288da181277a0c29bc39a5f9143ff20b8c99f2a7d059cfb55163e165/psycopg2-2.8.3.tar.gz (377 kB)
4.555 Collecting python-dateutil==2.8.0
4.605   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/41/17/c62faccbfbd163c7f57f3844689e3a78bae1f403648a6afb1d0866d87fbb/python_dateutil-2.8.0-py2.py3-none-any.whl (226 kB)
4.751 Collecting pytz>=2019.3
4.803   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/32/4d/aaf7eff5deb402fd9a24a1449a8119f00d74ae9c2efa79f8ef9994261fc2/pytz-2023.3.post1-py2.py3-none-any.whl (502 kB)
4.934 Collecting PyYAML==5.4
4.985   Downloading https://pypi.tuna.tsinghua.edu.cn/packages/b5/fd/15638de2da0a5aa91c095718444624aa565f766fc178249ca6faa372f71a/PyYAML-5.4.tar.gz (174 kB)
5.073   Installing build dependencies: started
7.523   Installing build dependencies: finished with status 'done'
7.524   Getting requirements to build wheel: started
7.651   Getting requirements to build wheel: finished with status 'error'
7.651   ERROR: Command errored out with exit status 1:
7.651    command: /usr/local/bin/python /usr/local/lib/python3.8/site-packages/pip/_vendor/pep517/_in_process.py get_requires_for_build_wheel /tmp/tmpijhzqawr
7.651        cwd: /tmp/pip-install-k8zf91q9/pyyaml
7.651   Complete output (48 lines):
7.651   running egg_info
7.651   writing lib3/PyYAML.egg-info/PKG-INFO
7.651   writing dependency_links to lib3/PyYAML.egg-info/dependency_links.txt
7.651   writing top-level names to lib3/PyYAML.egg-info/top_level.txt
7.651   Traceback (most recent call last):
7.651     File "/usr/local/lib/python3.8/site-packages/pip/_vendor/pep517/_in_process.py", line 280, in <module>
7.651       main()
7.651     File "/usr/local/lib/python3.8/site-packages/pip/_vendor/pep517/_in_process.py", line 263, in main
7.651       json_out['return_val'] = hook(**hook_input['kwargs'])
7.651     File "/usr/local/lib/python3.8/site-packages/pip/_vendor/pep517/_in_process.py", line 114, in get_requires_for_build_wheel
7.651       return hook(config_settings)
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/build_meta.py", line 325, in get_requires_for_build_wheel
7.651       return self._get_build_requires(config_settings, requirements=['wheel'])
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/build_meta.py", line 295, in _get_build_requires
7.651       self.run_setup()
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/build_meta.py", line 311, in run_setup
7.651       exec(code, locals())
7.651     File "<string>", line 271, in <module>
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/__init__.py", line 103, in setup
7.651       return distutils.core.setup(**attrs)
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/_distutils/core.py", line 185, in setup
7.651       return run_commands(dist)
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/_distutils/core.py", line 201, in run_commands
7.651       dist.run_commands()
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/_distutils/dist.py", line 969, in run_commands
7.651       self.run_command(cmd)
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/dist.py", line 963, in run_command
7.651       super().run_command(command)
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/_distutils/dist.py", line 988, in run_command
7.651       cmd_obj.run()
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/command/egg_info.py", line 321, in run
7.651       self.find_sources()
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/command/egg_info.py", line 329, in find_sources
7.651       mm.run()
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/command/egg_info.py", line 551, in run
7.651       self.add_defaults()
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/command/egg_info.py", line 589, in add_defaults
7.651       sdist.add_defaults(self)
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/command/sdist.py", line 112, in add_defaults
7.651       super().add_defaults()
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/_distutils/command/sdist.py", line 251, in add_defaults
7.651       self._add_defaults_ext()
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/_distutils/command/sdist.py", line 336, in _add_defaults_ext
7.651       self.filelist.extend(build_ext.get_source_files())
7.651     File "<string>", line 201, in get_source_files
7.651     File "/tmp/pip-build-env-h6u0s6i5/overlay/lib/python3.8/site-packages/setuptools/_distutils/cmd.py", line 107, in __getattr__
7.651       raise AttributeError(attr)
7.651   AttributeError: cython_sources
7.651   ----------------------------------------
7.651 ERROR: Command errored out with exit status 1: /usr/local/bin/python /usr/local/lib/python3.8/site-packages/pip/_vendor/pep517/_in_process.py get_requires_for_build_wheel /tmp/tmpijhzqawr Check the logs for full command output.
------
failed to solve: process "/bin/sh -c pip install -r requirements.txt && pip install -r requirements_ai.txt" did not complete successfully: exit code: 1
--------------------------------

Large screen zoom

When zooming in on a large screen, the image will become blurry after zooming in

Can‘t create chart because the error in calling `bi_run_chart_code` function.

Date format problem

When a consecutive string is used to represent a date in the database, such as "20230909", the Ai cannot recognize and filter

Unexpected Internal Server Error after Redeploying without Properly Shutting Down Docker Compose Service

Upon redeploying a Docker Compose service without prior shutdown, an unexpected Internal Server Error is encountered in the data source.

Recharge page：

The ApiKey name can be automatically generated randomly or edited by itself
Change the copy function behind the ApiKey to copy and save, and then automatically close the page

AI-GPT interface call timed out

1.txt

The English table name changes some Chinese table names after passing in

After the website comes with the translation, the incoming English table name becomes Chinese, resulting in the subsequent table does not exist, resulting in the inability to continue.

Error log：
python_executor（至 base_mysql_assistant）：
exitcode：1（执行失败）代码输出：回溯（最近一次调用最后一次）：文件“query_total_transactions.py”，第 27
行，在 cursor.execute（sql）中文件“/opt/Holmes/venv/lib/python3.8/site-packages/pymysql/cursors.py”，第
153 行，正在执行结果 = self._query（查询）文件“/opt/Holmes/venv/lib/python3.8/site�packages/pymysql/cursors.py”，第 322 行，_query conn.query（q）查询中的文件
“/opt/Holmes/venv/lib/python3.8/site-packages/pymysql/connections.py”，第 558 行 self._affected_rows =
self._read_query_result（unbuffered=unbuffered）文件“/opt/Holmes/venv/lib/python3.8/site�packages/pymysql/connections.py”，第 822 行，_read_query_result 结果.read（）文件
“/opt/Holmes/venv/lib/python3.8/site-packages/pymysql/connections.py”，第 1200 行，读取 first_packet =
self.connection._read_packet（）文件“/opt/Holmes/venv/lib/python3.8/site�packages/pymysql/connections.py”，第 772 行，_read_packet packet.raise_for_error（）文件
“/opt/Holmes/venv/lib/python3.8/site-packages/pymysql/protocol.py”，第 221 行，raise_for_error
err.raise_mysql_exception（self._data）文件“/opt/Holmes/venv/lib/python3.8/site�packages/pymysql/err.py”，第 143 行，raise_mysql_exception 引发 errorclass（errno， errval）
pymysql.err.ProgrammingError：（1146，“表'work.sam_tianchi_mum_baby_trade_history'不存在”）

base_mysql_assistant（to python_executor）：
错误信息提示表 ''work.sam_tianchi_mum_baby_trade_history'' 不存在。这可能是因为在执行SQL查询时表的名称使用了
不正确的数据库名称。在给出的数据库信息中，数据库名称应该是 ''aCyBIffJv2OSW5dOvREL'' 而不是 ''work''。让我们纠
正SQL查询中的数据库和表名，并再次尝试执行代码。
'''蟒蛇 # 文件名：query_total_transactions_corrected.py import pymysql

数据库连接配置 db_config = { 'db'： 'aCyBIffJv2OSW5dOvREL'， 'host'： 'tNGoVq0KpQ4LKr5WMIZM'，

'passwd'： 'D3uGSjdaHbFL1ZprkIJD'， 'use_unicode'：没错， '用户'： 'kdgtPvEnzGKjE44d38M3'， 'port'：
3306 # 假设默认的MySQL端口，如果不同，则替换为实际端口 }

连接数据库连接 = pymysql.connect（host=db_config['host']， user=db_config['用户']，密码

=db_config['passwd']，数据库=db_config['db']，端口=db_config['端口']，字符集='utf8mb4'，
cursorclass=pymysql.cursors.DictCursor）
try：将 connection.cursor（）作为光标： # SQL查询统计总交易记录数 sql = “选择 COUNT（*）作为
total_records FROM 'sam_tianchi_mum_baby_trade_history'” cursor.execute（sql）结果 = cursor.fetchone
（） print（f“总的交易记录数为： {result['total_records']}”）最后： connection.close（）接口 '''
请您将修正后的代码保存到文件 'query_total_transactions_corrected.py' 中，并执行它来获取总的交易记录数。我已经
删除了原代码中错误的数据库前缀，并确保使用正确的表名。 -----------------------------------------------------

When using autopilot in English, Chinese results appear

Error: Function {'task_base'} not found

The pie charts created in chinese version are in english

Can the docker-compose.yml file be changed to version

Version: "2.0" is too old in the docker-compose.yml file. Can we change it to 2.0? If possible, we can propose a PR to fix this problem.

If you use mysql multiple times, all connections will be occupied

Semantic expressions make it impossible to draw pictures

Q：Draw a funnel based on clicks, favorites, add-ons, and payments data in the transaction data and analyze it
Can't draw a picture by asking this question

Q：Based on the clicks, favorites, add-ons, and payment data in the transaction data, it is represented and analyzed by a funnel chart
Can draw a picture with this question

Draw a funnel based on clicks, favorites, add-ons, and payments data in the transaction data and analyze it
Can draw a picture by asking a question in English