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

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

Endpoints

GET

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

DatabaseSchemas_ListByDatabase

GET

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

DatabaseSchemas_Get

GET

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

DatabaseTables_ListBySchema

GET

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

DatabaseTables_Get

GET

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

DatabaseColumns_ListByTable

GET

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

DatabaseColumns_Get