Skip to content

TOOLS_SUMMARY.md

Latest commit

 

History

History
58 lines (46 loc) · 2.51 KB

TOOLS_SUMMARY.md

File metadata and controls

58 lines (46 loc) · 2.51 KB
Raw

MySQL MCP Server - Available Tools

This MySQL MCP server now includes ALL 20 tools you requested:

✅ Complete Tool List

Core Query & Table Management

  1. mysql_query - Execute read-only MySQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN)
  2. list_mysql_tables - List all tables in the MySQL database
  3. mysql_table_schema - Get detailed schema information for a MySQL table
  4. mysql_table_data - Fetch sample data from a MySQL table
  5. mysql_databases - List all databases accessible to current user

Table Analysis & Metadata

  1. mysql_table_indexes - Show all indexes for a specific table
  2. mysql_table_size - Get storage size information for a table
  3. mysql_table_status - Get comprehensive status information for tables
  4. mysql_table_constraints - Show foreign key and check constraints for a table
  5. mysql_column_stats - Get column statistics and data distribution

System & Server Information

  1. mysql_user_privileges - Show current user's privileges
  2. mysql_process_list - Show active MySQL connections and processes
  3. mysql_variables - Show MySQL system variables
  4. mysql_charset_collation - Show available character sets and collations

Query Analysis & Search

  1. mysql_explain_query - Analyze query execution plan
  2. mysql_search_tables - Search for tables containing specific column names
  3. mysql_table_dependencies - Find foreign key dependencies between tables

Backup & Replication

  1. mysql_backup_info - Get information about database backup status
  2. mysql_replication_status - Show MySQL replication status
  3. mysql_query_cache_stats - Show query cache statistics

Security Features

  • ✅ Read-only query validation using regex patterns
  • ✅ SQL injection prevention with prepared statements
  • ✅ Table name validation and sanitization
  • ✅ Parameter validation for all inputs

Error Handling

  • ✅ Comprehensive error handling for all tools
  • ✅ Structured error responses with error types
  • ✅ Connection failure detection and reporting
  • ✅ MySQL privilege checking and error reporting

Configuration

  • ✅ Environment variable support for all MySQL connection parameters
  • ✅ Claude Desktop integration ready with config file
  • ✅ Support for both stdio and SSE transports

Resources & Prompts

  • ✅ 2 Resources: mysql://tables and mysql://schema/{table_name}
  • ✅ 2 Prompts: generate_sql_query and analyze_query_performance

The server is now fully functional and ready for production use!