Meituan-Dianping/SQLAdvisor

Health v2 · maintenance only

Flags: no_releases

Adoption not part of the score

5616 stars · 1235 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

SQLAdvisor is a command-line tool developed by Meituan-Dianping's DBA team that analyzes SQL statements and outputs index optimization suggestions. It uses MySQL's native lexical parsing to examine WHERE conditions, aggregation clauses, and multi-table JOIN relationships.

Use cases

• get index recommendations for a slow SQL query
• analyze which indexes to add for a MySQL query
• optimize WHERE clause and JOIN conditions with proper indexes
• review SQL indexing advice before deploying a query
• help DBAs tune database indexes automatically

When to choose

• you maintain MySQL databases and need automated index advice
• you want a lightweight CLI tool to analyze SQL statements offline
• you're a DBA auditing queries for missing or suboptimal indexes

When to avoid

• you use databases other than MySQL
• you need a fully maintained tool with active development and recent features
• you want an automated always-on query optimizer rather than an on-demand analyzer

Facets

cli-tool · maturity maintenance

database developer-tools parser databases developer-tools performance cli cpp mysql index-optimization sql-analysis dba-tools query-optimization linux

Member repositories

For agents

markdown · JSON · MCP: product_card(name="Meituan-Dianping/SQLAdvisor")