DBQuery：Professional and Secure database query platform

The database query platform is developed by the author of the LEPUS open-source database monitoring system (lepus. cc), dedicated to creating a simple, intelligent, powerful, and secure one-stop query management platform for open-source databases.

[English] | [简体中文]

✨ Features：

• Support MySQL Oracle、MariaDB、GreatSQL、PostgreSQL、Redis、MongoDB、SQLServer、TiDB、Doris、OceanBase、ClickHouse Waiting for SQL execution and data queries of various databases.
• Support data queries such as execution plans, indexes, table structures, SQL tables, and table capacity for various databases.
• Support automatic collection and querying of metadata information for various databases.
• Support automatic detection of high-risk SQL execution and interception.
• Support SQL execution audit function.
• Dashboard report.
• Built in automated task scheduling system.
• Built in complete data source management functionality.
• Support internationalization of Mandarin, full screen mode, and switching between dark color styles. -Supports multi platform deployment of Windows and Linux.

🧩 Technical

• Developed based on Golang, nodejs/Antd, with front-end and back-end separation.
• Powerful data source support, unifying various database drivers.
• The core sensitive data is encrypted with AES and salt for high security.
• Integrated front-end and back-end packaging technology, supporting one click deployment and startup

💬 Dear friends, if you are interested in this project, please give me a Starfirst. Thank you!💕

• If you have any installation or usage issues, please feel free to join the WeChat communication group (add Ruyi-1024 remark DBQuery to join the group)
• In the rapid iteration development of software, please prioritize testing and using the latest released version.
• Welcome everyone to provide valuable suggestions, raise issues, PR.💕

Install

📦 Quick start

Use our compiled binary package for quick installation, suitable for users who do not require secondary development and have no programming experience. The steps are as follows:

$ cd dbquery
$ sh install.sh  //Install software
$ vim /etc/dbquery/setting.yml  //Modify configuration files database connection addresses
$ sh start.sh  //Start service
$ sh status.sh  //View service status
$ sh stop.sh  //Stop service

After the service is running, use a browser to access: http://127.0.0.1:8086 Login to the system, default account password：admin/dbqueryadmin

🦄 Build deployment

Requirements

• Node.js 20.18
• Npm 10.8
• Golang 1.19

Build step

# clond dbquery
$ git clone https://github.com/ruyi1024/dbquery.git

# build backend
$ go mod tidy
$ go mod vendor
$ cp setting.example.yml setting.yml  //Create configuration files from configuration templates and modify database connection addresses
$ go run main.go

# build frontend
$ cd web
$ npm install
$ npm start

Frontend：http://127.0.0.1:8000 Backend：http://127.0.0.1:8086 Default Admin User: admin/dbqueryadmin

License

License is GPL 3.0

Contribute

If you are interested in this project, you can open an issue or submit a PR, please ensure to follow the project's code specifications.

Thanks

• ant.design
• china-alert
• lepus