Purchase Reliability Kusto — VS Code Extension

MCP server extension for querying Purchase Reliability data from Azure Data Explorer (Kusto), directly inside GitHub Copilot Chat.

Features

Tool	Description
`get_sample_queries`	Returns schema, table descriptions, and sample KQL query patterns
`validate_kql`	Validates a KQL query for dangerous commands and syntax errors
`query_kusto_live`	Executes a validated KQL query on Azure Data Explorer
`kusto_get_schema`	Returns column names and types for a given Kusto table
`kusto_list_tables`	Lists all tables in the target Kusto database

Install from the .vsix file:

code --install-extension purchase-reliability-kusto-0.1.0.vsix

Reload VS Code — the extension activates automatically, sets up a Python virtual environment, and registers the MCP server.

npm install
npm run compile
npm run package   # produces .vsix

Once installed, the MCP tools are available to Copilot in any workspace. Ask Copilot things like:

The server runs over stdio and authenticates to Kusto using DefaultAzureCredential (picks up your az login session or managed identity).

Environment variables (optional — defaults target the Purchase Reliability cluster):

Variable	Default
`KUSTO_CLUSTER`	`https://kusto.aria.microsoft.com`
`KUSTO_ENTRY_DATABASE`	`b68e3c09968047b0a3d76c3e2cb6d39d`
`KUSTO_DATABASE`	`Office Android`
`KUSTO_DATABASE_CLUSTER`	`oariashared`