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.
?style=flat-square&logoColor=white&logo=linux){kind=icon}
English | 简体中文
- 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.
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 -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
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.
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: henry@yearning.io
See LICENSE for details.
2023 © Henry Yee