1. Project Overview

SQLE is developed and maintained by Shanghai Actionsoft Information Technology Co., Ltd. (hereinafter referred to as Actionsoft). It is the open-source version of Actionsoft's CloudTree SQL Audit Software (abbreviated as CTREE SQLE). SQLE is a SQL auditing tool that supports multiple scenarios, provides native MySQL auditing support, and allows database types to be extended.

2. Open Source License

Using MPL-2.0 open-source protocol

3. Screenshots

4. Feature Overview

Product Features

1. Supports approval workflows for SQL audit and deployment tickets;
2. Supports auditing across multiple scenarios, including pre-execution, during execution, and post-execution;
3. Supports extending database types available for auditing and deployment through plugins;
4. Provides standard HTTP APIs for integration with other internal workflow systems.

SQL Audit Standards

1. Customizable audit rules (400+ rules)
2. 
   
3. Supports graded presentation of audit results and downloadable audit reports
4. 
   
5. Supports rule templates for flexible rule combinations
6. 
   
7. Audit whitelist for skipping exceptional SQL statements
8. 
   
9. Supports integrated self-service auditing through IDEs

Standardized Deployment Process

1. SQL audit workflows can be customized as needed to meet different internal workflow management requirements of enterprises
2. 
   
3. Supports scheduled deployment
4. 
   
5. Supports configurable maintenance windows
6. 
   
7. Supports Online DDL

Support for Multiple Database Types

1. Unified interface that supports auditing across multiple databases through plugin-based extensions
2. 
   
3. Built-in MySQL audit plugin, with official support for commonly used database types, including PostgreSQL, Db2, SQL Server, Oracle, TiDB, and OceanBase

Multi-Scenario Auditing

1. Supports pre-execution and post-execution auditing, covering development, testing, deployment, production, and other stages
2. 
   
3. Secure SQL Client Access
4. 
   
5. Provides an SQL client with built-in audit controls to prevent the execution of non-compliant SQL statements

Extensive Integration Capabilities

1. Standard HTTP API interfaces for integration with customers' internal workflow systems
2. 
   
3. Supports LDAP and Oauth2 user integration
4. 
   
5. Supports email, WeChat Enterprise, and webhook alert integrations

5. Tech Stack

SQL Audit Plugins

These SQL audit plugins are designed to support other databases.

• PostgreSQL
• Oracle
• SQL Server
• DB2

Installation Instructions

SQLE provides multiple installation and deployment methods, allowing users to choose according to their environment and requirements. For initial evaluation or testing, Docker Compose or Docker is recommended for quick deployment.

Installation Methods

1. Source Code Installation
2. RPM Deployment
3. Docker Deployment
4. Docker Compsoe Deployment

How to Access

SQLE provides web services. Once the application has been deployed, you can access it through the SQLE UI: [http://127.0.0.1:10000](http://127.0.0.1:10000)

Note

ps: Replace the IP address and port according to your configuration. The default port is 10000.

Default Account

• Username: admin
• Password: admin