SQLAdvisor: An Open-Source SQL Optimization Tool from Meituan-Dianping

SQLAdvisor is an open-source SQL optimization tool developed by Meituan-Dianping's Beijing DBA team. It takes a SQL statement as input and outputs index optimization suggestions based on MySQL native lexical parsing, WHERE conditions, field selectivity, aggregation, and multi-table join relationships.

Usage example:

sql: SELECT id FROM crm_loan WHERE id_card = '1234567'
cmd: ./sqladvisor -h xx -P xx -u xx -pxx -d xx -q "SELECT id FROM crm_loan WHERE id_card = '1234567'"
SQLAdvisor输出: alter table crm_loan add index idx_id_card(id_card)

The tool supports common SQL types (INSERT/DELETE/UPDATE/SELECT), multi-table joins, aggregation (ORDER BY, GROUP BY), and filters out existing indexes. Its architecture includes join processing, WHERE condition handling, selectivity calculation, driver table selection, and index recommendation generation.

SQLAdvisor has been widely used internally and is now open-sourced on GitHub, with the internal and open-source versions kept consistent. The project welcomes community contributions and issue reporting.