# cookieY/Yearning

🐳 A most popular sql audit platform for mysql

Repository: https://github.com/cookieY/Yearning
Canonical: https://ross.abutalabs.com/products/yearning
Homepage: http://next.yearning.io/
Language: Go
License: AGPL-3.0
License Family: copyleft
Topics: mysql, devops, sql, yearning, mysql-web-sql, golang, sql-audit, go
Last push: 2026-08-24T11:46:31+00:00

## Health v2 (maintenance only)
Score: 79/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 99, release rhythm 40, longevity 100
- inputs: {"age_days": 3241, "days_push": 9, "days_rel": 661, "gap_med": 8, "n_releases_24m": 2}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 8964, forks 2032 (observed 2026-08-28T04:10:26.522147+00:00)

## What it is
Yearning is a self-hosted web-based SQL audit platform for MySQL, providing audit tickets with approval workflows, automated syntax checking, query auditing, and rollback statement generation. It also includes an AI assistant for SQL optimization suggestions and text-to-SQL conversion, with RBAC and encryption for privacy-focused deployment.

## Use cases
- audit mysql sql statements before execution
- create sql approval workflow tickets for dba review
- audit and restrict user database queries
- generate rollback statements for ddl and dml changes
- check sql syntax against security and compliance rules
- convert natural language to sql with ai assistance
- self-host a sql review tool for my team

## When to choose
- your team needs approval workflows and audit trails for MySQL schema and data changes
- you want a self-hosted, privacy-focused SQL audit platform with RBAC
- you need automated SQL syntax checking and rollback statement generation
- you want query auditing with data source restrictions and field anonymization

## When to avoid
- you use databases other than MySQL, since support is MySQL-specific
- you rely heavily on stored procedures, triggers, foreign keys, or cross-database DML rollbacks
- you need a fully managed cloud service rather than a locally deployed platform
- you require guaranteed accurate affected-row counts, since Explain-based estimates can be imprecise

## Facets
- artifact type: application
- maturity: active
- function: database, security, workflow-automation, web-framework, auth, authorization, llm-inference
- domain: databases, self-hosted, developer-tools, backend
- platform: self-hosted, go
- tags: sql-audit, mysql, database-operations, approval-workflow, query-audit, rbac, text-to-sql, dba-tools, devops, linux, docker, web-server

## Member repositories
- cookieY/Yearning (main) score 79

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:10:26.522147+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T17:24:27.093517+00:00, confidence not recorded.
  - readme: https://github.com/cookieY/Yearning (fetched 2026-08-28T04:10:26.522147+00:00, sha 386dbed0540e)
  - homepage: http://next.yearning.io/ (fetched 2026-08-29T08:24:34.323694+00:00, sha 3d6fa2cadd45)
  - site_page: https://next.yearning.io/about/rtm9eg85 (fetched 2026-08-29T08:24:34.328882+00:00, sha 74ae97e2606b)
  - site_page: https://next.yearning.io/article/hhwzf80y (fetched 2026-08-29T08:24:34.326654+00:00, sha fda4df962153)
- Data as of 2026-08-30T08:39:29.467469+00:00.