Open Source Ecosystems

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