I’ve seen other authors introduce CloudQuery on other platforms, and I happen to be using it. However, some authors are really not clear about the real functions and features of this product, so today we will talk about what CloudQuery really does.
I don’t know if you have used Ali Cloud DMS, it is the cloud version of Ali database service platform, providing free installation, free operation and maintenance, out-of-pocket, a variety of database types and a variety of environment easy web database management terminal, easy to use, but to the money, the enterprise version of a year to calculate down to nearly 5000 pieces, CloudQuery is a free alternative.
The following is specific to some of my use experience.
Download & Install
Cloudquery. club/ Download
There are several download methods to choose from. The official is mainly divided into offline installation and online installation. Each installation mode is divided into the full version and the standard version (without audit module), you can choose according to your own needs. Installation is very convenient, 20 minutes to fix, as long as running a script provided by the official can directly pull the image to start the service.
Because they use containerized deployment, they support all operating systems. The recommended configuration is as follows:
It is important to note that if you want to install the audit module, the hard disk should have more than 200 GB of memory.
After successful installation, you can access the login page and IP +9898 port. There are three built-in accounts to choose from. After login, you can change the password to become your own account.
Connecting to a Database
Currently, only MariaDB, MongoDB, MySQL, Oracle, Redis, SQLServer, Damun, PostgreSQL are supported. Although these data sources cover the most mainstream data sources currently used, there are also domestic data sources to support, but the overall number is still small.
Well, for one thing, it does a good job of supporting each database feature. A particularly element-rich database like Oracle also retains its features well.
Common Database Operations
There is no problem with common database operations, syntax hints, transaction commit/rollback support manual/automatic mode, result sets are in line with our daily operation habits. Statement collection, personal folder can quickly extract common SQL statements, database script abuse will probably love this feature.
Rights management
Permission management is a feature of CloudQuery, which is officially described as ultra-fine-grained, based on the RBAC model. I have a look, overall, his authority management is still divided into two parts, system authority and operation authority.
System Rights You can manage users’ basic information, departments, and roles. In System Settings – System Rights – Role Management, you can create roles and assign rights to individuals.
Operation rights You can assign access and operation rights to users. “Owner Setting” – “Connection Management”, create the required permissions in “Permission Management” – “Data Operation Permission” of the corresponding database. Currently, the permissions are fine-grained to the table, and the permissions are not in the table.
CloudQuery also has a “permission set management” that makes it easier to grant or revoke user permissions without having to select permissions one by one. The system automatically generates an initial set of permissions when the data source is successfully created, so you don’t need to spend time manually configuring these basic permissions.
After setting data operation rights, go to Role Management to create roles and assign rights to individuals.
One of the things that makes it a little bit harder to set permissions is that there’s some separation between permissions and organizational structure. After you add a user to the organizational structure, you cannot directly configure the user’s rights in this area. Instead, you need to go to System Rights to configure the user’s system rights, and then go to Owner Settings to configure the user’s operation rights. The path is separated and long.
Application management
The corresponding database can be connected to third-party applications, such as the company’s reporting system or CRM system. If the application language is JAVA, CloudQuery can explore the data of the application for application analysis.
Add an application in System Settings > Application List, and then enter Owner Settings to connect to the application in the database.
There are three main parts of application analysis, visual display of “today’s commonly used graph”; TOP SQL, slow SQL ranking, you can view the ranking of the number of SQL executions in the application, filter the SQL that takes a long time on average, and check the related SQL problems.
Analysis of audit
Many database tools do not have database audit analysis and can only record operation logs, but CloudQuery is equipped with audit analysis.
But at present, the audit function is very simple, only contains the audit analysis statistics and audit details of the execution statement. It is hoped that the official can make a more perfect design of the audit function in the later period, so that the audit function can give full play to its maximum value.
Well, that’s about it. Overall, CloudQuery is a good product. As a free data control tool, it is basically enough for my daily operations. In terms of official maintenance and user feedback, this is a product worth my time waiting for it to mature. I will continue to use and pay attention.
Official website address:cloudquery.club/
