Yearning is a SQL audit platform for MySQL that provides locally deployed detection and query auditing tailored for DBAs and developers.
The tool addresses the need for secure SQL governance by combining multiple audit capabilities into a single platform. It enables teams to create SQL audit tickets with approval workflows, perform automated syntax validation, and track query execution across databases. The platform generates rollback statements automatically for DDL and DML operations and maintains comprehensive history logs for traceability. An AI assistant offers real-time SQL optimization suggestions and can convert natural language input into SQL statements. Query auditing allows restriction of data sources and databases while anonymizing sensitive fields. The system enforces role-based access control to limit who can access query work orders and auditing functions.
Organizations should adopt this tool if they need centralized SQL governance without relying on cloud-hosted solutions. It suits teams prioritizing data privacy and security, as it runs locally and includes encryption mechanisms to protect sensitive database statements. The platform works well for environments where DBAs need to enforce approval workflows before SQL execution and where audit trails are required for compliance. It is specifically designed for MySQL deployments.
The project maintains active development with regular updates to its core audit and AI features. The codebase is written in Go and supports multiple architectures including x86, x64, and ARM platforms. Docker deployment is available as a standard installation method alongside manual setup options. The tool is distributed as open-source software with documented configuration requirements before deployment.
