DB-GPT: Revolutionizing Database Interactions with Private LLM Technology

What is DB-GPT?

DB-GPT is an experimental open-source project that uses localized GPT large models to interact with your data and environment. With this solution, you can be assured that there is no risk of data leakage, and your data is 100% private and secure.

Demo

Run on an RTX 4090 GPU.

https://github.com/csunny/DB-GPT/assets/13723926/55f31781-1d49-4757-b96e-7ef6d3dbcf80

Chat with data, and figure charts.

Text2SQL, generate SQL from chat

Chat with database meta information.

Chat with data, and execute results.

Knownledge space to manage docs.

Chat with knowledge, such as txt、pdf、csv、words. etc

Releases

• [2023/07/06]🔥🔥🔥Brand-new DB-GPT product with a brand-new web UI. documents
• [2023/06/25]🔥support chatglm2-6b model. documents
• [2023/06/14] support gpt4all model, which can run at M1/M2, or cpu machine. documents
• [2023/06/01]🔥 On the basis of the Vicuna-13B basic model, task chain calls are implemented through plugins. For example, the implementation of creating a database with a single sentence.demo
• [2023/06/01]🔥 QLoRA guanaco(7b, 13b, 33b) support.
• [2023/05/28] Learning from crawling data from the Internet demo
• [2023/05/21] Generate SQL and execute it automatically. demo
• [2023/05/15] Chat with documents. demo
• [2023/05/06] SQL generation and diagnosis. demo

Features

Currently, we have released multiple key features, which are listed below to demonstrate our current capabilities:

• SQL language capabilities

  • SQL generation
  • SQL diagnosis

• Private domain Q&A and data processing

  • Knowledge Management(We currently support many document formats: txt, pdf, md, html, doc, ppt, and url.)
  • Database knowledge Q&A
  • knowledge Embedding

• Plugins

  • Support custom plugin execution tasks and natively support the Auto-GPT plugin, such as:
  • Automatic execution of SQL and retrieval of query results
  • Automatic crawling and learning of knowledge

• Unified vector storage/indexing of knowledge base

  • Support for unstructured data such as PDF, TXT, Markdown, CSV, DOC, PPT, and WebURL

• Multi LLMs Support

  • Supports multiple large language models, currently supporting Vicuna (7b, 13b), ChatGLM-6b (int4, int8), guanaco(7b,13b,33b), Gorilla(7b,13b)
  • TODO: codegen2, codet5p

Introduction

DB-GPT creates a vast model operating system using FastChat and offers a large language model powered by Vicuna. In addition, we provide private domain knowledge base question-answering capability. Furthermore, we also provide support for additional plugins, and our design natively supports the Auto-GPT plugin.Our vision is to make it easier and more convenient to build applications around databases and llm.

Is the architecture of the entire DB-GPT shown in the following figure:

The core capabilities mainly consist of the following parts:

1. Knowledge base capability: Supports private domain knowledge base question-answering capability.
2. Large-scale model management capability: Provides a large model operating environment based on FastChat.
3. Unified data vector storage and indexing: Provides a uniform way to store and index various data types.
4. Connection module: Used to connect different modules and data sources to achieve data flow and interaction.
5. Agent and plugins: Provides Agent and plugin mechanisms, allowing users to customize and enhance the system's behavior.
6. Prompt generation and optimization: Automatically generates high-quality prompts and optimizes them to improve system response efficiency.
7. Multi-platform product interface: Supports various client products, such as web, mobile applications, and desktop applications.

Install

Quickstart

Usage Instructions

• Multi LLMs Usage
• Create your own knowledge repository

If nltk-related errors occur during the use of the knowledge base, you need to install the nltk toolkit. For more details, please refer to: nltk documents Run the Python interpreter and type the commands:

>>> import nltk
>>> nltk.download()

Acknowledgement

This project is standing on the shoulders of giants and is not going to work without the open-source communities. Special thanks to the following projects for their excellent contribution to the AI industry:

• FastChat for providing chat services
• vicuna-13b as the base model
• langchain tool chain
• Auto-GPT universal plugin template
• Hugging Face for big model management
• Chroma for vector storage
• Milvus for distributed vector storage
• ChatGLM as the base model
• llama_index for enhancing database-related knowledge using in-context learning based on existing knowledge bases.

Contribution

• Please run black . before submitting the code.

RoadMap

Licence

The MIT License (MIT)

Contact Information

We are working on building a community, if you have any ideas about building the community, feel free to contact us. Discord