Explore Yearning: A Lightweight MySQL SQL Audit Platform for SMEs

Today I share what may be the most popular MySQL SQL audit platform, Yearning.

Yearning is a lightweight MySQL SQL statement audit platform aimed at small and medium enterprises, offering query auditing, SQL review and other functions.

Current features include:

SQL Query

Query tickets

Export

Auto‑completion, intelligent suggestions

Query statement audit

Result desensitization

SQL Review

Workflow tickets

SQL syntax checking

Compliance checking based on rules

Automatic generation of DDL/DML rollback statements

Historical review records

Push

E‑mail ticket push

DingTalk webhook robot ticket push

User permissions and management

Role division

Fine‑grained user permissions

Registration

Other

TodoList

LDAP login

Dynamic audit rule configuration

Custom audit hierarchy

AutoTask automatic execution

Yearning does not rely on any third‑party SQL audit tools; it implements its own audit and rollback logic and only depends on a MySQL database at runtime.

Usage is simple and requires three steps:

1. Fill the configuration file

cat conf.toml
[Mysql]
Db = "Yearning"
Host = "127.0.0.1"
Port = "3306"
Password = "xxxx"
User = "root"

[General]   # Database encryption key, can be changed only once.
SecretKey = "dbcjqheupqjsuwsm"

2. Initialize and install

./Yearning install

3. Start the service

# default start
./Yearning run

# start with parameters
./Yearning run --push "172.27.80.35" -port "8000"

Then open a browser at http://127.0.0.1:8000; the default username/password is admin/Yearning_admin.

Yearning welcomes secondary development, so interested users can try it out.