SQLE 2.2308.0-pre1 Release Notes and Feature Overview

SQL audit tool SQLE version 2.2308.0-pre1 has been released, offering a detailed overview of new capabilities for both the community and enterprise editions.

Project Introduction : SQLE is an open‑source SQL audit platform targeting database users and administrators, supporting multi‑scenario audits, standardized release workflows, native MySQL auditing, and extensible database type support with over 700 built‑in rules.

Community Edition Features :

Intelligent scanning now supports SQL file scanning, allowing batch analysis of SQL files to detect security risks, performance issues, and improve development quality.

Command‑line usage example: ./scannerd sqlfile -H127.0.0.1 -N"SQLfile" -P"10000" -J"default" -D/root/sqle/sqle/cmd/scannerd/scanners/mybatis/testdata/ -A"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9..."

Results can be viewed directly in the scan task details, with suggested audit actions displayed.

Enterprise Edition Features :

Workflow approvers can now be matched per data‑source instance, enabling fine‑grained permission control during release operations.

Simple usage steps: add members with specific instance permissions, configure the workflow template to use "match member with data‑source permission", and create a work order containing operations on MySQL and Oracle instances; the system automatically assigns the appropriate approver.

Support for aborting deployments on OceanBase For MySQL and TDSQL data sources, allowing users to stop blocked releases with a single click.

Full Release Information :

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

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

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

Plugin development guide: https://actiontech.github.io/sqle-docs/docs/dev-manual/plugins/howtodev

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

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

Additional resources include links to previous versions, recommended reading on SQL auditing best practices, and information about an upcoming technical conference in Shenzhen.