<div align="center">
An intelligent and versatile general-purpose SQL client and reporting tool for databases which integrates ChatGPT capabilities.
[![License](https://img.shields.io/github/license/alibaba/fastjson2?color=4D7A97&logo=apache)](https://www.apache.org/licenses/LICENSE-2.0.html)
[![GitHub release](https://img.shields.io/github/release/chat2db/Chat2DB)](https://github.com/chat2db/Chat2DB/releases)
[![GitHub Stars](https://img.shields.io/github/stars/chat2db/Chat2DB)](https://github.com/chat2db/Chat2DB/stargazers)
[![GitHub Forks](https://img.shields.io/github/forks/chat2db/Chat2DB)](https://github.com/chat2db/Chat2DB/fork)
[![GitHub Contributors](https://img.shields.io/github/contributors/chat2db/Chat2DB)](https://github.com/chat2db/Chat2DB/graphs/contributors)
</div>
<div align="center">
<p align="center"><b>Share Chat2DB Repository </b></p>
<p align="center">
<a href="https://twitter.com/intent/tweet?text=Chat2DB-An%20intelligent%20and%20versatile%20general-purpose%20SQL%20client%20and%20reporting%20tool%20for%20databases%20which%20integrates%20ChatGPT%20capabilities.&url=https://github.com/chat2db/Chat2DB&hashtags=ChatGPT,AGI,SQL%20Client,Reporting%20tool" target="blank" > <img src="https://img.shields.io/twitter/follow/_Chat2DB?label=Share Repo on Twitter&style=social" alt=""/> </a>
<a href="https://t.me/share/url?text=Chat2DB-An%20intelligent%20and%20versatile%20general-purpose%20SQL%20client%20and%20reporting%20tool%20for%20databases%20which%20integrates%20ChatGPT%20capabilities.&url=https://github.com/chat2db/Chat2DB" target="_blank"><img src="https://img.shields.io/twitter/url?label=Telegram&logo=Telegram&style=social&url=https://github.com/chat2db/Chat2DB" alt="Share on Telegram"/></a>
<a href="https://api.whatsapp.com/send?text=Chat2DB-An%20intelligent%20and%20versatile%20general-purpose%20SQL%20client%20and%20reporting%20tool%20for%20databases%20which%20integrates%20ChatGPT%20capabilities.%20https://github.com/chat2db/Chat2DB"><img src="https://img.shields.io/twitter/url?label=whatsapp&logo=whatsapp&style=social&url=https://github.com/chat2db/Chat2DB" /></a>
<a href="https://www.reddit.com/submit?url=https://github.com/chat2db/Chat2DB&title=Chat2DB-An%20intelligent%20and%20versatile%20general-purpose%20SQL%20client%20and%20reporting%20tool%20for%20databases%20which%20integrates%20ChatGPT%20capabilities." target="blank"><img src="https://img.shields.io/twitter/url?label=Reddit&logo=Reddit&style=social&url=https://github.com/chat2db/Chat2DB" alt="Share on Reddit"/></a>
<a href="mailto:?subject=Check%20this%20GitHub%20repository%20out.&body=Chat2DB-An%20intelligent%20and%20versatile%20general-purpose%20SQL%20client%20and%20reporting%20tool%20for%20databases%20which%20integrates%20ChatGPT%20capabilities.%3A%0Ahttps://github.com/chat2db/Chat2DB" target="_blank"><img src="https://img.shields.io/twitter/url?label=Gmail&logo=Gmail&style=social&url=https://github.com/chat2db/Chat2DB"/></a>
</p>
**License Notation**: Chat2DB is constructed and distributed for personal and non-commercial use only. For commercial use of this project, please contact corresponding authors.
Languagesï¼ English | [ä¸æ](README_CN.md)
Official websiteï¼[Chat2DB](https://sqlgpt.cn/en)
<div style="display: flex; align-items: center;">
If you find Chat2DB helpful, please help<a style="display: flex; align-items: center;margin:0px 6px" target="_blank" href='https://github.com/chat2db/Chat2db'><img src="https://img.shields.io/github/stars/chat2db/Chat2DB.svg?style=flat-square&label=Stars&logo=github" alt="github star"/></a>Click â Star and Fork in the top right corner, and your support is the biggest motivation for Chat2DB to get better
</div>
</div>
## DEMO
https://github.com/chat2db/Chat2DB/assets/22975773/79e9dded-375b-44cf-9979-bb7572465a2e
## ð Introduction
   Chat2DB is a multi-database client tool that is open-source and free. It supports local installation on Windows and Mac, as well as server-side deployment and web page access. Compared to traditional database client software such as Navicat and DBeaver, Chat2DB integrates AIGC's capabilities and is able to convert natural language into SQL. It can also convert SQL into natural language and provide optimization suggestions for SQL to greatly enhance the efficiency of developers. It is a tool for database developers in the AI era, and even non-SQL business operators in the future can use it to quickly query business data and generate reports.
## ⨠Features
- ð AI intelligent assistant, supporting natural language to SQL conversion, SQL to natural language conversion, and SQL optimization suggestions
- ð Support team collaboration, developers do not need to know the online database password, solving the problem of enterprise database account security
- âï¸ Powerful data management capability, supporting management of data tables, views, stored procedures, functions, triggers, indexes, sequences, users, roles, authorizations, etc.
- ð Powerful extension capability, currently supporting MySQL, PostgreSQL, Oracle, SQLServer, ClickHouse, OceanBase, H2, SQLite, etc., and more databases will be supported in the future
- ð¡ Front-end development using Electron, providing a solution that integrates Windows, Mac, Linux clients, and web versions
- ð Support environment isolation, online, and daily data permission separation
## ⬠Download and Install
[Downloading installation package from GitHub](https://github.com/chat2db/Chat2DB/releases)
[Downloading installation package from official website](https://sqlgpt.cn)
## ð Supported databases
Chat2DB supports connecting to the following databases:
- MySQL
- PostgreSQL
- H2
- Oracle
- SQLServer
- SQLite
- MariaDB
- ClickHouse
- DM
- Presto
- DB2
- OceanBase
- Hive
- KingBase
Redis and MongoDB are partially supported , HbaseãElasticsearchãopenGaussãTiDBãInfluxDB will support in the future.
## ð° Demo
### Create data source
<a><img width="1720" alt="crete datasource" src="https://github.com/chat2db/Chat2DB/assets/22975773/16050747-0f6c-4e98-ba91-323033584eec"></a>
### Data source management
<a><img width="1720" alt="2" src="https://github.com/chat2db/Chat2DB/assets/22975773/5d0332ca-8a65-4ed9-95fb-b12fae9209f3"></a>
### SQL console
<a><img width="1720" alt="2" src="https://github.com/chat2db/Chat2DB/assets/22975773/5d0332ca-8a65-4ed9-95fb-b12fae9209f3"></a>
### AI intelligent assistant
![image](https://github.com/chat2db/Chat2DB/assets/22975773/2dfc4aaa-c5a3-42c3-bc61-28ebc237a27b)
## ð¥ AI Configuration
### Use Chat2DB AI to get started
### CONFIGURE CUSTOM AI
* The rest api format for Custom AI is same as ChatGPT.
## ð¦ Docker installation
```bash
// Pull the latest client, then run Docker with the name 'chat2db', and mount 'root. chat2db' to '~. chat2db Docker'`
docker run --name=chat2db -ti -p 10824:10824 -v ~/.chat2db-docker:/root/.chat2db chat2db/chat2db:latest
// The normal prompt here is' Tomcat started on port (s): 10824 (http) with context path ', which will complete the process
// If the prompt 'The container name "chat2db" is already in use by container' appears here, it means that the container already exists and is running
docker start chat2db
// If you want to update chat2db, you need to first rm
docker rm chat2db
```
## ð¯ Operating Environment
Note: If local debugging is required
- Java runtime Open JDK 17
- JRE reference packaging and deployment method of jre.
- Node runtime environment Node16 Node.js.
## ð» Local Debugging
- git clone to local
```bash
$ git clone git@github.com:chat2db/Chat2DB.git
```
- Front-End debug
```bash
node version must be 16 or later
Be sure to use yarn
$ cd Chat2DB/chat2db-client
$ yarn
$ yarn run start:web
```
- Backend debug
```bash
$ cd ../chat2db-server
$ mvn clean install # maven 3.8 or later needs to be installed
$ cd chat2db-server/chat2db-server-start/target/
$ java -jar -Dloader.path=./l
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
Chat2DB 是一款有开源免费的多数据库客户端工具,支持 windows、mac 本地安装,也支持服务器端部署,web 网页访问。和传统的数据库客户端软件 Navicat、DBeaver 相比 Chat2DB 集成了 AIGC 的能力,能够将自然语言转换为 SQL,也可以将 SQL 转换为自然语言,可以给出研发人员 SQL 的优化建议,极大的提升人员的效率,是 AI 时代数据库研发人员的利器,未来即使不懂 SQL 的运营业务也可以使用快速查询业务数据、生成报表能力。 1、AI 智能助手,支持自然语言转 SQL、SQL 转自然语言、SQL 优化建议 2、智能报表,利用AIGC能力,一句话生成报表。 3、支持个人模式、支持团队协作模式,让研发协同效率更高。 4、除支持目前主流数据库外,还支持国产数据库如:达梦、Oceanbase、人大金仓。 5、强大的数据管理能力,支持数据表、视图、存储过程、函数、触发器、索引、序列、用户、角色、授权等管理 6、 前端使用 Electron 开发,提供 Windows、Mac、Linux 客户端、网页版本一体化的解决方案 7、支持环境隔离
资源推荐
资源详情
资源评论
收起资源包目录
智能且多功能的 SQL 客户端和报表工具,适用于各种数据库,Chat2DB3.1.9项目java语言代码 (1479个子文件)
Chat2DB_LICENSE 4KB
redis.conf 900B
.easy.api.config 512B
lombok.config 166B
iconfont.css 10KB
demo.css 8KB
Dockerfile 607B
sub_template_diy.docx 18KB
template_diy.docx 17KB
document.ejs 1KB
spring.factories 0B
spring.factories 0B
.gitattributes 29B
.gitignore 622B
.gitignore 422B
.gitignore 169B
demo_index.html 161KB
template.html 5KB
template.html 196B
template.html 196B
logo.icns 1.64MB
logo.ico 27KB
logo.ico 10KB
logo.ico 4KB
PostgreSQLCollationEnum.java 66KB
ChatController.java 31KB
TableServiceImpl.java 26KB
TableOperationsTest.java 25KB
SQLExecutor.java 22KB
DlTemplateServiceImpl.java 21KB
SqlServerMetaData.java 21KB
ConverterServiceImpl.java 20KB
ConfigController.java 19KB
PostgreSQLMetaData.java 16KB
AzureChatCompletionsOptions.java 16KB
OracleMetaData.java 16KB
SqlServerColumnTypeEnum.java 14KB
OceanBaseColumnTypeEnum.java 14KB
MysqlColumnTypeEnum.java 14KB
MysqlMetaData.java 14KB
DataSourceServiceImpl.java 13KB
EmbeddingController.java 13KB
MysqlSqlBuilder.java 13KB
KingBaseMetaData.java 13KB
DMColumnTypeEnum.java 12KB
KingBaseColumnTypeEnum.java 12KB
OracleColumnTypeEnum.java 11KB
PostgreSQLColumnTypeEnum.java 11KB
JdbcUtils.java 11KB
DMMetaData.java 10KB
ConnectInfo.java 10KB
DB2ColumnTypeEnum.java 10KB
PageResult.java 10KB
KingBaseSqlBuilder.java 10KB
PostgreSQLSqlBuilder.java 10KB
WsServer.java 10KB
XMLUtils.java 10KB
SqlUtilsTest.java 9KB
DB2MetaData.java 9KB
RdbDmlController.java 9KB
WebPageResult.java 9KB
Dbutils.java 9KB
AzureReflectionUtils.java 9KB
H2Meta.java 9KB
DataSourceController.java 9KB
TableController.java 9KB
Chat2dbWebMvcConfigurer.java 8KB
DatabaseExportService.java 8KB
UserServiceImpl.java 8KB
Chat2DBAIStreamClient.java 8KB
DashboardServiceImpl.java 8KB
RdbDdlController.java 8KB
OperationServiceImpl.java 8KB
EasyControllerExceptionHandler.java 8KB
JdbcOperationsTest.java 8KB
SqlServerSqlBuilder.java 8KB
RdbDmlExportController.java 8KB
SQLConst.java 8KB
DesUtil.java 8KB
DataSourceConverter.java 8KB
IDriverManager.java 7KB
DataSourceAccessServiceImpl.java 7KB
GatewayClientService.java 7KB
SqlUtils.java 7KB
DatabaseServiceImpl.java 7KB
ChartServiceImpl.java 7KB
FastChatAIStreamClient.java 7KB
EasyControllerExceptionHandler.java 7KB
WsService.java 7KB
SqliteColumnTypeEnum.java 7KB
BaichuanAIStreamClient.java 6KB
ZhipuChatAIStreamClient.java 6KB
PostgreSQLIndexTypeEnum.java 6KB
KingBaseIndexTypeEnum.java 6KB
SystemController.java 6KB
TeamServiceImpl.java 6KB
OceanBaseSqlBuilder.java 6KB
OracleSqlBuilder.java 6KB
TongyiChatAIStreamClient.java 6KB
EasyCollectionUtils.java 6KB
共 1479 条
- 1
- 2
- 3
- 4
- 5
- 6
- 15
资源评论
技术探秘者
- 粉丝: 1086
- 资源: 48
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 目标跟踪-基于目标中心点同时进行目标检测+目标跟踪算法实现-项目源码-优质项目实战.zip
- Python《文本特征分析-全唐诗数据挖掘及分析 》+源代码
- Netron-Setup-4.5.0
- 可编辑的地图图形3-世界、各洲、美国地图.xls
- NineAi 新版ChatGPT AI系统网站源码
- Anaconda3-2022.10windows版本
- 基于Servlet的URL访问安全控制.doc
- 可编辑的地图图形-2-中国到省、到市、到县地图.xls
- 快慢指针法判断链表是否有环-go语言实现
- Python《金融新闻数据挖掘分析 (数据抓取、NLP算法分析、量化策略、回测框架等)》+源代码+项目说明
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功