convez.ai
MCP ServerDados & AnalyticsIniciante
johnib

Kusto MCP Server

johnib/kusto-mcp

Transforme seu assistente IA em analista de dados para Azure Data Explorer

Ver no GitHub
BomPluginScore · de 0 a 100

MCP server que integra Azure Data Explorer (Kusto) com assistentes de IA, permitindo explorar e consultar dados de telemetria usando linguagem natural. Converte perguntas em português ou inglês em queries KQL automáticas, eliminando a necessidade de conhecimento técnico prévio.

Instalação

$npx convez-ai johnib/kusto-mcp

1 comando no terminal: detecta o formato do repositório (marketplace ou plugin avulso) e instala via Claude Code. Requer Node 18+ e o Claude Code instalado.

Métricas

Estrelas
8
Forks
6
Acompanhando
1
Saúde
42%
Último commit
há 6 dias
Versão
v1.20.1
Issues abertas
17
Contribuidores
5

Casos de uso

  • Análise de logs de erro e telemetria em linguagem natural
  • Investigação de incidentes de segurança (autenticação, acessos)
  • Consultas de métricas de negócio e receita sem escrever KQL
  • Sumarização automática de tendências de performance e monitoramento

Veredito

MCP server robusto e bem documentado que democratiza acesso a dados em Azure Data Explorer. Setup simples com suporte nativo a múltiplos clientes IA (Claude, Cline, Cursor). Ideal para equipes que precisam explorar telemetria sem expertise em KQL.

README

A tradução para o português deste README ainda está na fila.

🔍 Kusto MCP Server

CI npm version npm downloads

Turn your AI assistant into a data analyst in 2 minutes.

Connect Cline, Cursor, Claude Desktop, or any AI tool to Azure Data Explorer. Ask questions in plain English, get insights from your data instantly - no KQL knowledge required.

What You Can Do

  • "Show me error logs from the last hour" → Get instant insights from telemetry data
  • "Which customers generated the most revenue this month?" → Analyze business metrics effortlessly
  • "Find all failed authentication attempts" → Investigate security incidents with AI help
  • "Summarize system performance trends" → Get automated analysis of monitoring data

No more writing complex KQL queries. Just ask your AI assistant natural questions about your data.

Quick Setup

For Claude Code Users

Run this terminal command to install:

claude mcp add kusto-mcp -- npx -y kusto-mcp@latest

For Cline Users

Add this to your cline_mcp_settings.json file:

{
  "mcpServers": {
    "github.com/johnib/kusto-mcp": {
      "command": "npx",
      "args": ["-y", "kusto-mcp@latest"],
      "env": {},
      "disabled": false,
      "autoApprove": [
        "initialize-connection",
        "show-tables",
        "show-table",
        "execute-query"
      ]
    }
  }
}

For Cursor Users

Add this to your VS Code settings.json:

{
  "mcp": {
    "servers": {
      "github.com/johnib/kusto-mcp": {
        "type": "stdio",
        "command": "npx",
        "args": ["-y", "kusto-mcp"]
      }
    }
  }
}

For Claude Desktop Users

Add this to your Claude Desktop configuration file:

{
  "mcpServers": {
    "kusto-mcp": {
      "command": "npx",
      "args": ["-y", "kusto-mcp"]
    }
  }
}

Authentication Setup

  1. Install Azure CLI (if you haven't already):

    # Windows
    winget install Microsoft.AzureCLI
    
    # macOS
    brew install azure-cli
    
    # Linux
    curl -sL https://aka.ms/InstallAzureCLIDeb | sudo bash
    
  2. Login to Azure:

    az login
    
  3. That's it! Your AI assistant can now connect to your Azure Data Explorer clusters.

Test It Works

Ask your AI assistant:

"Connect to my Azure Data Explorer cluster at https://your-cluster.kusto.windows.net and show me the available tables"

You should see your AI successfully connect and list your database tables.

Supported AI Tools

  • ✅ Claude Code - One-command setup with native MCP support
  • ✅ Cline - Full support with auto-approval
  • ✅ Cursor - Complete integration
  • ✅ Claude Desktop - Native MCP support
  • ✅ VS Code with MCP - Built-in compatibility
  • ✅ Any MCP-compatible tool - Universal support

Common Issues

🔒 Permission denied?

  • Run az login and make sure you have access to the Azure Data Explorer cluster
  • Verify you're logged into the correct Azure tenant

🔌 Can't connect to cluster?

  • Double-check the cluster URL format: https://your-cluster.kusto.windows.net
  • Ensure the cluster is accessible from your network

❓ AI doesn't see the tools?

  • Restart your AI assistant after adding the configuration
  • Check that the JSON configuration is valid (use a JSON validator)

Still stuck? → Open an issue or check our troubleshooting guide.

What's Under the Hood

This MCP server provides your AI assistant with tools to:

  • Initialize connections to Azure Data Explorer clusters
  • Browse database tables and schemas
  • Execute KQL queries with intelligent result limiting
  • Handle authentication securely through Azure CLI

Results are automatically formatted and sized appropriately for AI context windows, so your assistant gets the data it needs without being overwhelmed.

Advanced Configuration

Need custom settings? Check out our Configuration Guide for:

  • Response format options (JSON vs Markdown)
  • Query timeout settings
  • Result size limiting
  • OpenTelemetry integration

For Developers

Building, testing, or contributing? See our Developer Documentation for:

  • Building from source
  • Running tests
  • Project structure
  • Contributing guidelines

License

MIT


💡 Pro tip: Start by asking your AI to "show me the tables in my database" to explore what data you have available, then ask natural language questions about specific tables.

Ver o original no GitHub

Bom para

Relacionados