🐳 A most popular sql audit platform for mysql
Seamlessly integrates SQL detection and query auditing, tailored for the use of DBAs and developers.
A locally deployed, privacy-focused, simple and efficient for MYSQL audit platform.
English | 简体中文
Yearning Docs only Chinese
Download the latest release and extract it.
First make sure you have configured ./config.toml
## init database
./Yearning install
## start
./Yearning run
## help
./Yearning --help
Yes, it's that simple
## init database
docker run --rm -it -p8000:8000 -e SECRET_KEY=$SECRET_KEY -e MYSQL_USER=$MYSQL_USER -e MYSQL_ADDR=$MYSQL_ADDR -e MYSQL_PASSWORD=$MYSQL_PASSWORD -e MYSQL_DB=$Yearning_DB yeelabs/yearning "/opt/Yearning install"
## You must initialize your database in the startup container
docker run -d -it -p8000:8000 -e SECRET_KEY=$SECRET_KEY -e MYSQL_USER=$MYSQL_USER -e MYSQL_ADDR=$MYSQL_ADDR -e MYSQL_PASSWORD=$MYSQL_PASSWORD -e MYSQL_DB=$Yearning_DB yeelabs/yearning
The SQL statement detection function tests against predefined rules and syntax
we can set predefined rules to check whether the SQL statement conforms to specific coding standards, best practices or security requirements.
SQL syntax highlighting and auto-completion features to enhance the user experience and improve query writing efficiency.
SQL syntax highlighting helps users visually distinguish different parts of the SQL query, such as keywords, table names, column names, and operators. This makes it easier to read and understand the query structure.
Supports auditing of user order/query statements
Through the auditing feature, you can track and record all query operations, including the data source, database, and handling of sensitive fields. This ensures that query operations comply with regulations and allows for tracing query history.
Gemini Yearning front-end Project
Yee Yearning web framework
E-mail: [email protected]
See LICENSE for details.
2023 © Henry Yee