XiaoMi/soar
SQL Optimizer And Rewriter observed · 2026-08-28
Health v2 · maintenance only
23/100
- Activity 0
- Release rhythm 8
- Longevity 100
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-02. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 2886
- days_rel: n/a
- days_push: 992
- n_releases_24m: 0
Adoption not part of the score
8758 stars · 1319 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded
SOAR (SQL Optimizer And Rewriter) is a command-line tool from Xiaomi's database team that automatically optimizes and rewrites SQL statements for MySQL. It provides heuristic query optimization, multi-column index suggestions, EXPLAIN interpretation, and SQL fingerprinting/beautification.
Use cases
- analyze and optimize slow MySQL queries
- get index recommendations for SELECT, UPDATE, INSERT, DELETE statements
- rewrite SQL with custom rules
- audit SQL syntax and suggest improvements
- merge multiple ALTER TABLE requests into one
- pretty-print and fingerprint SQL statements
- interpret EXPLAIN output in a readable way
When to choose
- you work with MySQL-family databases and want automated query review
- you need index advice for complex multi-column queries
- you want a standalone cross-platform CLI for SQL auditing in CI or DBA workflows
When to avoid
- you use non-MySQL databases like PostgreSQL or SQL Server
- you need a GUI-based or always-on monitoring optimizer
- you require actively developed features, as the project is in maintenance with infrequent releases
Facets
cli-tool · maturity maintenance
database developer-tools cli databases developer-tools performance windows cli go sql-optimizer sql-rewriter mysql query-advisor index-optimization sql-audit linux macos
1 source
- readme: https://github.com/XiaoMi/soar · fetched 2026-08-28 · 712abf951624
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| XiaoMi/soar | main | 23 |
For agents
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem