SQLE 1.2208.0-pre1 Release Notes: Project Overview, New Features, and Full Release Information

SQL audit tool SQLE 1.2208.0-pre1 was released as a preview version, offering new features for trial use without guaranteeing smooth upgrades.

1. SQLE Project Introduction

SQLE is an open‑source SQL audit tool for database users and administrators, supporting multiple audit scenarios, standardized release processes, native MySQL auditing, and extensible database types.

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

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

2. New Version Main Features

1. New OceanBase for MySQL audit rules (Enterprise Edition)

Six specific audit rules were added based on OceanBase official documentation:

Database name length cannot exceed specified bytes.

Database object names should not mix uppercase and lowercase letters.

Adding a primary key after table creation is prohibited.

Use of JSON data type is discouraged.

Creation of databases named test or starting with test is prohibited.

Operations on internal oceanbase and test databases are prohibited.

Each rule is illustrated with screenshots (images omitted for brevity).

2. SQLE PostgreSQL audit plugin supports SQL analysis (Enterprise Edition)

The PostgreSQL plugin now provides SQL drill‑down analysis, execution plan details, and field/index information, with screenshots showing the analysis interface and results.

3. Complete Release Information

Release Notes

PostgreSQL audit plugin supports SQL analysis (Enterprise Edition).

OceanBase for MySQL audit plugin adds several new audit rules (Enterprise Edition).

Optimizations

[#698] Default work order name now uses automatically generated order numbers.

[#712] Increased default audit cycle for scan tasks to avoid excessive per‑second audits.

Bug Fixes

[#717] Fixed issue where users bound to a deleted workflow template could not be removed.

Previous versions and recommended reading links are provided for further reference.