Yearning

Every ALTER TABLE and bulk UPDATE bound for production passes through Yearning first, where an AI reviewer reads the SQL, approvers sign off, and a frozen record shows who ran what. The precheck parses up to 100,000 statements per order, groups look-alike statements into fingerprint groups, and lets the AI inspect real table metadata, indexes, and EXPLAIN plans through five read-only tools. Forty-eight built-in rules, plus your own prompt skills and DBA knowledge entries, turn violations into blocking findings. Cloud models see only anonymized SQL, or reviews can be routed to vLLM or Ollama on a private network. Orders move through serial datasource stages, such as staging then production, with up to ten approval steps each and designated executors who run or schedule the change. MySQL ALTER TABLE statements run through a built-in gh-ost with live copy progress, and captured before-images let one click generate a linked rollback order for MySQL, PostgreSQL, TiDB, OceanBase, and PolarDB. A query workspace grants time-bounded read-only access with column masking and export controls, while diagnostics chart top SQL and draft index fixes. A scoped AI assistant writes SQL from plain English without executing it. Sign-in works with LDAP or OIDC, notifications go out by email, DingTalk, Feishu, or Slack, and an OpenAPI plus an agent skill lets Claude Code or Codex submit orders and run prechecks. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. AGPL-3.0-or-later licensed.

Yearning
Yearning
Yearning
Yearning
Yearning
Yearning
Yearning
Yearning

Benefits

  • Catch risky SQL before production
  • An AI reviewer probes real table metadata, indexes, and EXPLAIN plans, then checks statements against 48 built-in rules and custom skills, and any violation of an enabled rule blocks submission.
  • Keep schemas away from cloud models
  • Cloud providers receive SQL with literals stripped and identifiers tokenized in memory, or you can point the reviewer at vLLM or Ollama endpoints on your own private network instead.
  • Approvals that nobody can bypass
  • Stages, approvers, and executors freeze when an order is submitted, so not even an administrator can skip a step, and each reveal of the original SQL is watermarked and audited.
  • Roll back without reading binlogs
  • Row before-images captured during execution and inverse DDL let you generate a linked rollback order that goes through the same precheck and approval, with no binlog or WAL access.

Features

  • AI SQL Precheck
  • Parses up to 100,000 statements per order, collapses look-alike statements into fingerprint groups, and reviews one representative per group before the submission gate opens.
  • Frozen Multi-Stage Approvals
  • Chain one to N serial datasource stages with up to ten approval steps each, then let designated executors run or schedule the change.
  • In-Process gh-ost
  • Runs MySQL online ALTER TABLE changes through a built-in gh-ost with 18 tunable parameters, live copy progress, and an exclusive execution lease per database.
  • Governed Query Workspace
  • Grants time-bounded read-only access with schema-aware autocomplete, server-side masking of sensitive columns, and XLSX, CSV, or JSONL export where a datasource allows it.
  • SQL Performance Diagnostics
  • Six linked charts cover total time, calls, average latency, rows examined, lock wait, and errors from performance_schema or pg_stat_statements, with an AI root-cause report and index advice.
  • Database AI Assistant
  • A scoped floating assistant answers platform questions, drafts SQL from plain English, and suggests index or rewrite fixes, but never executes anything itself.

Apps Similar to Yearning