MCP-MySQL-Ops

[Tool Purpose]: Get MySQL server version and basic information [Exact Functionality]: - Show MySQL server version, edition, and compilation info - Display server uptime and basic configuration - Show available storage engines and default engine - Provide server connection details (sanitized) [Required Use Cases]: - When user requests "server info", "MySQL version", "server status" - When diagnosing compatibility issues - When checking server capabilities Args: database_name: Database name to connect to (uses default if omitted) Returns: Formatted string with MySQL server information

[Tool Purpose]: Monitor active MySQL connections and processes [Exact Functionality]: - List all active connections with process ID, user, host, database - Show current command being executed by each connection - Display connection time and state information - Filter by user or database name [Required Use Cases]: - When user requests "active connections", "current sessions", "process list" - When diagnosing connection issues or monitoring user activity - When checking for long-running queries Args: database_name: Database name to connect to (uses default if omitted) user_filter: Filter connections by username db_filter: Filter connections by database name Returns: Formatted string with active connection information

[Tool Purpose]: List all databases in MySQL server [Exact Functionality]: - Show all databases with names and character sets - Display database size information if available - Show collation and default character set [Required Use Cases]: - When user requests "database list", "show databases", "available databases" - When exploring server structure Args: database_name: Database name to connect to (uses default if omitted) Returns: Formatted string with database list

[Tool Purpose]: List all tables in specified database or all databases [Exact Functionality]: - If database_name provided: Show tables in that specific database - If database_name empty: Show tables from all user databases with database names - Display table type (BASE TABLE, VIEW), engine, rows count, and size information - Show creation and update timestamps - Filter by table type if specified [Required Use Cases]: - When user requests "table list", "show tables", "database tables" - When exploring database structure Args: database_name: Database name to analyze (if empty, shows tables from all databases) table_type: Filter by table type ("BASE TABLE", "VIEW") Returns: Formatted string with table information

[Tool Purpose]: Get detailed schema information for a specific table or entire database [Exact Functionality]: - If table_name provided: Show all columns, indexes, foreign keys for that table - If table_name empty: Show overview of all tables in the database - Display table statistics, constraints, and engine information - Include column comments and default values [Required Use Cases]: - When user requests "table schema", "table structure", "describe table" - When analyzing table design and constraints - When requesting database-wide schema analysis with empty table_name Args: table_name: Name of the table to analyze (empty string for database overview) database_name: Database containing the table (uses current database if omitted) Returns: Formatted string with detailed table schema information or database overview