MCPcopy Index your code
hub / github.com/Meituan-Dianping/SQLAdvisor

github.com/Meituan-Dianping/SQLAdvisor @v2.0

Chat with this repo
repository ↗ · DeepWiki ↗ · release v2.0 ↗ · + Follow
10,968 symbols 20,110 edges 648 files 1,648 documented · 15%
What it actually does AI analysis from the code graph — generated when you open this
loading…
README

一、简介

SQLAdvisor是由美团点评公司技术工程部DBA团队(北京)开发维护的一个分析SQL给出索引优化建议的工具。它基于MySQL原生态词法解析,结合分析SQL中的where条件、聚合条件、多表Join关系 给出索引优化建议。目前SQLAdvisor在美团点评广泛应用,包括美团支付、酒店旅游、外卖、团购等产品线,公司内部对SQLAdvisor的开发全面转到github上,开源和内部使用保持一致

主要功能:输出SQL索引优化建议

二、SQLAdvisor详细说明

  1. SQLAdvisor快速入门教程
  2. SQLAdvisor架构和实践
  3. SQLAdvisor release notes
  4. SQLAdvisor开发规范
  5. FAQ

三、SQLAdvisor的需求及Bug反馈方式

如果用户在实际的应用场景中对SQLAdvisor有新的功能需求,或者在使用SQLAdvisor的过程中发现了bug,在github上进行交流或是PullRequest,也可以在讨论组/群进行反馈,我们会及时维护。

QQ

Core symbols most depended-on inside this repo

append
called by 423
sql/sql_string.cc
length
called by 373
sql/handler.h
ptr
called by 319
sql/sql_string.h
my_error
called by 213
mysys/my_error.c
my_free
called by 190
mysys/my_malloc.c
add_compiled_collation
called by 161
mysys/charset.c
size
called by 145
extra/yassl/taocrypt/src/file.cpp
get_buffer
called by 113
extra/yassl/taocrypt/include/block.hpp

Shape

Method 4,815
Function 3,318
Class 2,231
Enum 604

Languages

C++81%
C19%

Modules by API surface

sql/item_create.cc586 symbols
sql/item_func.h412 symbols
sql/item_cmpfunc.h390 symbols
sql/item.h324 symbols
sql/item_timefunc.h293 symbols
sql/sql_class.h269 symbols
sql/item_strfunc.h217 symbols
sql/sys_vars.h213 symbols
sql/sql_lex.h191 symbols
sql/item_sum.h188 symbols
extra/yassl/src/ssl.cpp171 symbols
sql/item_xmlfunc.cc168 symbols

For agents

$ claude mcp add SQLAdvisor \
  -- python -m otcore.mcp_server <graph>

⬇ download graph artifact