SQLE 1.2210.0 Release Notes: New Features, Enhancements, and Bug Fixes

1. SQLE 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.

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

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

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

2. New Version Feature Summary

2.1 Integrated SQL Web Client with CloudBeaver

The tool now integrates CloudBeaver, enabling built‑in MySQL data synchronization and, in version 1.2210.0, support for additional databases such as Oracle, OceanBase for MySQL, SQL Server, PostgreSQL, TiDB, and Db2.

Supported data sources are shown in the following screenshots:

2.2 New MySQL Audit Rules

Prohibit using rename or change to modify table or column names.

Require a LIMIT clause on all SELECT statements (default 1000).

2.3 Smart Scan Task List Enhancements

Added filter conditions to quickly locate specific scan tasks, as illustrated below:

2.4 Independent Menus for Each Smart Scan Task Type

Each scan task type now appears as a separate menu entry, improving navigation and task creation.

3. Complete Release Information

Features

[#900] CloudBeaver now supports more database types.

[#850] Added MySQL rules prohibiting rename and change commands.

[#816] New MySQL rule: SELECT must include LIMIT (default 1000).

Optimizations

[#964] CloudBeaver audit rules now use static rules bound to data‑source templates.

[#825] Created independent menu pages for each smart‑scan type.

[#826] Optimized rule‑template refresh speed when using MySQL 8.0.

[#888] Added configurable log rotation for SQLE.

[#901] Refactored report statistics page.

[#925] Clicking “SQL Workbench” now opens CloudBeaver when configured.

[#923] Added filter conditions to smart‑scan task list.

[#902] Optimized work‑order progress styling.

Bug Fixes

[#807] Fixed email‑sent‑success but not received issue.

[#928] Fixed panic when inserting into non‑existent tables via pg plugin.

[#961] Fixed unreclaimed expired work orders after failure.

[#957] Fixed LDAP user sync to CloudBeaver login failure.

[#883] Fixed duplicate table info display for certain SQL analyses (Enterprise edition).

[#880] Fixed inability to delete user email.

4. Acknowledgments

Thanks to @bdper0 and @Sharkzeng for their usage feedback and valuable improvement suggestions.