# Aiops Tools Mysql Aiops MCP server

Source: https://glimind.com/server/mcp-registry%2Fio.github.aiops-tools%2Fmysql-aiops
Registry id: `mcp-registry/io.github.aiops-tools/mysql-aiops`
Status: unknown

## Install

```json
{
  "mcpServers": {
    "aiops-tools-mysql-aiops-mcp-server": {
      "command": "uvx",
      "args": [
        "mysql-aiops"
      ]
    }
  }
}
```

Claude Code:

```sh
claude mcp add aiops-tools-mysql-aiops-mcp-server -- uvx mysql-aiops
```

## Tools (35)

- `analyze_table`: Analyze a table.
- `binlog_status`: Show binary log status.
- `connection_stats`: Show connection statistics.
- `create_index`: Create an index on a table.
- `drop_index`: Drop an index from a table.
- `explain_query`: Explain a query execution plan.
- `fragmentation_analysis`: Analyze table fragmentation.
- `index_stats`: Show index statistics.
- `kill_query`: Kill a running query.
- `kill_session`: Kill a server session.
- `list_databases`: List databases on the server.
- `list_engines`: List storage engines available.
- `list_sessions`: List current server sessions.
- `list_transactions`: List current transactions.
- `lock_wait_rca`: Root cause analysis for lock waits.
- `lock_waits`: Show current lock waits.
- `long_running_queries`: List long-running queries.
- `optimize_table`: Optimize a table.
- `overview`: One-shot server health snapshot.
- `redundant_indexes`: Find redundant indexes.
- `replica_status`: Show replica status.
- `replication_lag_rca`: Root cause analysis for replication lag.
- `reset_query_stats`: Reset query statistics.
- `server_version`: Get MySQL/MariaDB server version.
- `set_global_variable`: Set a global server variable.
- `show_status`: Show global server status.
- `show_variables`: Show global server variables.
- `slow_query_rca`: Root cause analysis for slow queries.
- `table_fragmentation`: Show table fragmentation.
- `table_sizes`: Show table sizes.
- `table_status`: Show table status.
- `top_queries`: Show top queries by digest.
- `undo_apply`: Apply an undo operation.
- `undo_list`: List available undo operations.
- `unused_indexes`: Find unused indexes.

Measured by Glimind (https://glimind.com): MCP handshake + tool list only, no tool is ever called. CC BY 4.0.
