SQLE 1.2201.0 Release Notes

Project Introduction SQLE is an open‑source SQL audit platform from the Aikexing community, designed for database users and administrators. It supports multi‑scenario audits, standardized release processes, native MySQL auditing, and extensible database types.

Download Links

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

Update List

Features

[#190] Optimized audit workflow: only SQLs that pass audit can be submitted as tickets; configurable error‑level prompts prevent ticket submission.

[#209] Added SQL Server audit plugin (https://github.com/actiontech/sqle-oracle-plugin) with support for SQL Server audit tickets and deployment guide.

[#110] Front‑end now displays SQLE version information.

[#202] Ability to add independent remarks to each SQL when submitting an audit ticket.

[#212] Audit plan enhancements allow specifying task types for customized scenarios.

[#203] Added new MySQL audit rules, including:

Use EXPLAIN to strengthen pre‑check capabilities.

Check whether DML operations exceed a configured data volume.

Check whether DDL operations exceed a configured data volume.

Check if newly created index fields already have excessive indexes.

Optimizations

[#203] Refined classification, description, and suggestions for the rule “Recommend optional fields exceeding threshold as index”.

[#203] Updated description of the rule “Enable index optimization” to “Index creation suggestion”.

[#212] Renamed audit plan feature to “Audit Task” in the UI.

Bug Fixes

[#187] Fixed inability to modify LDAP users that do not match platform format.

[#193] Fixed MySQL audit failure for schemas with hyphens (e.g., “test-db”).

[#201] Fixed issue where deleted data sources still appeared in audit rule templates after binding.

[#184] Fixed missing index audit prompts when creating a ticket with a query statement.

[#246] Fixed UI truncation of overly long rule names in the rule template editor.

[#189] Fixed SQLE Scanner crash caused by incorrect refid references in MyBatis XML files.

Recommended reading and previous releases are linked at the end of the original article.