SQLE 1.2207.0 Release Notes and Feature Summary

SQL audit tool SQLE 1.2207.0 has been released, and this article provides a detailed interpretation of the release notes.

Project Introduction – SQLE is an open‑source SQL audit platform for database users and administrators, supporting multi‑scenario audits, standardized release processes, native MySQL auditing, and extensible database types. Repository, documentation, release information, and online demos (community and enterprise) are listed in a table.

New Features Summary

Dashboard redesign: multiple perspectives (DBA, developer) now display more comprehensive work‑order overview information.

Incremental intelligent scanning: supports incremental audit for slow‑log and TiDB audit log scenarios, allowing the system to ignore previously fixed SQL statements and focus on recent activity.

OceanBase MySQL‑mode audit plugin (Enterprise): adds most MySQL audit rules, removes incompatible ones, and introduces two OceanBase‑specific rules.

JetBrains IDE audit plugin: enables real‑time, self‑service static SQL auditing during development, with results shown in pop‑up windows.

Complete Release Information

Features include TiDB audit log support, OceanBase MySQL‑mode support, new JetBrains plugin, dashboard enhancements, and incremental scanning. Optimizations improve rule‑template UI consistency, add database‑type filters, rename “audit task” to “intelligent scan”, and correct MySQL plugin labeling. A long list of bug fixes addresses issues such as lower_case_table_names handling, system‑table detection, license problems, plugin compatibility, index suggestion crashes, and more.

Acknowledgments

Thanks to @Sharkzeng for providing usage feedback, reporting bugs, and suggesting improvements.