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-manageddatabaseschema

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-manageddatabaseschema": {
      "command": "npx",
      "args": ["-y","@mcp/azure-com-sql-manageddatabaseschema"],
      "env": {
      "SQLMANAGEMENTCLIENT_API_KEY": "your_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