1024 open source first release | SQL audit tool SQLE

On October 24, 2017, 2018, and 2019, the Ecoson open source community produced the MySQL distributed middleware DBLE, the data replication product DTLE, and the global transaction framework TXLE. After two years, these three products have accumulated more design experience and user feedback in the community, and more companies and users have used them in the production environment, realizing rapid product iteration.

The open source SQLE is a SQL audit tool for database users and administrators. It aims to standardize the SQL auditing process and improve SQL quality. The community maintains the tradition of opening up one product every year, contributing to the enrichment of the MySQL open source ecosystem.

---

SQLE supports multi-scenario audits, supports standardized on-line procedures, natively supports MySQL audits and an extensible SQL audit tool for database types.

The main function

Platform management

• Support user and role management;
• Support to configure the online database;
• Support role-based resource isolation;
• Support the configuration of audit rule templates;
• Supports the application of different rule templates to different databases.

SQL audit

• Support work order approval process and work order isolation;
• Support email push approval events;
• Support SQL to go online;
• Support generating rollback statements;
• Support reviewing MyBatis XML files;
• Support audit suggestions to be re-displayed according to SQL classification;
• Support audit report download.

SQL audit plan

• Support to collect SQL statistical information from business through standard interface;
• Provide MyBatis file scanning upload program (scanner), which can integrate CI/CD;
• Support static audit, that is, leave the online database audit;
• Support regular audit, existing SQL to generate audit report.

Enterprise Edition features

• Support review whitelist;
• Support the visual configuration of the approval process;
• Support MySQL slow log collection for SQL audit.

Features at a glance

Automated audit

• Support multi-SQL and work order related audit
• Support reviewing MyBatis files
• Complete SQL specification and rule base to solve the problem of SQL specification
• Customize SQL rule templates to solve the problem of inconsistency of different business rules
• Support whitelisting to solve the audit problem of using the old exception SQL

Standardized on-line process

• The SQL review process can be customized as needed to meet the management requirements of different processes within the enterprise
• Support multi-level approval and quick launch

Multi-scene review

• Support pre- and post-review, covering development, testing, launch, production and other links

Open interface

• Standard HTTP API interface can be connected with the customer's internal process system

Multi-database support

• Supports the extension of auditable online database types through plug-ins, no need to upgrade the software, import audit plug-in to get the audit online ability of the corresponding database type, and use all the functions of the platform.

Support service

• Professional team of transmission component experts
• Active open source community communication atmosphere
• 7×24 hours of escort team support
• Stable R&D and testing team guarantee
• Provide enterprise-level butler service support

scenes to be used

Standardize the online process:

Multi-scene review:

project address:

https://github.com/actiontech/sqle

Document address:

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

Community official website:

https://opensource.actionsky.com/sqle/

---

Open source welfare activities:

From now until November 24, 2021, users will try SQLE;

Submit usage experience or product suggestions within the effective activity time; the community will select 5 users based on the quality and usability of the content, and give them rich prizes. The remaining participants will also receive exquisite surroundings.

Event time: from now until November 24, 2021

Activity rules:

• Trial users need to submit their experience or suggestions for the product before 23:59:59 on November 24;
• On November 25th, the results of the awards will be announced in [SQLE Official QQ Group: 637150065], please be sure to join the group first;
• The selected 5 users will receive a 500 yuan Jingdong card, and the remaining users will also receive a gift of exquisite surroundings;

The final interpretation right of this activity belongs to the Aikesheng Open Source Community