Databases

SqlManagementClient Claude Desktop Config

Add the SqlManagementClient MCP server to Claude Desktop with this ready-to-use configuration.

Setup Instructions

Open Claude Desktop
Go to Settings → Developer → Edit Config → claude_desktop_config.json
Paste the JSON below into the file
Set your credentials in the env section
Restart Claude Desktop

Configuration JSON

Copy the entire block into your claude_desktop_config.json

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

Environment Variables

SQLMANAGEMENTCLIENT_API_KEY

Replace your_sqlmanagementclient_api_key with your actual sqlmanagementclient api key

Endpoints

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/databases/{databaseName}/schemas

ManagedDatabaseSchemas_ListByDatabase

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/databases/{databaseName}/schemas/{schemaName}

ManagedDatabaseSchemas_Get

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/databases/{databaseName}/schemas/{schemaName}/tables

ManagedDatabaseTables_ListBySchema

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}

ManagedDatabaseTables_Get

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}/columns

ManagedDatabaseColumns_ListByTable

GET

/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/databases/{databaseName}/schemas/{schemaName}/tables/{tableName}/columns/{columnName}

ManagedDatabaseColumns_Get