Ray0907/mysql-analyzer-mcp
If you are the rightful owner of mysql-analyzer-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
The MySQL Analyzer MCP Server is a standalone server designed to provide static analysis tools for MySQL databases, focusing on schema integrity, naming conventions, and performance metrics.
Tools
Functions exposed to the LLM to take actions
analyze_naming_conventions
Analyzes table and column names and can generate SQL patches to fix them.
analyze_database_indexes
Checks for redundant or missing indexes.
analyze_database_performance
Identifies potential performance bottlenecks.
analyze_database_schema
Validates schema best practices (e.g., charset, collation).
comprehensive_analysis
Runs all analyses and provides a summary report.
generate_sql_patches
Generates SQL patches for specific issues.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client