DatabasesAuto-generated

MySQLManagementClient MCP Server

The Microsoft Azure management API provides create, read, update, and delete functionality for Azure MySQL resources including servers, databases, firewall rules, VNET rules, security alert policies, log files and configurations with new business model.

Quick Setup

Transport: STDIO

Command: npx -y @mcp/azure-com-mysql-queryperformanceinsights

Environment Variables

MYSQLMANAGEMENTCLIENT_API_KEY

Example: your_mysqlmanagementclient_api_key

MCP Server Configuration

Add this to your claude_desktop_config.json or Cursor MCP settings.

{
  "mcpServers": {
    "azure-com-mysql-queryperformanceinsights": {
      "command": "npx",
      "args": ["-y","@mcp/azure-com-mysql-queryperformanceinsights"],
      "env": {
      "MYSQLMANAGEMENTCLIENT_API_KEY": "your_mysqlmanagementclient_api_key"
}
    }
  }
}

Endpoints

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/queryTexts

QueryTexts_ListByServer

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/queryTexts/{queryId}

QueryTexts_Get

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/topQueryStatistics

TopQueryStatistics_ListByServer

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/topQueryStatistics/{queryStatisticId}

TopQueryStatistics_Get

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/waitStatistics

WaitStatistics_ListByServer

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/waitStatistics/{waitStatisticsId}

WaitStatistics_Get