SQLE 2.2305.0‑pre1 Release Notes: Project Overview, New Features, and Full Release Details

Project Introduction

SQLE, an open‑source SQL audit tool from the Aikexing community, targets database users and administrators, offering multi‑scenario auditing, standardized release processes, native MySQL support, and extensible database type handling.

Key Resources

Repository: https://github.com/actiontech/sqle

Documentation: https://actiontech.github.io/sqle-docs-cn/

Release page: https://github.com/actiontech/sqle/releases

Audit‑plugin development guide: https://actiontech.github.io/sqle-docs-cn/3.modules/3.7_auditplugin/auditplugin_development.html

Community demo (admin/admin): http://demo.sqle.actionsky.com

Enterprise demo (admin/admin): http://demo.sqle.actionsky.com:8889

New Version Main Features

Smart Scan from MySQL Instance (Enterprise Edition)

The previous slow‑log scan required creating a task and manually configuring the scannerd process. The new feature lets SQLE directly query the mysql.slow_log table, eliminating terminal operations and simplifying the workflow.

Usage Steps

Create a scan task, select “slow‑log scan”, and set the collection source to 1 so SQLE queries the mysql.slow_log table directly.

Additional Parameters

Collection source = 0: task uses scannerd to read mysql‑slow.log .

Collection source = 1: task uses SQLE to query the mysql.slow_log table.

Database Instance Configuration

set
global long_query_time=1;  // adjust according to business needs
set
global slow_query_log=1;   // enable slow‑query logging
set global log_output='FILE,TABLE'; // write slow logs to file and table

After executing a slow SQL in the database, clicking “Immediate Review” displays the collected statistics.

Full Release Information

Optimizations

[#1461] Smart scan now supports online capture of slow SQL from MySQL instances (Enterprise).

[#1473] Automatic default port selection based on data source type.

Bug Fixes

[#1463] Fixed a MySQL rule that never triggered.

[#1360] Resolved workflow‑template‑related progress display issue.

Previous Versions

Smart scan added MySQL processlist audit

SQL Audit | SQLE 2.2304.0 released

New SQL row‑count prediction feature

SQL audit results now include improvement suggestions

Recommended Reading

Common MySQL/Oracle SQL development rules

Quickly use SQLE to audit various databases

SQLE compatibility test with MySQL 8.0

How to develop a custom SQLE rule

Using SQLE for development‑stage SQL audit

For more information and community discussion, join the official QQ group: 637150065 .