using System.ComponentModel;
using ModelContextProtocol.Server;
using SqlAugur.Services;
namespace SqlAugur.Tools;
[McpServerToolType]
public sealed class GetMermaidDiagramTool
{
private readonly IDiagramService _diagramService;
private readonly IRateLimitingService _rateLimiter;
public GetMermaidDiagramTool(IDiagramService diagramService, IRateLimitingService rateLimiter)
{
_diagramService = diagramService;
_rateLimiter = rateLimiter;
}
[McpServerTool(
Name = "get_mermaid_diagram",
Title = "Get Mermaid ER Diagram",
ReadOnly = false,
Idempotent = false)]
[Description("Generate a Mermaid ER diagram saved to a file. Shows tables, columns, PKs, and FK relationships with smart cardinality.")]
public async Task<string> GetDiagram(
[Description("Server name from list_servers")] string serverName,
[Description("Database name from list_databases")] string databaseName,
[Description("File path for output (e.g. '/tmp/diagram.mmd')")] string outputPath,
[Description("Optional comma-separated schemas to include (e.g. 'dbo,sales'). Overrides excludeSchemas.")] string? includeSchemas = null,
[Description("Optional comma-separated schemas to exclude (e.g. 'audit,staging'). Ignored if includeSchemas set.")] string? excludeSchemas = null,
[Description("Optional comma-separated tables to include (e.g. 'Users,Orders'). Overrides excludeTables.")] string? includeTables = null,
[Description("Optional comma-separated tables to exclude. Ignored if includeTables set.")] string? excludeTables = null,
[Description("Max tables to include (1-200, default 50)")] int maxTables = 50,
[Description("true/false. Show only PK/FK columns without non-key columns")] bool compact = false,
CancellationToken cancellationToken = default)
{
maxTables = Math.Clamp(maxTables, 1, 200);
var mermaid = await ToolHelper.ExecuteAsync(_rateLimiter, () =>
_diagramService.GenerateMermaidDiagramAsync(
serverName, databaseName,
ToolHelper.ParseCommaSeparatedList(includeSchemas), ToolHelper.ParseCommaSeparatedList(excludeSchemas),
ToolHelper.ParseCommaSeparatedList(includeTables), ToolHelper.ParseCommaSeparatedList(excludeTables),
maxTables, cancellationToken, compact), cancellationToken);
return await ToolHelper.SaveToFileAsync(mermaid, outputPath, ".mmd", "Mermaid diagram", cancellationToken);
}
}
