QueryCommand.cs•3.3 kB
// Copyright (c) Microsoft Corporation.
// Licensed under the MIT License.
using AzureMcp.Core.Commands;
using AzureMcp.Core.Services.Telemetry;
using AzureMcp.Kusto.Options;
using AzureMcp.Kusto.Services;
using Microsoft.Extensions.Logging;
namespace AzureMcp.Kusto.Commands;
public sealed class QueryCommand(ILogger<QueryCommand> logger) : BaseDatabaseCommand<QueryOptions>()
{
private const string CommandTitle = "Query Kusto Database";
private readonly ILogger<QueryCommand> _logger = logger;
private readonly Option<string> _queryOption = KustoOptionDefinitions.Query;
protected override void RegisterOptions(Command command)
{
base.RegisterOptions(command);
command.AddOption(_queryOption);
}
protected override QueryOptions BindOptions(ParseResult parseResult)
{
var options = base.BindOptions(parseResult);
options.Query = parseResult.GetValueForOption(_queryOption);
return options;
}
public override string Name => "query";
public override string Description =>
"""
Execute a KQL against items in a Kusto cluster.
Requires `cluster-uri` (or `cluster` and `subscription`), `database`, and `query`.
Results are returned as a JSON array of documents, for example: `[{'Column1': val1, 'Column2': val2}, ...]`.
""";
public override string Title => CommandTitle;
public override ToolMetadata Metadata => new() { Destructive = false, ReadOnly = true };
public override async Task<CommandResponse> ExecuteAsync(CommandContext context, ParseResult parseResult)
{
var options = BindOptions(parseResult);
try
{
if (!Validate(parseResult.CommandResult, context.Response).IsValid)
{
return context.Response;
}
List<JsonElement> results = [];
var kusto = context.GetService<IKustoService>();
if (UseClusterUri(options))
{
results = await kusto.QueryItems(
options.ClusterUri!,
options.Database!,
options.Query!,
options.Tenant,
options.AuthMethod,
options.RetryPolicy);
}
else
{
results = await kusto.QueryItems(
options.Subscription!,
options.ClusterName!,
options.Database!,
options.Query!,
options.Tenant,
options.AuthMethod,
options.RetryPolicy);
}
context.Response.Results = results?.Count > 0 ?
ResponseResult.Create(new QueryCommandResult(results), KustoJsonContext.Default.QueryCommandResult) :
null;
}
catch (Exception ex)
{
_logger.LogError(ex, "An exception occurred querying Kusto. Cluster: {Cluster}, Database: {Database},"
+ " Query: {Query}", options.ClusterUri ?? options.ClusterName, options.Database, options.Query);
HandleException(context, ex);
}
return context.Response;
}
internal record QueryCommandResult(List<JsonElement> Items);
}