# cookiey/yearning **Attribution required: if you use, quote, or summarise this content, you must credit and link back to [awesome-repositories.com](https://awesome-repositories.com/repository/cookiey-yearning).** 8,952 stars · 2,032 forks · Go · AGPL-3.0 ## Links - GitHub: https://github.com/cookieY/Yearning - Homepage: http://next.yearning.io/ - awesome-repositories: https://awesome-repositories.com/repository/cookiey-yearning.md ## Topics `devops` `go` `golang` `mysql` `mysql-web-sql` `sql` `sql-audit` `yearning` ## Description Yearning is a MySQL SQL audit platform and database change management system. It provides a governance framework for reviewing, approving, and auditing SQL statements executed against MySQL databases. The platform features an AI-powered SQL optimizer that suggests performance improvements and converts natural language requests into executable SQL code. It manages database changes through an approval-based workflow engine that includes automated rollback generation and rule-based syntax validation. The system covers role-based access control, security compliance with multi-factor authentication and data encryption, and query monitoring with field-level data anonymization. Additional capabilities include transactional execution for data manipulation, schema inspection, and the merging of table alteration commands. ## Tags ### Security & Cryptography - [SQL Execution Audits](https://awesome-repositories.com/f/security-cryptography/sql-execution-audits.md) — Provides a governance platform for reviewing and approving SQL statements executed against MySQL databases to prevent data loss. - [Compliance & Audit Tools](https://awesome-repositories.com/f/security-cryptography/compliance-audit-tools.md) — Enforces multi-factor authentication and data encryption while maintaining historical query logs for audit purposes. - [Database Access Controls](https://awesome-repositories.com/f/security-cryptography/granular-access-controls/database-access-controls.md) — Manages user permissions and role-based access to restrict sensitive database operations. - [Role-Based Access Control](https://awesome-repositories.com/f/security-cryptography/role-based-access-control.md) — Implements a permission management framework that restricts database operation access based on user roles and data source rules. - [Data Encryption](https://awesome-repositories.com/f/security-cryptography/data-encryption.md) — Includes mechanisms to encrypt sensitive information to prevent unauthorized access to stored data. ([source](https://cdn.jsdelivr.net/gh/cookiey/yearning@next/README.md)) - [Multi-Factor Authentication](https://awesome-repositories.com/f/security-cryptography/identity-access-management/authentication-strategies/user-facing-login-methods/multi-factor-authentication.md) — Enforces a second form of identity verification during the login process to increase account security. ([source](http://next.yearning.io/article/amegqavl/)) ### Business & Productivity Software - [Approval Workflow Management](https://awesome-repositories.com/f/business-productivity-software/approval-workflow-management.md) — Requires designated reviewers to approve SQL scripts through a workflow before production execution. ([source](https://next.yearning.io/)) ### Data & Databases - [Database Change Management Systems](https://awesome-repositories.com/f/data-databases/database-change-management-systems.md) — Provides a workflow tool for managing DDL and DML changes through approval tickets and automated rollback generation. - [Security and Performance Constraints](https://awesome-repositories.com/f/data-databases/sql-abstract-syntax-tree-parsing/syntax-validation/security-and-performance-constraints.md) — Evaluates submitted SQL against predefined security and performance constraints using automated checkers. - [SQL Syntax Checking](https://awesome-repositories.com/f/data-databases/sql-syntax-checking.md) — Provides automated checking of SQL statements against security rules and coding standards before execution. - [AI-Powered SQL Optimizers](https://awesome-repositories.com/f/data-databases/ai-powered-sql-optimizers.md) — Provides an intelligence layer that converts natural language to SQL and suggests performance improvements. - [SQL Query Optimizations](https://awesome-repositories.com/f/data-databases/sql-query-optimizations.md) — Uses artificial intelligence to improve database performance and convert natural language requests into executable SQL code. ### Software Engineering & Architecture - [Workflow Approval Gates](https://awesome-repositories.com/f/software-engineering-architecture/workflow-approval-gates.md) — Implements an approval-based workflow engine requiring reviewer sign-off before executing scripts on production. - [Database Change Tickets](https://awesome-repositories.com/f/software-engineering-architecture/workflow-automation/database-change-tickets.md) — Creates structured tickets for database changes with automated syntax validation and generated rollback statements. ### System Administration & Monitoring - [Custom Validation Rules](https://awesome-repositories.com/f/system-administration-monitoring/database-operation-auditing/custom-validation-rules.md) — Allows the definition of configurable validation rules for database operations on a per-source basis. ([source](http://next.yearning.io/article/amegqavl/)) - [Database Query Monitors](https://awesome-repositories.com/f/system-administration-monitoring/database-query-monitors.md) — Implements a tracking system for database queries with historical logging and field-level anonymization. ([source](https://cdn.jsdelivr.net/gh/cookiey/yearning@next/README.md)) ### Testing & Quality Assurance - [SQL Query Validators](https://awesome-repositories.com/f/testing-quality-assurance/validation-verification/input-validation/compile-time-validators/sql-query-validators.md) — Automatically evaluates SQL statements against predefined rules to ensure adherence to security and coding standards. ([source](http://next.yearning.io/usage/ptbzchak/)) ### Artificial Intelligence & ML - [Natural Language Querying](https://awesome-repositories.com/f/artificial-intelligence-ml/machine-learning/language-tools/natural-language-querying.md) — Converts human-readable text descriptions into executable database statements using artificial intelligence. ### Part of an Awesome List - [Performance Recommendations](https://awesome-repositories.com/f/awesome-lists/devtools/sql-clients-and-ides/ai-powered-sql-clients/performance-recommendations.md) — Provides AI-powered SQL optimization that suggests performance improvements for database statements. ([source](http://next.yearning.io/article/amegqavl/)) ### DevOps & Infrastructure - [SQL Rollback Generation](https://awesome-repositories.com/f/devops-infrastructure/change-rollback-mechanisms/sql-rollback-generation.md) — Automatically creates inverse SQL statements during the audit process to allow for quick recovery from failed changes.