SQLE 2.2305.0 Release Notes – New Features, Enhancements, and Bug Fixes

SQL audit tool SQLE 2.2305.0 was released today, and this article provides a detailed interpretation of the new version's release notes.

1. SQLE Project Introduction

SQLE, an open‑source project from the Aikexing community, is a SQL audit tool for database users and administrators that supports multi‑scenario auditing, standardized release processes, native MySQL auditing, and extensible database types.

Project Resources

Type

Link

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 Edition Demo

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

Enterprise Edition Demo

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

2. Main New Features

[Community Edition]

1. Support for aborting SQL release operations – users can now abort a blocked SQL release with a single click, reducing manual intervention and recovery time.

2. Webhook notifications for work‑order status – after configuring a custom API endpoint, SQLE pushes real‑time status changes to the endpoint, eliminating the need for periodic polling.

[Enterprise Edition]

1. Intelligent scanning can now capture slow SQL directly from MySQL instances, avoiding manual terminal operations.

2. DB2 metadata scanning – detects missing comments, improper indexes, missing primary keys, etc., and provides optimization suggestions.

3. DB2 TOP SQL scanning – monitors resource‑intensive SQL statements with metrics such as execution count, total elapsed time, average elapsed time, and average CPU time.

4. Expanded DB2 audit rules covering DDL, DML, DQL, naming conventions, index standards, and usage recommendations.

5. Oracle rollback statement generation – helps users revert partially executed SQL when a release fails.

6. PostgreSQL rollback statement generation – provides rollback scripts for PostgreSQL data sources.

7. PostgreSQL SQL analysis now displays the full CREATE TABLE statement for better optimization.

3. Complete Release Information

New Features

[#1519] Support aborting SQL release operations

[#450] Webhook notifications for work‑order status

[#1494] DB2 TOP SQL and metadata scanning (Enterprise)

[#1461] Online MySQL slow‑SQL capture (Enterprise)

[#715] Oracle and PostgreSQL rollback statements (Enterprise)

[#714] PostgreSQL SQL analysis shows CREATE TABLE (Enterprise)

Optimizations

[#1508] UI improvements

[#1473] Auto‑select default port based on data source type

Bug Fixes

[#1480] Fixed disabled buttons on rejected work‑orders

[#1495] Fixed false‑positive IN (NULL) rule

[#1499] Restored SQL syntax highlighting in review results

[#1399] Fixed uppercase index creation errors

[#1463] Fixed a MySQL rule not triggering

[#1360] Fixed workflow template progress display issue

For detailed usage, see the code snippet below for configuring MySQL slow‑query settings:

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

Additional resources, previous versions, and recommended reading links are provided at the end of the document.