About
Monitor MySQL instances, inspect schemas, and track performance. Diagnose slow queries, locks, and connection issues to keep databases healthy. Explore databases, tables, users, and configuration to optimize storage and plan capacity.
Tools
get_server_info
[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
get_active_connections
[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
get_database_list
[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
get_table_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
get_table_schema_info
[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
