SQLE 2.2308.0-pre2 Release Notes – New Features and Full Release Information

SQL audit tool SQLE 2.2308.0-pre2 has been released, providing new capabilities for both community and enterprise editions.

Project Overview : SQLE is an open‑source SQL audit platform for database users and administrators, supporting multi‑scenario auditing, standardized release processes, native MySQL auditing, and extensible database types, with over 700 built‑in rules.

New Features :

Zero‑cost Java application integration via a Java agent, allowing developers and DBAs to capture and audit SQL statements from running Java processes. Example command and usage are provided.

TiDB plugin now supports “abort release” functionality, enabling one‑click termination of blocked SQL deployments.

Support for OceanBase for Oracle data sources, extending audit coverage to this database type.

Detailed usage steps for the Java probe include creating a scan task, running the Java application with the provided agent and environment variables (see the code block below).

SQLE_COLLECT_ENABLE=true \
SQLE_BASE_URL=http://10.186.64.175:10000 \
SQLE_TASK_NAME=probe \
SQLE_TASK_TOKEN=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9... \
SQLE_EXCLUDE_JAVA_FILE=UserServiceImpl.java \
SQLE_LOG_FILE=/tmp/collect.log \
java -javaagent:/opt/surveyking/sql-agent-1.0-SNAPSHOT.jar \
-jar surveyking-v0.3.0-beta.4.jar \
--server.port=1991 \
--spring.datasource.url=jdbc:mysql://10.186.64.175:3306/jw \
--spring.datasource.username=root \
--spring.datasource.password=mysqlpass \
& >>/opt/surveyking/std.log

The release also includes a full list of links (GitHub repository, documentation, release page, plugin development guide, and online demo URLs for both community and enterprise editions), as well as a table of resources.

Type

URL

Repository

https://github.com/actiontech/sqle

Documentation

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

Release Info

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

Data‑audit plugin dev 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 (admin / admin)

Additional improvements for the community edition include enhanced scanner output, and bug fixes such as resolving a panic when exporting deleted data sources.

A comparison page outlines feature differences between the community and enterprise editions.

For further reading, related articles and conference announcements are listed.