SQLE 1.2208.0-pre4 Release Notes: New Smart Scan, Opened MySQL Rules, and Full Release Details

Version: 1.2208.0-pre4

Project Overview – SQLE is an open‑source SQL audit tool for database users and administrators, supporting multi‑scenario audits, standardized release processes, native MySQL auditing, and extensible database types.

Key Resources

Type

URL

Repository

https://github.com/actiontech/sqle

Documentation

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

Release Information

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

Audit Plugin Development Docs

https://actiontech.github.io/sqle-docs-cn/3.modules/3.7_auditplugin/auditplugin_development.html

Community Demo

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

Enterprise Demo

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

New Features

1. Smart Scan Supports Alibaba Cloud RDS MySQL Slow Log

The smart scan adds a new task type for Alibaba RDS MySQL slow logs. SQLE calls the Alibaba Cloud DescribeSlowLogRecords API to fetch slow‑log data, performing an initial full pull followed by incremental updates based on user‑defined time ranges.

Steps include adding an RDS data source, creating a smart‑scan task, and reviewing the captured slow‑log entries in the task detail page.

2. Open Enterprise‑Level MySQL Rules to the Community Version

A large set of enterprise MySQL audit rules has been released to the community, covering best‑practice recommendations and high‑risk operations such as avoiding alias conflicts, not deleting primary keys, discouraging ORDER BY RAND(), preferring TRUNCATE over DELETE, and many others.

Examples of the newly opened rules include:

Alias should not duplicate table or column names

Changing a table's default charset does not affect existing columns

Deleting columns, primary keys, or foreign keys is high‑risk

Avoid using LIKE without wildcards

IN (NULL) / NOT IN (NULL) is never true

Prefer '<>' over '!='

Discourage subqueries and subquery LIMIT usage

Ensure AUTO_INCREMENT starts at 0

Full Release Information

The release notes list the following highlighted features:

[#784] Smart scan supports Alibaba Cloud RDS MySQL slow‑log scanning

[#734] Added several MySQL audit rules (e.g., inconsistent JOIN field types)

[#777] Opened enterprise MySQL rules to the community edition

For previous versions, related articles and tutorials are linked, and readers are invited to join the official QQ group (637150065) for further discussion.