Log Analytics MCP Server
Enables GitHub Copilot to query Azure Log Analytics workspaces using KQL for incident investigation, performance analysis, and cross-resource correlation.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Log Analytics MCP ServerShow me errors from the last hour"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Log Analytics MCP Server
A Model Context Protocol (MCP) server that enables AI agents to query Azure Log Analytics workspaces using KQL (Kusto Query Language). This bridges AI assistants like GitHub Copilot, Claude, and Azure SRE Agent with your observability data.
Supports both local (stdio) and remote (Streamable HTTP) deployment modes.
π― Use Cases
Private VNet Observability: Query logs from workspaces protected by Private Linkβwhen public queries are blocked, deploy this server inside the VNet as a trusted query proxy
Incident Investigation: Query logs from VMs, containers, and Azure resources during incidents
Cross-Resource Correlation: Query multiple VMs/resources in a single natural language request
Performance Analysis: Analyze CPU, memory, disk metrics across your infrastructure
Related MCP server: Azure Resource Graph MCP Server
β¨ Features
Tool | Description |
| Execute any KQL query against Log Analytics |
| Discover available tables in a workspace |
| Get data volume and usage statistics |
| Pre-built error pattern analysis from Syslog |
| VM health check (heartbeat, CPU, memory, errors) |
π Prerequisites
Python 3.10+
Azure CLI logged in (
az login)Log Analytics Reader role on target workspace(s)
π Quick Start
1. Clone and Install
git clone https://github.com/yourusername/log-analytics-mcp-server.git
cd log-analytics-mcp-server
# Create virtual environment
python -m venv .venv
source .venv/bin/activate # On Windows: .\.venv\Scripts\Activate.ps1
# Install dependencies
pip install -r requirements.txt2. Configure
# Set your Log Analytics workspace ID (the GUID from Azure Portal)
export LOG_ANALYTICS_WORKSPACE_ID="your-workspace-guid"
# Ensure you're logged into Azure
az login3. Test
# Run the test script
python test_mcp.pyExpected output:
============================================================
LOG ANALYTICS MCP SERVER - VALIDATION TEST
============================================================
[1] MCP Server Info:
Server name: log-analytics-mcp-server
Tools registered: 5
[2] Testing list_tables()...
β
SUCCESS - Retrieved table list
Found 5 tables: ['Syslog', 'Perf', 'Heartbeat', ...]
[3] Testing query_logs()...
β
SUCCESS - Query executed
============================================================
VALIDATION COMPLETE
============================================================π Integration
VS Code / GitHub Copilot
Add to .vscode/mcp.json:
{
"servers": {
"log-analytics": {
"type": "stdio",
"command": "python",
"args": ["-c", "from server import mcp; mcp.run(transport='stdio')"],
"cwd": "/path/to/log-analytics-mcp-server",
"env": {
"LOG_ANALYTICS_WORKSPACE_ID": "your-workspace-guid"
}
}
}
}Claude Desktop
Add to claude_desktop_config.json:
{
"mcpServers": {
"log-analytics": {
"command": "python",
"args": ["-c", "from server import mcp; mcp.run(transport='stdio')"],
"cwd": "/path/to/log-analytics-mcp-server",
"env": {
"LOG_ANALYTICS_WORKSPACE_ID": "your-workspace-guid"
}
}
}
}Azure SRE Agent
Add to your agent's MCP configuration:
mcp_servers:
- name: log-analytics
command: python
args: ["-c", "from server import mcp; mcp.run(transport='stdio')"]
cwd: /path/to/log-analytics-mcp-server
transport: stdio
environment:
LOG_ANALYTICS_WORKSPACE_ID: "your-workspace-guid"π Example Usage
Once configured, you can ask your AI assistant:
"Show me errors from my Log Analytics workspace in the last hour"
"What VMs are sending heartbeats to my workspace?"
"Query Syslog for any critical errors from web-vm"
"Analyze the performance metrics for my database server"
Direct Python Usage
from server import query_logs, list_tables, check_vm_health
# List available tables
print(list_tables())
# Query for recent errors
result = query_logs(
query="Syslog | where SeverityLevel == 'err' | take 10",
timespan="PT1H" # Last 1 hour
)
print(result)
# Check VM health
print(check_vm_health())ποΈ Architecture
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β AI Assistant β
β (GitHub Copilot, Claude, SRE Agent) β
β β
β "Show me errors from app-vm in the last hour" β
βββββββββββββββββββββββ¬ββββββββββββββββββββββββββββββββββββββββ
β MCP Protocol (JSON-RPC over STDIO)
βΌ
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β Log Analytics MCP Server β
β β
β βββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
β β Tools: β β
β β β’ query_logs - Execute KQL queries β β
β β β’ list_tables - Show available tables β β
β β β’ get_workspace_info - Workspace metadata β β
β β β’ analyze_errors - Error pattern analysis β β
β β β’ check_vm_health - VM health dashboard β β
β βββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
β β β
β β azure-monitor-query SDK β
β βΌ β
β βββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
β β Azure Monitor Query Client β β
β β (DefaultAzureCredential) β β
β βββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
βββββββββββββββββββββββ¬ββββββββββββββββββββββββββββββββββββββββ
β Azure Monitor Query API
βΌ
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β Log Analytics Workspace β
β β
β Tables: Syslog, Perf, Heartbeat, ContainerLog, Event, etc. β
β β
β Data from: VMs, Containers, Azure resources β
β (including private VNet resources via Private Link) β
βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββπ Authentication
This server uses DefaultAzureCredential which tries these methods in order:
Environment variables (
AZURE_CLIENT_ID,AZURE_TENANT_ID,AZURE_CLIENT_SECRET)Azure CLI (
az login)Azure Developer CLI (
azd auth login)Managed Identity (when running in Azure)
Visual Studio Code credential
Azure PowerShell (
Connect-AzAccount)
For local development, az login is the easiest option.
π Common KQL Queries
Find recent errors
Syslog
| where SeverityLevel in ('err', 'crit', 'alert', 'emerg')
| project TimeGenerated, Computer, Facility, SyslogMessage
| order by TimeGenerated desc
| take 20Check VM heartbeats
Heartbeat
| summarize LastHeartbeat = max(TimeGenerated) by Computer
| extend MinutesAgo = datetime_diff('minute', now(), LastHeartbeat)
| order by MinutesAgo descPerformance analysis
Perf
| where ObjectName == 'Processor' and CounterName == '% Processor Time'
| summarize AvgCPU = avg(CounterValue) by Computer, bin(TimeGenerated, 5m)
| order by TimeGenerated descContainer logs
ContainerLog
| where LogEntrySource == 'stderr'
| project TimeGenerated, ContainerID, LogEntry
| order by TimeGenerated desc
| take 50π§ Configuration Options
Environment Variable | Required | Description |
| Yes | The GUID of your Log Analytics workspace |
| No* | API key for authentication (required for remote deployment) |
| No | Custom header name for API key (default: |
| No | Azure AD tenant ID (for service principal auth) |
| No | Service principal client ID |
| No | Service principal secret |
π Remote Deployment (Azure Container Apps)
For production use with Azure SRE Agent or other remote MCP clients, deploy this server to Azure Container Apps.
Prerequisites
Azure CLI installed and logged in (
az login)Docker (for local testing only)
An Azure subscription
Step 1: Create Azure Resources
# Set variables
RESOURCE_GROUP="log-analytics-mcp-rg"
LOCATION="eastus2"
ACR_NAME="yourregistryname" # Must be globally unique
CONTAINER_APP_NAME="log-analytics-mcp"
WORKSPACE_ID="your-log-analytics-workspace-guid"
API_KEY=$(openssl rand -base64 32 | tr -d '/+=' | head -c 32)
# Create resource group
az group create --name $RESOURCE_GROUP --location $LOCATION
# Create container registry
az acr create --resource-group $RESOURCE_GROUP --name $ACR_NAME --sku Basic --admin-enabled true
# Create container apps environment
az containerapp env create \
--name "${CONTAINER_APP_NAME}-env" \
--resource-group $RESOURCE_GROUP \
--location $LOCATIONStep 2: Build and Push Container Image
# Build image in ACR (from the log-analytics-mcp-server directory)
az acr build --registry $ACR_NAME --image log-analytics-mcp:v1 .Step 3: Deploy Container App
# Get ACR credentials
ACR_PASSWORD=$(az acr credential show --name $ACR_NAME --query "passwords[0].value" -o tsv)
# Create container app with managed identity
az containerapp create \
--name $CONTAINER_APP_NAME \
--resource-group $RESOURCE_GROUP \
--environment "${CONTAINER_APP_NAME}-env" \
--image "${ACR_NAME}.azurecr.io/log-analytics-mcp:v1" \
--target-port 8000 \
--ingress external \
--min-replicas 1 \
--max-replicas 10 \
--cpu 0.5 \
--memory 1.0Gi \
--registry-server "${ACR_NAME}.azurecr.io" \
--registry-username $ACR_NAME \
--registry-password "$ACR_PASSWORD" \
--env-vars \
"LOG_ANALYTICS_WORKSPACE_ID=$WORKSPACE_ID" \
"MCP_API_KEY=$API_KEY" \
--system-assigned
# Get the container app URL
FQDN=$(az containerapp show --name $CONTAINER_APP_NAME --resource-group $RESOURCE_GROUP --query "properties.configuration.ingress.fqdn" -o tsv)
echo "MCP Server URL: https://${FQDN}/mcp/"
echo "Health Check: https://${FQDN}/health"
echo "API Key: $API_KEY"Step 4: Grant Log Analytics Access
# Get managed identity principal ID
PRINCIPAL_ID=$(az containerapp show --name $CONTAINER_APP_NAME --resource-group $RESOURCE_GROUP --query "identity.principalId" -o tsv)
# Grant Log Analytics Reader role on the workspace
# Replace with your Log Analytics workspace resource ID
LA_RESOURCE_ID="/subscriptions/YOUR_SUB/resourceGroups/YOUR_RG/providers/Microsoft.OperationalInsights/workspaces/YOUR_WORKSPACE"
az role assignment create \
--assignee $PRINCIPAL_ID \
--role "Log Analytics Reader" \
--scope $LA_RESOURCE_IDStep 5: Test the Deployment
# Test health endpoint
curl "https://${FQDN}/health"
# Test MCP initialization
curl -X POST "https://${FQDN}/mcp/" \
-H "X-API-Key: $API_KEY" \
-H "Content-Type: application/json" \
-H "Accept: application/json, text/event-stream" \
-d '{"jsonrpc":"2.0","id":1,"method":"initialize","params":{"protocolVersion":"2024-11-05","capabilities":{},"clientInfo":{"name":"test","version":"1.0"}}}'
# List available tools
curl -X POST "https://${FQDN}/mcp/" \
-H "X-API-Key: $API_KEY" \
-H "Content-Type: application/json" \
-H "Accept: application/json, text/event-stream" \
-d '{"jsonrpc":"2.0","id":2,"method":"tools/list","params":{}}'Remote Integration Examples
Azure SRE Agent
Configure in the SRE Agent portal:
Setting | Value |
Name |
|
Transport |
|
URL |
|
Authentication |
|
Header Name |
|
API Key | Your generated API key |
Remote MCP Client Configuration
For any MCP client that supports HTTP transport:
{
"servers": {
"log-analytics": {
"type": "http",
"url": "https://your-app.azurecontainerapps.io/mcp/",
"headers": {
"X-API-Key": "your-api-key"
}
}
}
}Updating the Deployment
# Build new version
az acr build --registry $ACR_NAME --image log-analytics-mcp:v2 .
# Update container app
az containerapp update \
--name $CONTAINER_APP_NAME \
--resource-group $RESOURCE_GROUP \
--image "${ACR_NAME}.azurecr.io/log-analytics-mcp:v2"π VNet Deployment (Private Link Scenarios)
When your Log Analytics workspace is protected by Private Link with publicNetworkAccessForQuery: Disabled, external queries are blocked. Deploy this MCP server inside the VNet to act as a trusted query proxy.
Why This Matters
External Query β Log Analytics β BLOCKED by Private Link
VNet MCP β Log Analytics β
ALLOWED via Private Endpoint
SRE Agent β VNet MCP β
HTTPS (Streamable HTTP)VNet-Integrated Deployment
# Create VNet-integrated Container Apps environment
az containerapp env create \
--name vnet-test-env \
--resource-group $RESOURCE_GROUP \
--location eastus \
--infrastructure-subnet-resource-id "/subscriptions/.../subnets/infrastructure"
# Create ACR (VNet environments can't pull from public registries)
az acr create --resource-group $RESOURCE_GROUP --name $ACR_NAME --sku Basic
# Build and push image to ACR
az acr build --registry $ACR_NAME --image log-analytics-mcp:latest .
# Deploy with Managed Identity
az containerapp create \
--name log-analytics-mcp-vnet \
--resource-group $RESOURCE_GROUP \
--environment vnet-test-env \
--image "${ACR_NAME}.azurecr.io/log-analytics-mcp:latest" \
--target-port 8000 \
--ingress external \
--env-vars "LOG_ANALYTICS_WORKSPACE_ID=$WORKSPACE_ID" "MCP_API_KEY=$API_KEY" \
--system-assigned \
--registry-server "${ACR_NAME}.azurecr.io"
# Grant Log Analytics Reader role to Container App's Managed Identity
PRINCIPAL_ID=$(az containerapp show --name log-analytics-mcp-vnet --resource-group $RESOURCE_GROUP --query "identity.principalId" -o tsv)
az role assignment create \
--assignee $PRINCIPAL_ID \
--role "Log Analytics Reader" \
--scope "/subscriptions/.../workspaces/$WORKSPACE_NAME"Testing Private Link Blocking
# Test from OUTSIDE VNet (should fail if Private Link is properly configured)
curl -X POST "https://log-analytics-mcp-outside.azurecontainerapps.io/mcp/" \
-H "Content-Type: application/json" \
-H "Accept: application/json, text/event-stream" \
-H "X-API-Key: $API_KEY" \
-d '{"jsonrpc":"2.0","method":"tools/call","params":{"name":"list_tables"},"id":1}'
# Result: InsufficientAccessError - blocked by Private Link β
# Test from INSIDE VNet (should succeed)
curl -X POST "https://log-analytics-mcp-vnet.azurecontainerapps.io/mcp/" \
-H "Content-Type: application/json" \
-H "Accept: application/json, text/event-stream" \
-H "X-API-Key: $API_KEY" \
-d '{"jsonrpc":"2.0","method":"tools/call","params":{"name":"list_tables"},"id":1}'
# Result: SUCCESS β
- tables returnedPrivate Link Configuration
For complete query blocking, configure:
# 1. Create AMPLS with Private Only mode
az monitor private-link-scope create --name my-ampls --resource-group $RESOURCE_GROUP
az monitor private-link-scope update --name my-ampls --resource-group $RESOURCE_GROUP \
--query-access PrivateOnly
# 2. Disable public query access on workspace
az monitor log-analytics workspace update \
--resource-group $RESOURCE_GROUP \
--workspace-name $WORKSPACE_NAME \
--set properties.publicNetworkAccessForQuery=Disabledπ§ͺ Development
Run tests
python test_mcp.pyRun with SSE transport (for web integrations)
python -c "from server import mcp; mcp.run(transport='sse')"
# Server starts on http://localhost:8000/sseTest with MCP Inspector
npx @modelcontextprotocol/inspector python -c "from server import mcp; mcp.run(transport='stdio')"π License
MIT License - see LICENSE for details.
π€ Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
π Related Resources
This server cannot be installed
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Latest Blog Posts
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/BandaruDheeraj/log-analytics-mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server