DatabasesAuto-generated

SqlManagementClient MCP Server

The Azure SQL Database management API provides a RESTful set of web APIs that interact with Azure SQL Database services to manage your databases. The API enables users to create, retrieve, update, and delete databases, servers, and other entities.

Quick Setup

Transport: STDIO

Command: npx -y @mcp/azure-com-sql-advisors

Environment Variables

SQLMANAGEMENTCLIENT_API_KEY

Example: your_sqlmanagementclient_api_key

MCP Server Configuration

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

{
  "mcpServers": {
    "azure-com-sql-advisors": {
      "command": "npx",
      "args": ["-y","@mcp/azure-com-sql-advisors"],
      "env": {
      "SQLMANAGEMENTCLIENT_API_KEY": "your_sqlmanagementclient_api_key"
}
    }
  }
}

Endpoints

GET/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/advisors

ServerAdvisors_ListByServer

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/advisors/{advisorName}

ServerAdvisors_Get

PUT

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/advisors/{advisorName}

ServerAdvisors_CreateOrUpdate

PATCH

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/advisors/{advisorName}

ServerAdvisors_Update

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/advisors

DatabaseAdvisors_ListByDatabase

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/advisors/{advisorName}

DatabaseAdvisors_Get

PUT

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/advisors/{advisorName}

DatabaseAdvisors_CreateOrUpdate