Yearning
Simple, Efficient and MYSQL-Like
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.
![](https://img.shields.io/badge/-x86_x64%20ARM%20Supports%20%E2%86%92-rgb(84,56,255)?style=flat-square&logoColor=white&logo=linux)
[![OSCS Status](https://www.oscs1024.com/platform/badge/cookieY/Yearning.svg?size=small)](https://www.murphysec.com/dr/nDuoncnUbuFMdrZsh7)
![LICENSE](https://img.shields.io/badge/license-AGPL%20-blue.svg)
![](https://img.shields.io/github/languages/top/cookieY/Yearning)
![](https://img.shields.io/docker/image-size/yeelabs/yearning/latest?logo=docker)
![Github Stars](https://img.shields.io/github/stars/cookieY/Yearning?logo=github)
[![Releases](https://img.shields.io/github/downloads/cookieY/Yearning/total)](https://github.com/cookieY/Yearning/releases/latest)
English | 简体中文
Feature
- AI Assistant — Our AI assistant provides real-time SQL optimization suggestions, helping users to optimize SQL
statements for better performance. The AI assistant also provides text to SQL conversion, allowing users to input
- SQL Audit — Support the creation of SQL audit tickets with approval workflows and automated syntax checkers to
validate submitted SQL statements for correctness, security, and compliance. Automatically generate rollback
statements corresponding to the submitted DDL/DML operations for easy recovery when needed. Maintain a comprehensive
history log of all SQL audit operations for traceability and auditing purposes.
- Query Audit — Our solution supports auditing of user query statements, including restrictions on data sources and
databases, as well as anonymization of sensitive fields. Query records are also saved for future reference.
- Check Rules — The automated syntax checker supports dozens of check rules, catering to most of the automatic
checking scenarios.
- Privacy focussed - Locally deployable and open-source solution ensures the security of your database and SQL
statements. In addition to providing control over the infrastructure, the solution also includes encryption mechanisms
to protect sensitive data before storing it in your database. This ensures that even if there is unauthorized access
to the database, the encrypted data remains secure and unreadable. By combining local deployment, open-source
transparency, and data encryption, we prioritize the privacy and security of your database and SQL statements.
- RBAC - In our platform, you can create and manage different roles and assign specific permissions to each role.
This allows you to restrict users' access to query work orders, auditing functions, and other sensitive operations
based on their assigned roles.
Docs
Yearning Docs only Chinese
Install
Download the latest release and extract it.
First make sure you have configured ./config.toml
Manual
## init database
./Yearning install
## start
./Yearning run
## help
./Yearning --help
Yes, it's that simple
Docker
## 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 -e Y_LANG=zh_CN 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 -e Y_LANG=zh_CN yeelabs/yearning
Recommend
Spug - 开源轻量自动化运维平台
AI Advise
Implementation of SQL statement optimization suggestions and Text 2 SQL features based on a large language model
By default or custom prompt words, AI Assistant can help users optimize SQL statements for better performance. At the same time, the AI assistant also provides text to SQL conversion feat.
Automatic SQL Checker
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
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.
Order/Query record
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.
Ecosystem
Gemini Yearning front-end Project
Yee Yearning web framework
Contact Us
E-mail: henry@yearning.io
License
See LICENSE for details.
2023 © Henry Yee