in src/Commands/Postgres/Server/ServerListCommand.cs [15:51]
public sealed class ServerListCommand(ILogger<ServerListCommand> logger) : BasePostgresCommand<ServerListArguments>(logger)
{
protected override string GetCommandName() => "list";
protected override string GetCommandDescription() =>
"Lists all PostgreSQL servers in the specified subscription.";
[McpServerTool(Destructive = false, ReadOnly = true)]
public override async Task<CommandResponse> ExecuteAsync(CommandContext context, ParseResult parseResult)
{
try
{
var args = BindArguments(parseResult);
if (!await ProcessArguments(context, args))
{
return context.Response;
}
IPostgresService pgService = context.GetService<IPostgresService>() ?? throw new InvalidOperationException("PostgreSQL service is not available.");
List<string> servers = await pgService.ListServersAsync(args.Subscription!, args.ResourceGroup!, args.User!);
context.Response.Results = servers?.Count > 0 ?
ResponseResult.Create(
new ServerListCommandResult(servers),
PostgresJsonContext.Default.ServerListCommandResult) :
null;
}
catch (Exception ex)
{
_logger.LogError(ex, "An exception occurred while listing servers");
HandleException(context.Response, ex);
}
return context.Response;
}
internal record ServerListCommandResult(List<string> Servers);
}