MySQLManagementClient Claude Desktop Integration
This guide explains how to configure Claude Desktop (Mac and Windows) to use the MySQLManagementClient API through the Model Context Protocol (MCP). The integration exposes 7 API endpointsas callable tools inside Claude's chat interface, including LocationBasedRecommendedActionSessionsOperationStatus_Get, LocationBasedRecommendedActionSessionsResult_List, Advisors_ListByServer, and more. No API keys or credentials are needed — setup takes approximately 30 seconds. The server runs locally via npx and communicates over STDIO transport. Paste the JSON configuration below into your claude_desktop_config.json file to get started.
Integration Specs
Setup Instructions
Open Claude Settings
Launch Claude Desktop, open Settings (click your profile) → Developer → click 'Edit Config'.
Locate configuration file
This opens your local 'claude_desktop_config.json' file in your system editor.
Insert Server Config JSON
Paste the JSON configuration schema block (provided below) into the 'mcpServers' object.
Add authentication credentials
No credentials needed; leave the 'env' mapping empty.
Restart Claude app
Save the config file and restart Claude Desktop to load your new tools.
Configuration JSON
claude_desktop_config.jsonCopy and paste this config snippet inside your local configuration file.
{
"mcpServers": {
"azure-com-mysql-performancerecommendations": {
"command": "npx",
"args": [
"-y",
"@mcp/azure-com-mysql-performancerecommendations"
],
"env": {
"MYSQLMANAGEMENTCLIENT_API_KEY": "your_mysqlmanagementclient_api_key"
}
}
}
}Required Environment Keys
Provide these variable keys in your local environment section:
MYSQLMANAGEMENTCLIENT_API_KEYReplace your_mysqlmanagementclient_api_key with your secret key credentials.
Available Tools (7)
These endpoints are parsed from the OpenAPI schema and converted to Claude-compatible tools:
/subscriptions/{subscriptionId}/providers/Microsoft.DBforMySQL/locations/{locationName}/recommendedActionSessionsAzureAsyncOperation/{operationId}/subscriptions/{subscriptionId}/providers/Microsoft.DBforMySQL/locations/{locationName}/recommendedActionSessionsOperationResults/{operationId}/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/advisors/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/advisors/{advisorName}/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/advisors/{advisorName}/createRecommendedActionSession/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/advisors/{advisorName}/recommendedActions/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/advisors/{advisorName}/recommendedActions/{recommendedActionName}