1. Project Overview

DBQuery: A Simple, Professional, and Secure Database Query Management Platform

DBQuery is a database query platform developed by the author of LEPUS, an open-source database monitoring system (lepus.cc). It is dedicated to building a simple, intelligent, powerful, and secure all-in-one open-source database query and management platform.

2. Open Source License

Licensed under GPL-3.0

3. Screenshots

Interface Screenshots

4. Feature Overview

Features:

• Supports SQL execution and data queries for various databases, including MySQL, Oracle, MariaDB, GreatSQL, PostgreSQL, Redis, MongoDB, SQLServer, TiDB, Doris, OceanBase, and ClickHouse.
• Supports queries for execution plans, indexes, table structures, CREATE TABLE SQL statements, table sizes, and other database information.
• Supports automatic collection and querying of metadata across various databases.
• Supports automatic detection and blocking of high-risk SQL statements.
• Supports SQL execution auditing.
• Dashboard reports.
• Built-in automated task scheduling system.
• Built-in comprehensive data source management features.
• Supports multilingual internationalization, full-screen mode, and dark theme switching.
• Supports deployment on multiple platforms, including Windows and Linux.

5. Tech Stack

DBQuery is a database query platform dedicated to building a simple, intelligent, powerful, and secure all-in-one open-source database query and management solution. It supports SQL execution and data queries for various databases, including MySQL, Oracle, MariaDB, GreatSQL, PostgreSQL, Redis, MongoDB, SQLServer, TiDB, Doris, OceanBase, and ClickHouse.

Technology

• Developed using golang and nodejs/Antd, with a separated frontend and backend architecture.
• Powerful data source support with unified drivers for various databases.
• Core sensitive data is encrypted using AES with salt, providing a high level of security.
• Integrated frontend and backend packaging technology supports one-click deployment and startup.

Try It Now

 Quick Deployment

Use our precompiled binary packages for quick installation. This method is suitable for users who do not need secondary development or have no programming experience. Follow these steps:

$ cd dbquery
$ sh install.sh  //Install the software service
$ vim /etc/dbquery/setting.yml  //Modify the database connection address in the configuration file
$ sh start.sh  //Start the service
$ sh status.sh  //Check the service status
$ sh stop.sh  //Stop the service

#After the service starts, open http://127.0.0.1:8086  in your browser to access the system. Default username and password: admin/dbqueryadmin

Deploy from Source Code

Pre-requisites

• Node.js 20.18
• Npm 10.8
• Golang 1.19

Installation Steps

# Clone the Repository
$ Visit Yifei Open Source: [https://code.exmay.com/](https://code.exmay.com/) to download

# Deploy the Backend
$ go mod tidy
$ go mod vendor
$ cp setting.example.yml setting.yml  //Create a configuration file from the configuration template, then modify the database connection address
$ go run main.go

# Deploy the Frontend
$ cd web
$ npm install
$ npm start

Frontend URL: http://127.0.0.1:8000  Backend URL: http://127.0.0.1:8086  Default username and password: admin/dbqueryadmin

Thanks to the following projects

• ant.design
• china-alert
• lepus