{"id":74436,"date":"2026-02-09T20:05:31","date_gmt":"2026-02-09T12:05:31","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/74436.html"},"modified":"2026-02-09T20:05:31","modified_gmt":"2026-02-09T12:05:31","slug":"net-%e5%bc%80%e5%8f%91-mcp-%e6%9c%8d%e5%8a%a1%e5%99%a8%e5%ae%8c%e5%85%a8%e6%8c%87%e5%8d%97%ef%bc%9a%e6%89%93%e9%80%a0%e6%99%ba%e8%83%bd%e6%95%b0%e6%8d%ae%e5%ba%93%e6%9f%a5%e8%af%a2%e5%8a%a9%e6%89%8b","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/74436.html","title":{"rendered":".NET \u5f00\u53d1 MCP \u670d\u52a1\u5668\u5b8c\u5168\u6307\u5357\uff1a\u6253\u9020\u667a\u80fd\u6570\u636e\u5e93\u67e5\u8be2\u52a9\u624b"},"content":{"rendered":"

\u5f53 AI \u52a9\u624b\u4e0d\u518d\u53ea\u662f\u751f\u6210 SQL \u8bed\u53e5，\u800c\u662f\u80fd\u591f\u76f4\u63a5\u8fde\u63a5\u4f60\u7684\u6570\u636e\u5e93\u3001\u67e5\u8be2\u6570\u636e\u3001\u5206\u6790\u7ed3\u6784\u2014\u2014\u8fd9\u5c31\u662f MCP \u4e3a .NET \u5f00\u53d1\u8005\u5e26\u6765\u7684\u5168\u65b0\u53ef\u80fd\u3002<\/p>\n

\u4e00\u3001MCP \u662f\u4ec0\u4e48？\u4e3a\u4ec0\u4e48 .NET \u5f00\u53d1\u8005\u5e94\u8be5\u5173\u6ce8？<\/h3>\n

1.1 MCP \u534f\u8bae\u7b80\u4ecb<\/h4>\n

MCP（Model Context Protocol，\u6a21\u578b\u4e0a\u4e0b\u6587\u534f\u8bae） \u662f\u7531 Anthropic \u63a8\u51fa\u7684\u5f00\u6e90\u6807\u51c6\u534f\u8bae，\u65e8\u5728\u4e3a\u5927\u8bed\u8a00\u6a21\u578b（LLM）\u4e0e\u5916\u90e8\u5de5\u5177\u548c\u6570\u636e\u6e90\u4e4b\u95f4\u5efa\u7acb\u7edf\u4e00\u7684\u8fde\u63a5\u65b9\u5f0f\u3002\u4f60\u53ef\u4ee5\u628a\u5b83\u7406\u89e3\u4e3a \u201cAI \u4e16\u754c\u7684 USB-C \u63a5\u53e3\u201d\u2014\u2014\u4e00\u4e2a\u6807\u51c6\u5316\u7684\u534f\u8bae，\u8ba9\u4e0d\u540c\u7684 AI \u52a9\u624b（Cursor\u3001VS Code Copilot\u3001Claude Desktop \u7b49）\u80fd\u591f\u4ee5\u7edf\u4e00\u7684\u65b9\u5f0f\u8c03\u7528\u5404\u79cd\u5916\u90e8\u5de5\u5177\u3002<\/p>\n

\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510 MCP \u534f\u8bae \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 AI \u5ba2\u6237\u7aef \u2502 \u25c4\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u25ba \u2502 MCP \u670d\u52a1\u5668 \u2502
\n\u2502 (Cursor\/Copilot)\u2502 JSON-RPC \u2502 (.NET \u5e94\u7528) \u2502
\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518 \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518
\n \u2502
\n \u250c\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2510
\n \u2502 \u6570\u636e\u5e93 \u2502
\n \u2502 API \u2502
\n \u2502 \u6587\u4ef6\u7cfb\u7edf \u2502
\n \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/p>\n

1.2 MCP \u7684\u6838\u5fc3\u6982\u5ff5<\/h4>\n

MCP \u534f\u8bae\u5b9a\u4e49\u4e86\u4e09\u79cd\u6838\u5fc3\u80fd\u529b：<\/p>\n\n\u80fd\u529b\u8bf4\u660e\u793a\u4f8b<\/tr>\n\n\n\n\n
Tools（\u5de5\u5177）<\/td>\n\u53ef\u88ab AI \u8c03\u7528\u7684\u51fd\u6570<\/td>\n\u67e5\u8be2\u6570\u636e\u5e93\u3001\u8c03\u7528 API\u3001\u6267\u884c\u8ba1\u7b97<\/td>\n<\/tr>\n
Resources（\u8d44\u6e90）<\/td>\nAI \u53ef\u8bfb\u53d6\u7684\u6570\u636e\u6e90<\/td>\n\u6570\u636e\u5e93 Schema\u3001\u914d\u7f6e\u6587\u4ef6\u3001\u6587\u6863<\/td>\n<\/tr>\n
Prompts（\u63d0\u793a\u6a21\u677f）<\/td>\n\u9884\u5b9a\u4e49\u7684\u63d0\u793a\u8bcd\u6a21\u677f<\/td>\nSQL \u751f\u6210\u6a21\u677f\u3001\u62a5\u8868\u5206\u6790\u6a21\u677f<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

1.3 \u4e3a\u4ec0\u4e48\u9009\u62e9 .NET \u5f00\u53d1 MCP \u670d\u52a1\u5668？<\/h4>\n

\u4f5c\u4e3a .NET \u5f00\u53d1\u8005，\u4f60\u6709\u4ee5\u4e0b\u4f18\u52bf：<\/p>\n

    \n
  • \u5b98\u65b9 C# SDK：\u5fae\u8f6f\u4e0e Anthropic \u8054\u5408\u7ef4\u62a4\u7684 \u5b98\u65b9 C# SDK，\u54c1\u8d28\u6709\u4fdd\u969c<\/li>\n
  • \u5f3a\u5927\u7684\u4f9d\u8d56\u6ce8\u5165：\u5b8c\u7f8e\u6574\u5408 Microsoft.Extensions.DependencyInjection，\u5929\u7136\u652f\u6301 IoC<\/li>\n
  • Entity Framework Core：\u4e0e EF Core \u65e0\u7f1d\u7ed3\u5408，\u8f7b\u677e\u5b9e\u73b0\u6570\u636e\u5e93\u64cd\u4f5c<\/li>\n
  • \u4e30\u5bcc\u7684\u751f\u6001：\u53ef\u76f4\u63a5\u590d\u7528\u73b0\u6709\u7684 .NET \u670d\u52a1\u3001\u4e2d\u95f4\u4ef6\u3001\u8ba4\u8bc1\u4f53\u7cfb<\/li>\n
  • \u9ad8\u6027\u80fd：.NET \u7684\u5f02\u6b65\u7f16\u7a0b\u6a21\u578b\u548c AOT \u7f16\u8bd1\u652f\u6301，\u786e\u4fdd MCP \u670d\u52a1\u5668\u7684\u9ad8\u54cd\u5e94\u6027<\/li>\n
  • \u591a\u79cd\u90e8\u7f72\u65b9\u5f0f：\u652f\u6301\u672c\u5730 stdio\u3001SSE（HTTP）\u3001Docker \u5bb9\u5668\u7b49\u591a\u79cd\u4f20\u8f93\u65b9\u5f0f<\/li>\n<\/ul>\n

    GitHub \u4ed3\u5e93：https:\/\/github.com\/modelcontextprotocol\/csharp-sdk NuGet \u5305：https:\/\/www.nuget.org\/packages\/ModelContextProtocol<\/p>\n

    \n

    \u4e8c\u3001\u73af\u5883\u51c6\u5907<\/h3>\n

    2.1 \u5f00\u53d1\u5de5\u5177<\/h4>\n\n\u5de5\u5177\u8981\u6c42\u8bf4\u660e<\/tr>\n\n\n\n\n\n
    .NET SDK<\/td>\n8.0+ （\u63a8\u8350 10.0）<\/td>\nMCP SDK \u652f\u6301 .NET 8.0 \u53ca\u4ee5\u4e0a\u7248\u672c<\/td>\n<\/tr>\n
    IDE<\/td>\nVisual Studio 2022 \/ VS Code \/ Cursor<\/td>\n\u4efb\u9009\u5176\u4e00<\/td>\n<\/tr>\n
    AI \u5ba2\u6237\u7aef<\/td>\nCursor \/ VS Code + GitHub Copilot<\/td>\n\u7528\u4e8e\u6d4b\u8bd5 MCP \u670d\u52a1\u5668<\/td>\n<\/tr>\n
    \u6570\u636e\u5e93<\/td>\nSQL Server \/ SQLite<\/td>\n\u672c\u6587\u4f7f\u7528 SQLite \u4f5c\u4e3a\u6f14\u793a<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    2.2 \u5b89\u88c5 NuGet \u5305<\/h4>\n

    MCP C# SDK \u7531\u4e09\u4e2a\u5305\u7ec4\u6210：<\/p>\n

    # \u4e3b\u5305（\u63a8\u8350）：\u5305\u542b\u5bbf\u4e3b\u548c\u4f9d\u8d56\u6ce8\u5165\u6269\u5c55<\/span>
    \ndotnet add<\/span> package ModelContextProtocol –prerelease<\/p>\n

    # ASP.NET Core \u6269\u5c55（\u7528\u4e8e HTTP\/SSE \u4f20\u8f93）<\/span>
    \ndotnet add<\/span> package ModelContextProtocol.AspNetCore –prerelease<\/p>\n

    # \u6838\u5fc3\u5305（\u6700\u5c0f\u4f9d\u8d56，\u9002\u7528\u4e8e\u5e95\u5c42 API）<\/span>
    \ndotnet add<\/span> package ModelContextProtocol.Core –prerelease<\/p>\n

    \u6ce8\u610f：\u622a\u81f3 2026 \u5e74\u521d，MCP C# SDK \u4ecd\u5904\u4e8e\u9884\u89c8\u7248（\u5f53\u524d\u7248\u672c 0.8.0-preview.1），API \u53ef\u80fd\u4f1a\u53d8\u5316\u3002<\/p>\n

    2.3 \u4f7f\u7528\u9879\u76ee\u6a21\u677f（.NET 10+）<\/h4>\n

    \u5982\u679c\u4f60\u4f7f\u7528 .NET 10 SDK，\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528\u5b98\u65b9\u9879\u76ee\u6a21\u677f\u5feb\u901f\u521b\u5efa：<\/p>\n

    # \u5b89\u88c5 MCP Server \u9879\u76ee\u6a21\u677f<\/span>
    \ndotnet new install<\/span> Microsoft.McpServer.ProjectTemplates<\/p>\n

    # \u521b\u5efa\u65b0\u7684 MCP \u670d\u52a1\u5668\u9879\u76ee<\/span>
    \ndotnet new mcpserver -n MyDbMcpServer<\/p>\n

    \n

    \u4e09\u3001\u5b9e\u6218：\u6784\u5efa\u6570\u636e\u5e93\u67e5\u8be2 MCP \u670d\u52a1\u5668<\/h3>\n

    3.1 \u9879\u76ee\u6982\u8ff0<\/h4>\n

    \u6211\u4eec\u5c06\u6784\u5efa\u4e00\u4e2a\u540d\u4e3a DbQueryMCP \u7684 MCP \u670d\u52a1\u5668，\u5b83\u53ef\u4ee5：<\/p>\n

      \n
    • \u67e5\u8be2\u6570\u636e\u5e93\u4e2d\u6240\u6709\u7684\u8868\u7ed3\u6784\u4fe1\u606f<\/li>\n
    • \u6839\u636e\u8868\u540d\u83b7\u53d6\u5b57\u6bb5\u8be6\u60c5<\/li>\n
    • \u6267\u884c\u5b89\u5168\u7684 SELECT \u67e5\u8be2\u5e76\u8fd4\u56de\u7ed3\u679c<\/li>\n
    • \u83b7\u53d6\u8868\u7684\u6570\u636e\u7edf\u8ba1\u6458\u8981<\/li>\n
    • \u6839\u636e\u81ea\u7136\u8bed\u8a00\u63cf\u8ff0\u751f\u6210 SQL \u67e5\u8be2\u5efa\u8bae<\/li>\n<\/ul>\n

      \u8fd9\u5728\u5b9e\u9645\u5f00\u53d1\u4e2d\u975e\u5e38\u6709\u7528\u2014\u2014AI \u52a9\u624b\u53ef\u4ee5\u7406\u89e3\u4f60\u7684\u6570\u636e\u5e93\u7ed3\u6784，\u5e2e\u4f60\u7f16\u5199\u67e5\u8be2\u3001\u5206\u6790\u6570\u636e\u3001\u751f\u6210\u62a5\u8868\u3002<\/p>\n

      3.2 \u521b\u5efa\u9879\u76ee<\/h4>\n

      # \u521b\u5efa\u63a7\u5236\u53f0\u9879\u76ee<\/span>
      \ndotnet new console -n DbQueryMCP<\/p>\n

      # \u8fdb\u5165\u9879\u76ee\u76ee\u5f55<\/span>
      \ncd<\/span> DbQueryMCP<\/p>\n

      # \u6dfb\u52a0\u5fc5\u8981\u7684 NuGet \u5305<\/span>
      \ndotnet add<\/span> package ModelContextProtocol –prerelease
      \ndotnet add<\/span> package Microsoft.Extensions.Hosting
      \ndotnet add<\/span> package Microsoft.Data.Sqlite
      \ndotnet add<\/span> package Dapper<\/p>\n

      \u6211\u4eec\u4f7f\u7528 Dapper \u800c\u975e EF Core，\u56e0\u4e3a\u5bf9\u4e8e\u901a\u7528\u7684\u6570\u636e\u5e93\u67e5\u8be2\u5de5\u5177，Dapper \u7684\u7075\u6d3b\u6027\u66f4\u9002\u5408\u6267\u884c\u52a8\u6001 SQL\u3002<\/p>\n

      3.3 \u9879\u76ee\u7ed3\u6784<\/h4>\n

      DbQueryMCP\/
      \n\u251c\u2500\u2500 Program.cs # \u5e94\u7528\u5165\u53e3\u4e0e MCP \u670d\u52a1\u5668\u914d\u7f6e
      \n\u251c\u2500\u2500 Services\/
      \n\u2502 \u2514\u2500\u2500 DatabaseService.cs # \u6570\u636e\u5e93\u64cd\u4f5c\u670d\u52a1
      \n\u251c\u2500\u2500 Tools\/
      \n\u2502 \u251c\u2500\u2500 SchemaTools.cs # \u6570\u636e\u5e93\u7ed3\u6784\u67e5\u8be2\u5de5\u5177
      \n\u2502 \u2514\u2500\u2500 QueryTools.cs # \u6570\u636e\u67e5\u8be2\u5de5\u5177
      \n\u251c\u2500\u2500 Models\/
      \n\u2502 \u251c\u2500\u2500 TableInfo.cs # \u8868\u4fe1\u606f\u6a21\u578b
      \n\u2502 \u2514\u2500\u2500 ColumnInfo.cs # \u5217\u4fe1\u606f\u6a21\u578b
      \n\u251c\u2500\u2500 DbQueryMCP.csproj # \u9879\u76ee\u6587\u4ef6
      \n\u2514\u2500\u2500 appsettings.json # \u914d\u7f6e\u6587\u4ef6<\/p>\n

      3.4 \u5b9a\u4e49\u6570\u636e\u6a21\u578b<\/h4>\n

      \u9996\u5148，\u5b9a\u4e49\u6211\u4eec\u9700\u8981\u7528\u5230\u7684\u6570\u636e\u6a21\u578b：<\/p>\n

      Models\/TableInfo.cs<\/p>\n

      namespace<\/span> DbQueryMCP.<\/span>Models<\/span>;<\/span><\/p>\n

      \/\/\/ <summary><\/span>
      \n\/\/\/ \u6570\u636e\u5e93\u8868\u4fe1\u606f<\/span>
      \n\/\/\/ <\/summary><\/span>
      \npublic<\/span> record<\/span> TableInfo<\/span>(<\/span>
      \n string<\/span><\/span> TableName,<\/span>
      \n string<\/span><\/span> TableType,<\/span>
      \n int<\/span><\/span> RowCount
      \n)<\/span>;<\/span><\/p>\n

      Models\/ColumnInfo.cs<\/p>\n

      namespace<\/span> DbQueryMCP.<\/span>Models<\/span>;<\/span><\/p>\n

      \/\/\/ <summary><\/span>
      \n\/\/\/ \u6570\u636e\u5e93\u5217\u4fe1\u606f<\/span>
      \n\/\/\/ <\/summary><\/span>
      \npublic<\/span> record<\/span> ColumnInfo<\/span>(<\/span>
      \n string<\/span><\/span> ColumnName,<\/span>
      \n string<\/span><\/span> DataType,<\/span>
      \n bool<\/span><\/span> IsNullable,<\/span>
      \n bool<\/span><\/span> IsPrimaryKey,<\/span>
      \n string<\/span>?<\/span><\/span> DefaultValue
      \n)<\/span>;<\/span><\/p>\n

      3.5 \u7f16\u5199\u6570\u636e\u5e93\u670d\u52a1<\/h4>\n

      Services\/DatabaseService.cs<\/p>\n

      using<\/span> System.<\/span>Data<\/span>;<\/span>
      \nusing<\/span> System.<\/span>Text<\/span>;<\/span>
      \nusing<\/span> System.<\/span>Text.<\/span>RegularExpressions<\/span>;<\/span>
      \nusing<\/span> Dapper<\/span>;<\/span>
      \nusing<\/span> DbQueryMCP.<\/span>Models<\/span>;<\/span>
      \nusing<\/span> Microsoft.<\/span>Data.<\/span>Sqlite<\/span>;<\/span>
      \nusing<\/span> Microsoft.<\/span>Extensions.<\/span>Configuration<\/span>;<\/span>
      \nusing<\/span> Microsoft.<\/span>Extensions.<\/span>Logging<\/span>;<\/span><\/p>\n

      namespace<\/span> DbQueryMCP.<\/span>Services<\/span>;<\/span><\/p>\n

      \/\/\/ <summary><\/span>
      \n\/\/\/ \u6570\u636e\u5e93\u64cd\u4f5c\u670d\u52a1，\u5c01\u88c5\u6240\u6709\u6570\u636e\u5e93\u76f8\u5173\u7684\u64cd\u4f5c<\/span>
      \n\/\/\/ <\/summary><\/span>
      \npublic<\/span> class<\/span> DatabaseService<\/span> :<\/span> IDisposable<\/span><\/span>
      \n{<\/span>
      \n private<\/span> readonly<\/span> string<\/span><\/span> _connectionString;<\/span>
      \n private<\/span> readonly<\/span> ILogger<<\/span>DatabaseService><\/span><\/span> _logger;<\/span>
      \n private<\/span> SqliteConnection?<\/span><\/span> _connection;<\/span><\/p>\n

      public<\/span> DatabaseService<\/span>(<\/span>IConfiguration<\/span> configuration,<\/span> ILogger<<\/span>DatabaseService><\/span><\/span> logger)<\/span>
      \n {<\/span>
      \n _connectionString =<\/span> configuration.<\/span>GetConnectionString<\/span>(<\/span>"DefaultConnection"<\/span>)<\/span>
      \n ??<\/span> "Data Source=sample.db"<\/span>;<\/span>
      \n _logger =<\/span> logger;<\/span>
      \n }<\/span><\/p>\n

      \/\/\/ <summary><\/span>
      \n \/\/\/ \u83b7\u53d6\u6570\u636e\u5e93\u8fde\u63a5（\u61d2\u52a0\u8f7d）<\/span>
      \n \/\/\/ <\/summary><\/span>
      \n private<\/span> async<\/span> Task<<\/span>SqliteConnection><\/span><\/span> GetConnectionAsync<\/span>(<\/span>)<\/span>
      \n {<\/span>
      \n if<\/span> (<\/span>_connection is<\/span> null<\/span> ||<\/span> _connection.<\/span>State !=<\/span> ConnectionState.<\/span>Open)<\/span>
      \n {<\/span>
      \n _connection =<\/span> new<\/span> SqliteConnection<\/span>(<\/span>_connectionString)<\/span>;<\/span>
      \n await<\/span> _connection.<\/span>OpenAsync<\/span>(<\/span>)<\/span>;<\/span>
      \n }<\/span>
      \n return<\/span> _connection;<\/span>
      \n }<\/span><\/p>\n

      \/\/\/ <summary><\/span>
      \n \/\/\/ \u83b7\u53d6\u6240\u6709\u8868\u4fe1\u606f<\/span>
      \n \/\/\/ <\/summary><\/span>
      \n public<\/span> async<\/span> Task<<\/span>List<<\/span>TableInfo><\/span>><\/span><\/span> GetTablesAsync<\/span>(<\/span>)<\/span>
      \n {<\/span>
      \n var<\/span><\/span> conn =<\/span> await<\/span> GetConnectionAsync<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

      var<\/span><\/span> tables =<\/span> await<\/span> conn.<\/span>QueryAsync<\/span><<\/span>string<\/span>><\/span><\/span><\/span>(<\/span>
      \n "SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%'"<\/span>)<\/span>;<\/span><\/p>\n

      var<\/span><\/span> result =<\/span> new<\/span> List<<\/span>TableInfo><\/span><\/span>(<\/span>)<\/span>;<\/span>
      \n foreach<\/span> (<\/span>var<\/span><\/span> tableName in<\/span> tables)<\/span>
      \n {<\/span>
      \n var<\/span><\/span> count =<\/span> await<\/span> conn.<\/span>ExecuteScalarAsync<\/span><<\/span>int<\/span>><\/span><\/span><\/span>(<\/span>
      \n $"SELECT COUNT(*) FROM \\\\"<\/span>{<\/span>tableName<\/span>}<\/span><\/span>\\\\""<\/span><\/span>)<\/span>;<\/span>
      \n result.<\/span>Add<\/span>(<\/span>new<\/span> TableInfo<\/span>(<\/span>tableName,<\/span> "TABLE"<\/span>,<\/span> count)<\/span>)<\/span>;<\/span>
      \n }<\/span><\/p>\n

      return<\/span> result;<\/span>
      \n }<\/span><\/p>\n

      \/\/\/ <summary><\/span>
      \n \/\/\/ \u83b7\u53d6\u6307\u5b9a\u8868\u7684\u5217\u4fe1\u606f<\/span>
      \n \/\/\/ <\/summary><\/span>
      \n public<\/span> async<\/span> Task<<\/span>List<<\/span>ColumnInfo><\/span>><\/span><\/span> GetColumnsAsync<\/span>(<\/span>string<\/span><\/span> tableName)<\/span>
      \n {<\/span>
      \n var<\/span><\/span> conn =<\/span> await<\/span> GetConnectionAsync<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

      \/\/ \u4f7f\u7528 PRAGMA \u83b7\u53d6\u5217\u4fe1\u606f<\/span>
      \n var<\/span><\/span> columns =<\/span> await<\/span> conn.<\/span>QueryAsync<\/span>(<\/span>
      \n $"PRAGMA table_info(\\\\"<\/span>{<\/span>tableName<\/span>}<\/span><\/span>\\\\")"<\/span><\/span>)<\/span>;<\/span><\/p>\n

      return<\/span> columns.<\/span>Select<\/span>(<\/span>c =><\/span> new<\/span> ColumnInfo<\/span>(<\/span>
      \n ColumnName<\/span>:<\/span> (<\/span>string<\/span>)<\/span>c.<\/span>name,<\/span>
      \n DataType<\/span>:<\/span> (<\/span>string<\/span>)<\/span>c.<\/span>type,<\/span>
      \n IsNullable<\/span>:<\/span> (<\/span>long<\/span>)<\/span>c.<\/span>notnull<\/span> ==<\/span> 0<\/span>,<\/span>
      \n IsPrimaryKey<\/span>:<\/span> (<\/span>long<\/span>)<\/span>c.<\/span>pk ><\/span> 0<\/span>,<\/span>
      \n DefaultValue<\/span>:<\/span> c.<\/span>dflt_value?.<\/span>ToString<\/span>(<\/span>)<\/span>
      \n )<\/span>)<\/span>.<\/span>ToList<\/span>(<\/span>)<\/span>;<\/span>
      \n }<\/span><\/p>\n

      \/\/\/ <summary><\/span>
      \n \/\/\/ \u6267\u884c\u5b89\u5168\u7684 SELECT \u67e5\u8be2<\/span>
      \n \/\/\/ <\/summary><\/span>
      \n public<\/span> async<\/span> Task<<\/span>string<\/span>><\/span><\/span> ExecuteQueryAsync<\/span>(<\/span>string<\/span><\/span> sql,<\/span> int<\/span><\/span> maxRows =<\/span> 100<\/span>)<\/span>
      \n {<\/span>
      \n \/\/ \u5b89\u5168\u68c0\u67e5：\u53ea\u5141\u8bb8 SELECT \u8bed\u53e5<\/span>
      \n var<\/span><\/span> trimmedSql =<\/span> sql.<\/span>Trim<\/span>(<\/span>)<\/span>.<\/span>ToUpperInvariant<\/span>(<\/span>)<\/span>;<\/span>
      \n if<\/span> (<\/span>!<\/span>trimmedSql.<\/span>StartsWith<\/span>(<\/span>"SELECT"<\/span>)<\/span>)<\/span>
      \n {<\/span>
      \n throw<\/span> new<\/span> InvalidOperationException<\/span>(<\/span>
      \n "\u5b89\u5168\u9650\u5236：\u4ec5\u5141\u8bb8\u6267\u884c SELECT \u67e5\u8be2\u8bed\u53e5\u3002"<\/span>)<\/span>;<\/span>
      \n }<\/span><\/p>\n

      \/\/ \u7981\u6b62 SQL \u6ce8\u91ca（\u9632\u6b62\u6ce8\u5165）<\/span>
      \n if<\/span> (<\/span>trimmedSql.<\/span>Contains<\/span>(<\/span>"–"<\/span>)<\/span> ||<\/span> trimmedSql.<\/span>Contains<\/span>(<\/span>"\/*"<\/span>)<\/span>)<\/span>
      \n {<\/span>
      \n throw<\/span> new<\/span> InvalidOperationException<\/span>(<\/span>
      \n "\u5b89\u5168\u9650\u5236：\u67e5\u8be2\u4e2d\u4e0d\u5141\u8bb8\u5305\u542b SQL \u6ce8\u91ca\u3002"<\/span>)<\/span>;<\/span>
      \n }<\/span><\/p>\n

      \/\/ \u4f7f\u7528\u6b63\u5219\u5339\u914d\u5b8c\u6574\u7684\u5371\u9669\u5173\u952e\u5b57（\u907f\u514d DELETED \u8bef\u5339\u914d DELETE）<\/span>
      \n string<\/span>[<\/span>]<\/span><\/span> forbiddenKeywords =<\/span> [<\/span>"DROP"<\/span>,<\/span> "DELETE"<\/span>,<\/span> "UPDATE"<\/span>,<\/span> "INSERT"<\/span>,<\/span>
      \n "ALTER"<\/span>,<\/span> "CREATE"<\/span>,<\/span> "TRUNCATE"<\/span>,<\/span> "EXEC"<\/span>,<\/span> "EXECUTE"<\/span>]<\/span>;<\/span>
      \n foreach<\/span> (<\/span>var<\/span><\/span> keyword in<\/span> forbiddenKeywords)<\/span>
      \n {<\/span>
      \n \/\/ \\\\b \u5339\u914d\u5355\u8bcd\u8fb9\u754c，\u786e\u4fdd\u662f\u72ec\u7acb\u7684\u5173\u952e\u5b57\u800c\u975e\u5b57\u6bb5\u540d\u7684\u4e00\u90e8\u5206<\/span>
      \n if<\/span> (<\/span>Regex.<\/span>IsMatch<\/span>(<\/span>trimmedSql,<\/span> $@"\\\\b<\/span>{<\/span>keyword<\/span>}<\/span><\/span>\\\\b"<\/span><\/span>)<\/span>)<\/span>
      \n {<\/span>
      \n throw<\/span> new<\/span> InvalidOperationException<\/span>(<\/span>
      \n $"\u5b89\u5168\u9650\u5236：\u67e5\u8be2\u4e2d\u5305\u542b\u4e0d\u5141\u8bb8\u7684\u5173\u952e\u5b57 '<\/span>{<\/span>keyword<\/span>}<\/span><\/span>'\u3002"<\/span><\/span>)<\/span>;<\/span>
      \n }<\/span>
      \n }<\/span><\/p>\n

      var<\/span><\/span> conn =<\/span> await<\/span> GetConnectionAsync<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

      \/\/ \u6dfb\u52a0\u884c\u6570\u9650\u5236<\/span>
      \n if<\/span> (<\/span>!<\/span>trimmedSql.<\/span>Contains<\/span>(<\/span>"LIMIT"<\/span>)<\/span>)<\/span>
      \n {<\/span>
      \n sql =<\/span> $"<\/span>{<\/span>sql.<\/span>TrimEnd<\/span>(<\/span>';'<\/span>)<\/span><\/span>}<\/span><\/span> LIMIT <\/span>{<\/span>maxRows<\/span>}<\/span><\/span>"<\/span><\/span>;<\/span>
      \n }<\/span><\/p>\n

      _logger.<\/span>LogInformation<\/span>(<\/span>"\u6267\u884c\u67e5\u8be2: {Sql}"<\/span>,<\/span> sql)<\/span>;<\/span><\/p>\n

      var<\/span><\/span> results =<\/span> await<\/span> conn.<\/span>QueryAsync<\/span>(<\/span>sql)<\/span>;<\/span>
      \n var<\/span><\/span> resultList =<\/span> results.<\/span>ToList<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

      if<\/span> (<\/span>resultList.<\/span>Count ==<\/span> 0<\/span>)<\/span>
      \n {<\/span>
      \n return<\/span> "\u67e5\u8be2\u7ed3\u679c\u4e3a\u7a7a，\u6ca1\u6709\u627e\u5230\u5339\u914d\u7684\u6570\u636e\u3002"<\/span>;<\/span>
      \n }<\/span><\/p>\n

      \/\/ \u5c06\u7ed3\u679c\u683c\u5f0f\u5316\u4e3a Markdown \u8868\u683c<\/span>
      \n return<\/span> FormatAsMarkdownTable<\/span>(<\/span>resultList)<\/span>;<\/span>
      \n }<\/span><\/p>\n

      \/\/\/ <summary><\/span>
      \n \/\/\/ \u83b7\u53d6\u8868\u7684\u7edf\u8ba1\u6458\u8981\u4fe1\u606f<\/span>
      \n \/\/\/ <\/summary><\/span>
      \n public<\/span> async<\/span> Task<<\/span>string<\/span>><\/span><\/span> GetTableSummaryAsync<\/span>(<\/span>string<\/span><\/span> tableName)<\/span>
      \n {<\/span>
      \n var<\/span><\/span> conn =<\/span> await<\/span> GetConnectionAsync<\/span>(<\/span>)<\/span>;<\/span>
      \n var<\/span><\/span> sb =<\/span> new<\/span> StringBuilder<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

      \/\/ \u57fa\u672c\u7edf\u8ba1<\/span>
      \n var<\/span><\/span> rowCount =<\/span> await<\/span> conn.<\/span>ExecuteScalarAsync<\/span><<\/span>int<\/span>><\/span><\/span><\/span>(<\/span>
      \n $"SELECT COUNT(*) FROM \\\\"<\/span>{<\/span>tableName<\/span>}<\/span><\/span>\\\\""<\/span><\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>$"## \u8868 `<\/span>{<\/span>tableName<\/span>}<\/span><\/span>` \u7edf\u8ba1\u6458\u8981"<\/span><\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>$"- **\u603b\u884c\u6570**: <\/span>{<\/span>rowCount<\/span>:<\/span>N0<\/span>}<\/span><\/span>"<\/span><\/span>)<\/span>;<\/span><\/p>\n

      \/\/ \u83b7\u53d6\u5217\u4fe1\u606f\u5e76\u7edf\u8ba1<\/span>
      \n var<\/span><\/span> columns =<\/span> await<\/span> GetColumnsAsync<\/span>(<\/span>tableName)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>$"- **\u603b\u5217\u6570**: <\/span>{<\/span>columns.<\/span>Count<\/span>}<\/span><\/span>"<\/span><\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>$"- **\u4e3b\u952e\u5217**: <\/span>{<\/span>string<\/span>.<\/span>Join<\/span>(<\/span>", "<\/span>,<\/span>
      \n columns.<\/span>Where<\/span>(<\/span>c =><\/span> c.<\/span>IsPrimaryKey)<\/span>.<\/span>Select<\/span>(<\/span>c =><\/span> c.<\/span>ColumnName)<\/span>)<\/span><\/span>}<\/span><\/span>"<\/span><\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

      \/\/ \u5bf9\u6bcf\u4e2a\u6570\u503c\u7c7b\u578b\u5217\u83b7\u53d6\u7edf\u8ba1\u4fe1\u606f<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>"### \u5217\u8be6\u60c5"<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>"| \u5217\u540d | \u7c7b\u578b | \u53ef\u7a7a | \u4e3b\u952e | \u975e\u7a7a\u503c\u6570 |"<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>"|——|——|——|——|———|"<\/span>)<\/span>;<\/span><\/p>\n

      foreach<\/span> (<\/span>var<\/span><\/span> col in<\/span> columns)<\/span>
      \n {<\/span>
      \n var<\/span><\/span> nonNullCount =<\/span> await<\/span> conn.<\/span>ExecuteScalarAsync<\/span><<\/span>int<\/span>><\/span><\/span><\/span>(<\/span>
      \n $"SELECT COUNT(\\\\"<\/span>{<\/span>col.<\/span>ColumnName<\/span>}<\/span><\/span>\\\\") FROM \\\\"<\/span>{<\/span>tableName<\/span>}<\/span><\/span>\\\\""<\/span><\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>
      \n $"| <\/span>{<\/span>col.<\/span>ColumnName<\/span>}<\/span><\/span> | <\/span>{<\/span>col.<\/span>DataType<\/span>}<\/span><\/span> | "<\/span><\/span> +<\/span>
      \n $"<\/span>{<\/span>(<\/span>col.<\/span>IsNullable ?<\/span> "\u662f"<\/span> :<\/span> "\u5426"<\/span>)<\/span><\/span>}<\/span><\/span> | "<\/span><\/span> +<\/span>
      \n $"<\/span>{<\/span>(<\/span>col.<\/span>IsPrimaryKey ?<\/span> "\u662f"<\/span> :<\/span> "\u5426"<\/span>)<\/span><\/span>}<\/span><\/span> | <\/span>{<\/span>nonNullCount<\/span>:<\/span>N0<\/span>}<\/span><\/span> |"<\/span><\/span>)<\/span>;<\/span>
      \n }<\/span><\/p>\n

      \/\/ \u663e\u793a\u524d 5 \u6761\u6837\u672c\u6570\u636e<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>"### \u6837\u672c\u6570\u636e（\u524d 5 \u6761）"<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>)<\/span>;<\/span>
      \n var<\/span><\/span> sampleData =<\/span> await<\/span> conn.<\/span>QueryAsync<\/span>(<\/span>
      \n $"SELECT * FROM \\\\"<\/span>{<\/span>tableName<\/span>}<\/span><\/span>\\\\" LIMIT 5"<\/span><\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>FormatAsMarkdownTable<\/span>(<\/span>sampleData.<\/span>ToList<\/span>(<\/span>)<\/span>)<\/span>)<\/span>;<\/span><\/p>\n

      return<\/span> sb.<\/span>ToString<\/span>(<\/span>)<\/span>;<\/span>
      \n }<\/span><\/p>\n

      \/\/\/ <summary><\/span>
      \n \/\/\/ \u5c06\u67e5\u8be2\u7ed3\u679c\u683c\u5f0f\u5316\u4e3a Markdown \u8868\u683c<\/span>
      \n \/\/\/ <\/summary><\/span>
      \n private<\/span> static<\/span> string<\/span><\/span> FormatAsMarkdownTable<\/span>(<\/span>List<<\/span>dynamic<\/span>><\/span><\/span> data)<\/span>
      \n {<\/span>
      \n if<\/span> (<\/span>data.<\/span>Count ==<\/span> 0<\/span>)<\/span> return<\/span> "\u65e0\u6570\u636e"<\/span>;<\/span><\/p>\n

      var<\/span><\/span> sb =<\/span> new<\/span> StringBuilder<\/span>(<\/span>)<\/span>;<\/span>
      \n var<\/span><\/span> firstRow =<\/span> (<\/span>IDictionary<<\/span>string<\/span>,<\/span> object<\/span>><\/span>)<\/span>data[<\/span>0<\/span>]<\/span>;<\/span>
      \n var<\/span><\/span> headers =<\/span> firstRow.<\/span>Keys.<\/span>ToList<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

      \/\/ \u8868\u5934<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>"| "<\/span> +<\/span> string<\/span>.<\/span>Join<\/span>(<\/span>" | "<\/span>,<\/span> headers)<\/span> +<\/span> " |"<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>"| "<\/span> +<\/span> string<\/span>.<\/span>Join<\/span>(<\/span>" | "<\/span>,<\/span> headers.<\/span>Select<\/span>(<\/span>_ =><\/span> "—"<\/span>)<\/span>)<\/span> +<\/span> " |"<\/span>)<\/span>;<\/span><\/p>\n

      \/\/ \u6570\u636e\u884c<\/span>
      \n foreach<\/span> (<\/span>var<\/span><\/span> row in<\/span> data)<\/span>
      \n {<\/span>
      \n var<\/span><\/span> dict =<\/span> (<\/span>IDictionary<<\/span>string<\/span>,<\/span> object<\/span>><\/span>)<\/span>row;<\/span>
      \n var<\/span><\/span> values =<\/span> headers.<\/span>Select<\/span>(<\/span>h =><\/span>
      \n dict.<\/span>TryGetValue<\/span>(<\/span>h,<\/span> out<\/span> var<\/span><\/span> v)<\/span> ?<\/span> v?.<\/span>ToString<\/span>(<\/span>)<\/span> ??<\/span> "NULL"<\/span> :<\/span> "NULL"<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>"| "<\/span> +<\/span> string<\/span>.<\/span>Join<\/span>(<\/span>" | "<\/span>,<\/span> values)<\/span> +<\/span> " |"<\/span>)<\/span>;<\/span>
      \n }<\/span><\/p>\n

      sb.<\/span>AppendLine<\/span>(<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>$"*\u5171 <\/span>{<\/span>data.<\/span>Count<\/span>}<\/span><\/span> \u6761\u8bb0\u5f55*"<\/span><\/span>)<\/span>;<\/span><\/p>\n

      return<\/span> sb.<\/span>ToString<\/span>(<\/span>)<\/span>;<\/span>
      \n }<\/span><\/p>\n

      public<\/span> void<\/span><\/span> Dispose<\/span>(<\/span>)<\/span>
      \n {<\/span>
      \n _connection?.<\/span>Dispose<\/span>(<\/span>)<\/span>;<\/span>
      \n GC.<\/span>SuppressFinalize<\/span>(<\/span>this<\/span>)<\/span>;<\/span>
      \n }<\/span>
      \n}<\/span><\/p>\n

      3.6 \u5b9a\u4e49 MCP \u5de5\u5177<\/h4>\n

      \u8fd9\u662f MCP \u670d\u52a1\u5668\u7684\u6838\u5fc3\u90e8\u5206\u2014\u2014\u901a\u8fc7 [McpServerToolType] \u548c [McpServerTool] \u7279\u6027\u5c06\u65b9\u6cd5\u66b4\u9732\u7ed9 AI \u5ba2\u6237\u7aef\u3002<\/p>\n

      Tools\/SchemaTools.cs \u2014 \u6570\u636e\u5e93\u7ed3\u6784\u67e5\u8be2\u5de5\u5177<\/p>\n

      using<\/span> System.<\/span>ComponentModel<\/span>;<\/span>
      \nusing<\/span> System.<\/span>Text<\/span>;<\/span>
      \nusing<\/span> DbQueryMCP.<\/span>Services<\/span>;<\/span>
      \nusing<\/span> ModelContextProtocol.<\/span>Server<\/span>;<\/span><\/p>\n

      namespace<\/span> DbQueryMCP.<\/span>Tools<\/span>;<\/span><\/p>\n

      \/\/\/ <summary><\/span>
      \n\/\/\/ \u6570\u636e\u5e93\u7ed3\u6784\u67e5\u8be2\u5de5\u5177\u96c6<\/span>
      \n\/\/\/ \u63d0\u4f9b\u6570\u636e\u5e93\u8868\u7ed3\u6784\u3001\u5217\u4fe1\u606f\u7b49\u5143\u6570\u636e\u67e5\u8be2\u80fd\u529b<\/span>
      \n\/\/\/ <\/summary><\/span>
      \n[<\/span>McpServerToolType]<\/span>
      \npublic<\/span> static<\/span> class<\/span> SchemaTools<\/span>
      \n{<\/span>
      \n \/\/\/ <summary><\/span>
      \n \/\/\/ \u83b7\u53d6\u6570\u636e\u5e93\u4e2d\u6240\u6709\u8868\u7684\u5217\u8868<\/span>
      \n \/\/\/ <\/summary><\/span>
      \n [<\/span>McpServerTool,<\/span> Description<\/span>(<\/span>
      \n "\u83b7\u53d6\u6570\u636e\u5e93\u4e2d\u6240\u6709\u8868\u7684\u5217\u8868，\u5305\u62ec\u8868\u540d\u3001\u7c7b\u578b\u548c\u884c\u6570\u3002"<\/span> +<\/span>
      \n "\u5f53\u9700\u8981\u4e86\u89e3\u6570\u636e\u5e93\u6709\u54ea\u4e9b\u8868\u3001\u6570\u636e\u89c4\u6a21\u65f6\u4f7f\u7528\u6b64\u5de5\u5177\u3002"<\/span>)<\/span>]<\/span>
      \n public<\/span> static<\/span> async<\/span> Task<<\/span>string<\/span>><\/span><\/span> GetAllTables<\/span>(<\/span>DatabaseService<\/span> dbService)<\/span>
      \n {<\/span>
      \n var<\/span><\/span> tables =<\/span> await<\/span> dbService.<\/span>GetTablesAsync<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

      if<\/span> (<\/span>tables.<\/span>Count ==<\/span> 0<\/span>)<\/span>
      \n {<\/span>
      \n return<\/span> "\u6570\u636e\u5e93\u4e2d\u6ca1\u6709\u627e\u5230\u4efb\u4f55\u8868\u3002"<\/span>;<\/span>
      \n }<\/span><\/p>\n

      var<\/span><\/span> sb =<\/span> new<\/span> StringBuilder<\/span>(<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>"## \u6570\u636e\u5e93\u8868\u5217\u8868"<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>"| \u8868\u540d | \u7c7b\u578b | \u884c\u6570 |"<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>"|——|——|——|"<\/span>)<\/span>;<\/span><\/p>\n

      foreach<\/span> (<\/span>var<\/span><\/span> table in<\/span> tables)<\/span>
      \n {<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>$"| <\/span>{<\/span>table.<\/span>TableName<\/span>}<\/span><\/span> | <\/span>{<\/span>table.<\/span>TableType<\/span>}<\/span><\/span> | <\/span>{<\/span>table.<\/span>RowCount<\/span>:<\/span>N0<\/span>}<\/span><\/span> |"<\/span><\/span>)<\/span>;<\/span>
      \n }<\/span><\/p>\n

      sb.<\/span>AppendLine<\/span>(<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>$"*\u5171 <\/span>{<\/span>tables.<\/span>Count<\/span>}<\/span><\/span> \u5f20\u8868*"<\/span><\/span>)<\/span>;<\/span><\/p>\n

      return<\/span> sb.<\/span>ToString<\/span>(<\/span>)<\/span>;<\/span>
      \n }<\/span><\/p>\n

      \/\/\/ <summary><\/span>
      \n \/\/\/ \u83b7\u53d6\u6307\u5b9a\u8868\u7684\u5217\u4fe1\u606f<\/span>
      \n \/\/\/ <\/summary><\/span>
      \n [<\/span>McpServerTool,<\/span> Description<\/span>(<\/span>
      \n "\u83b7\u53d6\u6307\u5b9a\u8868\u7684\u6240\u6709\u5217\u7684\u8be6\u7ec6\u4fe1\u606f，\u5305\u62ec\u5217\u540d\u3001\u6570\u636e\u7c7b\u578b\u3001\u662f\u5426\u53ef\u7a7a\u3001\u662f\u5426\u4e3a\u4e3b\u952e\u7b49\u3002"<\/span> +<\/span>
      \n "\u5f53\u9700\u8981\u4e86\u89e3\u67d0\u5f20\u8868\u7684\u7ed3\u6784\u8be6\u60c5\u65f6\u4f7f\u7528\u6b64\u5de5\u5177\u3002"<\/span>)<\/span>]<\/span>
      \n public<\/span> static<\/span> async<\/span> Task<<\/span>string<\/span>><\/span><\/span> GetTableColumns<\/span>(<\/span>
      \n DatabaseService<\/span> dbService,<\/span>
      \n [<\/span>Description<\/span>(<\/span>"\u8981\u67e5\u8be2\u7684\u8868\u540d"<\/span>)<\/span><\/span><\/span>]<\/span> string<\/span><\/span> tableName)<\/span>
      \n {<\/span>
      \n var<\/span><\/span> columns =<\/span> await<\/span> dbService.<\/span>GetColumnsAsync<\/span>(<\/span>tableName)<\/span>;<\/span><\/p>\n

      if<\/span> (<\/span>columns.<\/span>Count ==<\/span> 0<\/span>)<\/span>
      \n {<\/span>
      \n return<\/span> $"\u672a\u627e\u5230\u8868 '<\/span>{<\/span>tableName<\/span>}<\/span><\/span>' \u6216\u8be5\u8868\u6ca1\u6709\u5217\u3002"<\/span><\/span>;<\/span>
      \n }<\/span><\/p>\n

      var<\/span><\/span> sb =<\/span> new<\/span> StringBuilder<\/span>(<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>$"## \u8868 `<\/span>{<\/span>tableName<\/span>}<\/span><\/span>` \u7684\u5217\u4fe1\u606f"<\/span><\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>"| \u5217\u540d | \u6570\u636e\u7c7b\u578b | \u53ef\u7a7a | \u4e3b\u952e | \u9ed8\u8ba4\u503c |"<\/span>)<\/span>;<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>"|——|———|——|——|——–|"<\/span>)<\/span>;<\/span><\/p>\n

      foreach<\/span> (<\/span>var<\/span><\/span> col in<\/span> columns)<\/span>
      \n {<\/span>
      \n sb.<\/span>AppendLine<\/span>(<\/span>
      \n $"| <\/span>{<\/span>col.<\/span>ColumnName<\/span>}<\/span><\/span> | <\/span>{<\/span>col.<\/span>DataType<\/span>}<\/span><\/span> | "<\/span><\/span> +<\/span>
      \n $"<\/span>{<\/span>(<\/span>col.<\/span>IsNullable ?<\/span> "\u662f"<\/span> :<\/span> "\u5426"<\/span>)<\/span><\/span>}<\/span><\/span> | "<\/span><\/span> +<\/span>
      \n $"<\/span>{<\/span>(<\/span>col.<\/span>IsPrimaryKey ?<\/span> "\u2713"<\/span> :<\/span> ""<\/span>)<\/span><\/span>}<\/span><\/span> | "<\/span><\/span> +<\/span>
      \n $"<\/span>{<\/span>col.<\/span>DefaultValue ??<\/span> "-"<\/span><\/span>}<\/span><\/span> |"<\/span><\/span>)<\/span>;<\/span>
      \n }<\/span><\/p>\n

      return<\/span> sb.<\/span>ToString<\/span>(<\/span>)<\/span>;<\/span>
      \n }<\/span><\/p>\n

      \/\/\/ <summary><\/span>
      \n \/\/\/ \u83b7\u53d6\u8868\u7684\u7edf\u8ba1\u6458\u8981<\/span>
      \n \/\/\/ <\/summary><\/span>
      \n [<\/span>McpServerTool,<\/span> Description<\/span>(<\/span>
      \n "\u83b7\u53d6\u6307\u5b9a\u8868\u7684\u5b8c\u6574\u7edf\u8ba1\u6458\u8981，\u5305\u62ec\u884c\u6570\u3001\u5217\u6570\u3001\u4e3b\u952e\u3001\u6bcf\u5217\u7684\u975e\u7a7a\u503c\u7edf\u8ba1\u4ee5\u53ca\u6837\u672c\u6570\u636e\u3002"<\/span> +<\/span>
      \n "\u5f53\u9700\u8981\u5feb\u901f\u4e86\u89e3\u4e00\u5f20\u8868\u7684\u5168\u8c8c\u65f6\u4f7f\u7528\u6b64\u5de5\u5177\u3002"<\/span>)<\/span>]<\/span>
      \n public<\/span> static<\/span> async<\/span> Task<<\/span>string<\/span>><\/span><\/span> GetTableSummary<\/span>(<\/span>
      \n DatabaseService<\/span> dbService,<\/span>
      \n [<\/span>Description<\/span>(<\/span>"\u8981\u5206\u6790\u7684\u8868\u540d"<\/span>)<\/span><\/span><\/span>]<\/span> string<\/span><\/span> tableName)<\/span>
      \n {<\/span>
      \n return<\/span> await<\/span> dbService.<\/span>GetTableSummaryAsync<\/span>(<\/span>tableName)<\/span>;<\/span>
      \n }<\/span>
      \n}<\/span><\/p>\n

      Tools\/QueryTools.cs \u2014 \u6570\u636e\u67e5\u8be2\u5de5\u5177<\/p>\n

      using<\/span> System.<\/span>ComponentModel<\/span>;<\/span>
      \nusing<\/span> DbQueryMCP.<\/span>Services<\/span>;<\/span>
      \nusing<\/span> ModelContextProtocol.<\/span>Server<\/span>;<\/span><\/p>\n

      namespace<\/span> DbQueryMCP.<\/span>Tools<\/span>;<\/span><\/p>\n

      \/\/\/ <summary><\/span>
      \n\/\/\/ \u6570\u636e\u67e5\u8be2\u5de5\u5177\u96c6<\/span>
      \n\/\/\/ \u63d0\u4f9b\u5b89\u5168\u7684 SQL \u67e5\u8be2\u6267\u884c\u80fd\u529b<\/span>
      \n\/\/\/ <\/summary><\/span>
      \n[<\/span>McpServerToolType]<\/span>
      \npublic<\/span> static<\/span> class<\/span> QueryTools<\/span>
      \n{<\/span>
      \n \/\/\/ <summary><\/span>
      \n \/\/\/ \u6267\u884c SQL SELECT \u67e5\u8be2<\/span>
      \n \/\/\/ <\/summary><\/span>
      \n [<\/span>McpServerTool,<\/span> Description<\/span>(<\/span>
      \n "\u5728\u6570\u636e\u5e93\u4e0a\u6267\u884c SQL SELECT \u67e5\u8be2\u5e76\u8fd4\u56de\u7ed3\u679c\u3002"<\/span> +<\/span>
      \n "\u4ec5\u652f\u6301 SELECT \u8bed\u53e5，\u7981\u6b62 INSERT\/UPDATE\/DELETE \u7b49\u4fee\u6539\u64cd\u4f5c\u3002"<\/span> +<\/span>
      \n "\u7ed3\u679c\u9ed8\u8ba4\u9650\u5236\u6700\u591a\u8fd4\u56de 100 \u884c，\u53ef\u901a\u8fc7 maxRows \u53c2\u6570\u8c03\u6574\u3002"<\/span>)<\/span>]<\/span>
      \n public<\/span> static<\/span> async<\/span> Task<<\/span>string<\/span>><\/span><\/span> ExecuteSelectQuery<\/span>(<\/span>
      \n DatabaseService<\/span> dbService,<\/span>
      \n [<\/span>Description<\/span>(<\/span>"\u8981\u6267\u884c\u7684 SQL SELECT \u67e5\u8be2\u8bed\u53e5"<\/span>)<\/span><\/span><\/span>]<\/span> string<\/span><\/span> sql,<\/span>
      \n [<\/span>Description<\/span>(<\/span>"\u6700\u5927\u8fd4\u56de\u884c\u6570，\u9ed8\u8ba4 100"<\/span>)<\/span><\/span><\/span>]<\/span> int<\/span><\/span> maxRows =<\/span> 100<\/span>)<\/span>
      \n {<\/span>
      \n try<\/span>
      \n {<\/span>
      \n return<\/span> await<\/span> dbService.<\/span>ExecuteQueryAsync<\/span>(<\/span>sql,<\/span> maxRows)<\/span>;<\/span>
      \n }<\/span>
      \n catch<\/span> (<\/span>InvalidOperationException<\/span> ex)<\/span>
      \n {<\/span>
      \n return<\/span> $"\u26a0\ufe0f \u67e5\u8be2\u88ab\u62d2\u7edd：<\/span>{<\/span>ex.<\/span>Message<\/span>}<\/span><\/span>"<\/span><\/span>;<\/span>
      \n }<\/span>
      \n catch<\/span> (<\/span>Exception<\/span> ex)<\/span>
      \n {<\/span>
      \n return<\/span> $"\u274c \u67e5\u8be2\u6267\u884c\u5931\u8d25：<\/span>{<\/span>ex.<\/span>Message<\/span>}<\/span><\/span>"<\/span><\/span>;<\/span>
      \n }<\/span>
      \n }<\/span><\/p>\n

      \/\/\/ <summary><\/span>
      \n \/\/\/ \u6839\u636e\u6761\u4ef6\u641c\u7d22\u6570\u636e<\/span>
      \n \/\/\/ <\/summary><\/span>
      \n [<\/span>McpServerTool,<\/span> Description<\/span>(<\/span>
      \n "\u5728\u6307\u5b9a\u8868\u4e2d\u6839\u636e\u6761\u4ef6\u641c\u7d22\u6570\u636e\u3002\u652f\u6301\u6a21\u7cca\u641c\u7d22（LIKE）\u548c\u7cbe\u786e\u5339\u914d\u3002"<\/span> +<\/span>
      \n "\u9002\u5408\u5feb\u901f\u67e5\u627e\u7279\u5b9a\u6570\u636e，\u65e0\u9700\u7f16\u5199\u5b8c\u6574\u7684 SQL \u8bed\u53e5\u3002"<\/span>)<\/span>]<\/span>
      \n public<\/span> static<\/span> async<\/span> Task<<\/span>string<\/span>><\/span><\/span> SearchInTable<\/span>(<\/span>
      \n DatabaseService<\/span> dbService,<\/span>
      \n [<\/span>Description<\/span>(<\/span>"\u8981\u641c\u7d22\u7684\u8868\u540d"<\/span>)<\/span><\/span><\/span>]<\/span> string<\/span><\/span> tableName,<\/span>
      \n [<\/span>Description<\/span>(<\/span>"\u8981\u641c\u7d22\u7684\u5217\u540d"<\/span>)<\/span><\/span><\/span>]<\/span> string<\/span><\/span> columnName,<\/span>
      \n [<\/span>Description<\/span>(<\/span>"\u641c\u7d22\u5173\u952e\u5b57"<\/span>)<\/span><\/span><\/span>]<\/span> string<\/span><\/span> keyword,<\/span>
      \n [<\/span>Description<\/span>(<\/span>"\u662f\u5426\u4f7f\u7528\u6a21\u7cca\u5339\u914d（\u9ed8\u8ba4 true）"<\/span>)<\/span><\/span><\/span>]<\/span> bool<\/span><\/span> fuzzy =<\/span> true<\/span>)<\/span>
      \n {<\/span>
      \n try<\/span>
      \n {<\/span>
      \n var<\/span><\/span> condition =<\/span> fuzzy
      \n ?<\/span> $"\\\\"<\/span>{<\/span>columnName<\/span>}<\/span><\/span>\\\\" LIKE '%<\/span>{<\/span>keyword.<\/span>Replace<\/span>(<\/span>"'"<\/span>,<\/span> "''"<\/span>)<\/span><\/span>}<\/span><\/span>%'"<\/span><\/span>
      \n :<\/span> $"\\\\"<\/span>{<\/span>columnName<\/span>}<\/span><\/span>\\\\" = '<\/span>{<\/span>keyword.<\/span>Replace<\/span>(<\/span>"'"<\/span>,<\/span> "''"<\/span>)<\/span><\/span>}<\/span><\/span>'"<\/span><\/span>;<\/span><\/p>\n

      var<\/span><\/span> sql =<\/span> $"SELECT * FROM \\\\"<\/span>{<\/span>tableName<\/span>}<\/span><\/span>\\\\" WHERE <\/span>{<\/span>condition<\/span>}<\/span><\/span>"<\/span><\/span>;<\/span><\/p>\n

      return<\/span> await<\/span> dbService.<\/span>ExecuteQueryAsync<\/span>(<\/span>sql)<\/span>;<\/span>
      \n }<\/span>
      \n catch<\/span> (<\/span>Exception<\/span> ex)<\/span>
      \n {<\/span>
      \n return<\/span> $"\u274c \u641c\u7d22\u5931\u8d25：<\/span>{<\/span>ex.<\/span>Message<\/span>}<\/span><\/span>"<\/span><\/span>;<\/span>
      \n }<\/span>
      \n }<\/span><\/p>\n

      \/\/\/ <summary><\/span>
      \n \/\/\/ \u83b7\u53d6\u8868\u4e2d\u7684\u805a\u5408\u7edf\u8ba1\u6570\u636e<\/span>
      \n \/\/\/ <\/summary><\/span>
      \n [<\/span>McpServerTool,<\/span> Description<\/span>(<\/span>
      \n "\u5bf9\u6307\u5b9a\u8868\u7684\u6307\u5b9a\u5217\u6267\u884c\u805a\u5408\u7edf\u8ba1（COUNT\u3001SUM\u3001AVG\u3001MIN\u3001MAX）\u3002"<\/span> +<\/span>
      \n "\u9002\u5408\u5feb\u901f\u83b7\u53d6\u6570\u636e\u7684\u7edf\u8ba1\u4fe1\u606f\u3002"<\/span>)<\/span>]<\/span>
      \n public<\/span> static<\/span> async<\/span> Task<<\/span>string<\/span>><\/span><\/span> GetAggregateStats<\/span>(<\/span>
      \n DatabaseService<\/span> dbService,<\/span>
      \n [<\/span>Description<\/span>(<\/span>"\u8981\u7edf\u8ba1\u7684\u8868\u540d"<\/span>)<\/span><\/span><\/span>]<\/span> string<\/span><\/span> tableName,<\/span>
      \n [<\/span>Description<\/span>(<\/span>"\u8981\u7edf\u8ba1\u7684\u5217\u540d"<\/span>)<\/span><\/span><\/span>]<\/span> string<\/span><\/span> columnName,<\/span>
      \n [<\/span>Description<\/span>(<\/span>"\u805a\u5408\u51fd\u6570：COUNT\u3001SUM\u3001AVG\u3001MIN\u3001MAX"<\/span>)<\/span><\/span><\/span>]<\/span> string<\/span><\/span> aggregateFunction =<\/span> "COUNT"<\/span>,<\/span>
      \n [<\/span>Description<\/span>(<\/span>"\u53ef\u9009\u7684 WHERE \u6761\u4ef6（\u4e0d\u542b WHERE \u5173\u952e\u5b57）"<\/span>)<\/span><\/span><\/span>]<\/span> string<\/span>?<\/span><\/span> whereCondition =<\/span> null<\/span>)<\/span>
      \n {<\/span>
      \n try<\/span>
      \n {<\/span>
      \n var<\/span><\/span> validFunctions =<\/span> new<\/span>[<\/span>]<\/span> {<\/span> "COUNT"<\/span>,<\/span> "SUM"<\/span>,<\/span> "AVG"<\/span>,<\/span> "MIN"<\/span>,<\/span> "MAX"<\/span> }<\/span>;<\/span>
      \n var<\/span><\/span> func =<\/span> aggregateFunction.<\/span>Trim<\/span>(<\/span>)<\/span>.<\/span>ToUpperInvariant<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

      if<\/span> (<\/span>!<\/span>validFunctions.<\/span>Contains<\/span>(<\/span>func)<\/span>)<\/span>
      \n {<\/span>
      \n return<\/span> $"\u26a0\ufe0f \u4e0d\u652f\u6301\u7684\u805a\u5408\u51fd\u6570 '<\/span>{<\/span>aggregateFunction<\/span>}<\/span><\/span>'\u3002"<\/span><\/span> +<\/span>
      \n $"\u652f\u6301\u7684\u51fd\u6570：<\/span>{<\/span>string<\/span>.<\/span>Join<\/span>(<\/span>"\u3001"<\/span>,<\/span> validFunctions)<\/span><\/span>}<\/span><\/span>"<\/span><\/span>;<\/span>
      \n }<\/span><\/p>\n

      var<\/span><\/span> sql =<\/span> $"SELECT <\/span>{<\/span>func<\/span>}<\/span><\/span>(\\\\"<\/span>{<\/span>columnName<\/span>}<\/span><\/span>\\\\") AS Result FROM \\\\"<\/span>{<\/span>tableName<\/span>}<\/span><\/span>\\\\""<\/span><\/span>;<\/span>
      \n if<\/span> (<\/span>!<\/span>string<\/span>.<\/span>IsNullOrWhiteSpace<\/span>(<\/span>whereCondition)<\/span>)<\/span>
      \n {<\/span>
      \n sql +=<\/span> $" WHERE <\/span>{<\/span>whereCondition<\/span>}<\/span><\/span>"<\/span><\/span>;<\/span>
      \n }<\/span><\/p>\n

      return<\/span> await<\/span> dbService.<\/span>ExecuteQueryAsync<\/span>(<\/span>sql)<\/span>;<\/span>
      \n }<\/span>
      \n catch<\/span> (<\/span>Exception<\/span> ex)<\/span>
      \n {<\/span>
      \n return<\/span> $"\u274c \u7edf\u8ba1\u5931\u8d25：<\/span>{<\/span>ex.<\/span>Message<\/span>}<\/span><\/span>"<\/span><\/span>;<\/span>
      \n }<\/span>
      \n }<\/span>
      \n}<\/span><\/p>\n

      3.7 \u914d\u7f6e\u5e94\u7528\u5165\u53e3<\/h4>\n

      Program.cs<\/p>\n

      using<\/span> DbQueryMCP.<\/span>Services<\/span>;<\/span>
      \nusing<\/span> Microsoft.<\/span>Extensions.<\/span>DependencyInjection<\/span>;<\/span>
      \nusing<\/span> Microsoft.<\/span>Extensions.<\/span>Hosting<\/span>;<\/span>
      \nusing<\/span> Microsoft.<\/span>Extensions.<\/span>Logging<\/span>;<\/span><\/p>\n

      var<\/span><\/span> builder =<\/span> Host.<\/span>CreateApplicationBuilder<\/span>(<\/span>args)<\/span>;<\/span><\/p>\n

      \/\/ \u914d\u7f6e\u65e5\u5fd7\u8f93\u51fa\u5230 stderr（MCP \u534f\u8bae\u4f7f\u7528 stdout \u901a\u4fe1，\u65e5\u5fd7\u5fc5\u987b\u8d70 stderr）<\/span>
      \nbuilder.<\/span>Logging.<\/span>AddConsole<\/span>(<\/span>consoleLogOptions =><\/span>
      \n{<\/span>
      \n consoleLogOptions.<\/span>LogToStandardErrorThreshold =<\/span> LogLevel.<\/span>Trace;<\/span>
      \n}<\/span>)<\/span>;<\/span><\/p>\n

      \/\/ \u6ce8\u518c\u6570\u636e\u5e93\u670d\u52a1<\/span>
      \nbuilder.<\/span>Services.<\/span>AddSingleton<\/span><<\/span>DatabaseService><\/span><\/span><\/span>(<\/span>)<\/span>;<\/span><\/p>\n

      \/\/ \u914d\u7f6e MCP \u670d\u52a1\u5668<\/span>
      \nbuilder.<\/span>Services
      \n .<\/span>AddMcpServer<\/span>(<\/span>)<\/span>
      \n .<\/span>WithStdioServerTransport<\/span>(<\/span>)<\/span> \/\/ \u4f7f\u7528 stdio \u4f20\u8f93（\u672c\u5730\u6a21\u5f0f）<\/span>
      \n .<\/span>WithToolsFromAssembly<\/span>(<\/span>)<\/span>;<\/span> \/\/ \u81ea\u52a8\u626b\u63cf\u7a0b\u5e8f\u96c6\u4e2d\u7684\u5de5\u5177<\/span><\/p>\n

      await<\/span> builder.<\/span>Build<\/span>(<\/span>)<\/span>.<\/span>RunAsync<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

      appsettings.json<\/p>\n

      {<\/span>
      \n "ConnectionStrings"<\/span>:<\/span> {<\/span>
      \n "DefaultConnection"<\/span>:<\/span> "Data Source=sample.db"<\/span>
      \n }<\/span>,<\/span>
      \n "Logging"<\/span>:<\/span> {<\/span>
      \n "LogLevel"<\/span>:<\/span> {<\/span>
      \n "Default"<\/span>:<\/span> "Information"<\/span>,<\/span>
      \n "Microsoft"<\/span>:<\/span> "Warning"<\/span>
      \n }<\/span>
      \n }<\/span>
      \n}<\/span><\/p>\n

      3.8 \u521b\u5efa\u793a\u4f8b\u6570\u636e\u5e93<\/h4>\n

      \u4e3a\u4e86\u6d4b\u8bd5\u6211\u4eec\u7684 MCP \u670d\u52a1\u5668，\u521b\u5efa\u4e00\u4e2a\u5305\u542b\u793a\u4f8b\u6570\u636e\u7684 SQLite \u6570\u636e\u5e93\u3002\u5728\u9879\u76ee\u6839\u76ee\u5f55\u521b\u5efa InitSampleDb.cs：<\/p>\n

      InitSampleDb \u2014 \u72ec\u7acb\u7684\u521d\u59cb\u5316\u811a\u672c<\/p>\n

      \u6ce8\u610f：\u8fd9\u662f\u4e00\u4e2a\u5355\u72ec\u7684\u63a7\u5236\u53f0\u9879\u76ee，\u4e0d\u80fd\u653e\u5728 DbQueryMCP \u9879\u76ee\u4e2d（\u56e0\u4e3a\u4e24\u8005\u90fd\u4f7f\u7528\u9876\u7ea7\u8bed\u53e5）\u3002 \u521b\u5efa\u65b9\u5f0f：dotnet new console -n InitSampleDb，\u7136\u540e\u6dfb\u52a0\u76f8\u540c\u7684 Microsoft.Data.Sqlite \u548c Dapper \u5305\u3002 \u8fd0\u884c\u4e00\u6b21\u751f\u6210 sample.db \u540e，\u5c06\u8be5\u6587\u4ef6\u590d\u5236\u5230 DbQueryMCP \u7684\u8f93\u51fa\u76ee\u5f55\u5373\u53ef\u3002<\/p>\n

      \/\/ InitSampleDb\/Program.cs<\/span>
      \n\/\/ \u72ec\u7acb\u63a7\u5236\u53f0\u9879\u76ee，\u8fd0\u884c\u4e00\u6b21\u5373\u53ef\u751f\u6210\u793a\u4f8b\u6570\u636e\u5e93<\/span>
      \nusing<\/span> Microsoft.<\/span>Data.<\/span>Sqlite<\/span>;<\/span>
      \nusing<\/span> Dapper<\/span>;<\/span><\/p>\n

      var<\/span><\/span> connectionString =<\/span> "Data Source=sample.db"<\/span>;<\/span>
      \nusing<\/span> var<\/span><\/span> connection =<\/span> new<\/span> SqliteConnection<\/span>(<\/span>connectionString)<\/span>;<\/span>
      \nconnection.<\/span>Open<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

      \/\/ \u521b\u5efa\u90e8\u95e8\u8868<\/span>
      \nconnection.<\/span>Execute<\/span>(<\/span>""<\/span>"
      \n CREATE TABLE IF NOT EXISTS<\/span> Departments (<\/span>
      \n Id INTEGER PRIMARY KEY<\/span> AUTOINCREMENT,<\/span>
      \n Name TEXT NOT<\/span> NULL,<\/span>
      \n ManagerName<\/span> TEXT,<\/span>
      \n Budget<\/span> REAL,<\/span>
      \n CreatedAt TEXT<\/span> DEFAULT (<\/span>datetime<\/span>(<\/span>'now')<\/span>)<\/span>
      \n )<\/span>
      \n""<\/span>")<\/span>;<\/span><\/p>\n

      \/\/ \u521b\u5efa\u5458\u5de5\u8868<\/span>
      \nconnection.<\/span>Execute<\/span>(<\/span>""<\/span>"
      \n CREATE TABLE IF NOT EXISTS<\/span> Employees (<\/span>
      \n Id INTEGER PRIMARY KEY<\/span> AUTOINCREMENT,<\/span>
      \n Name TEXT NOT<\/span> NULL,<\/span>
      \n Email TEXT<\/span> UNIQUE,<\/span>
      \n DepartmentId<\/span> INTEGER,<\/span>
      \n Position<\/span> TEXT,<\/span>
      \n Salary<\/span> REAL,<\/span>
      \n HireDate<\/span> TEXT,<\/span>
      \n IsActive INTEGER DEFAULT 1<\/span>,<\/span>
      \n FOREIGN<\/span> KEY (<\/span>DepartmentId)<\/span> REFERENCES<\/span> Departments<\/span>(<\/span>Id)<\/span>
      \n )<\/span>
      \n""<\/span>")<\/span>;<\/span><\/p>\n

      \/\/ \u521b\u5efa\u9879\u76ee\u8868<\/span>
      \nconnection.<\/span>Execute<\/span>(<\/span>""<\/span>"
      \n CREATE TABLE IF NOT EXISTS<\/span> Projects (<\/span>
      \n Id INTEGER PRIMARY KEY<\/span> AUTOINCREMENT,<\/span>
      \n ProjectName TEXT NOT<\/span> NULL,<\/span>
      \n Description<\/span> TEXT,<\/span>
      \n DepartmentId<\/span> INTEGER,<\/span>
      \n StartDate<\/span> TEXT,<\/span>
      \n EndDate<\/span> TEXT,<\/span>
      \n Status TEXT DEFAULT 'Planning',<\/span>
      \n Budget<\/span> REAL,<\/span>
      \n FOREIGN<\/span> KEY (<\/span>DepartmentId)<\/span> REFERENCES<\/span> Departments<\/span>(<\/span>Id)<\/span>
      \n )<\/span>
      \n""<\/span>")<\/span>;<\/span><\/p>\n

      \/\/ \u63d2\u5165\u793a\u4f8b\u6570\u636e – \u90e8\u95e8<\/span>
      \nconnection.<\/span>Execute<\/span>(<\/span>""<\/span>"
      \n INSERT OR IGNORE INTO<\/span> Departments (<\/span>Id,<\/span> Name,<\/span> ManagerName,<\/span> Budget)<\/span><\/span>
      \n VALUES
      \n (<\/span>1<\/span>,<\/span> '\u6280\u672f\u7814\u53d1\u90e8',<\/span> '\u5f20\u4e09',<\/span> 5000000<\/span>)<\/span>,<\/span>
      \n (<\/span>2<\/span>,<\/span> '\u4ea7\u54c1\u8bbe\u8ba1\u90e8',<\/span> '\u674e\u56db',<\/span> 2000000<\/span>)<\/span>,<\/span>
      \n (<\/span>3<\/span>,<\/span> '\u5e02\u573a\u8425\u9500\u90e8',<\/span> '\u738b\u4e94',<\/span> 3000000<\/span>)<\/span>,<\/span>
      \n (<\/span>4<\/span>,<\/span> '\u4eba\u529b\u8d44\u6e90\u90e8',<\/span> '\u8d75\u516d',<\/span> 1000000<\/span>)<\/span>,<\/span>
      \n (<\/span>5<\/span>,<\/span> '\u8d22\u52a1\u90e8',<\/span> '\u94b1\u4e03',<\/span> 800000<\/span>)<\/span>
      \n""<\/span>")<\/span>;<\/span><\/p>\n

      \/\/ \u63d2\u5165\u793a\u4f8b\u6570\u636e – \u5458\u5de5<\/span>
      \nconnection.<\/span>Execute<\/span>(<\/span>""<\/span>"
      \n INSERT OR IGNORE INTO<\/span> Employees (<\/span>Id,<\/span> Name,<\/span> Email,<\/span> DepartmentId,<\/span> Position,<\/span> Salary,<\/span> HireDate,<\/span> IsActive)<\/span><\/span>
      \n VALUES
      \n (<\/span>1<\/span>,<\/span> '\u5f20\u4e09',<\/span> 'zhangsan@company.<\/span>com',<\/span> 1<\/span>,<\/span> '\u6280\u672f\u603b\u76d1',<\/span> 45000<\/span>,<\/span> '2020<\/span>–<\/span>03<\/span>–<\/span>15<\/span>',<\/span> 1<\/span>)<\/span>,<\/span>
      \n (<\/span>2<\/span>,<\/span> '\u674e\u56db',<\/span> 'lisi@company.<\/span>com',<\/span> 2<\/span>,<\/span> '\u4ea7\u54c1\u7ecf\u7406',<\/span> 35000<\/span>,<\/span> '2021<\/span>–<\/span>06<\/span>–<\/span>20<\/span>',<\/span> 1<\/span>)<\/span>,<\/span>
      \n (<\/span>3<\/span>,<\/span> '\u738b\u4e94',<\/span> 'wangwu@company.<\/span>com',<\/span> 3<\/span>,<\/span> '\u8425\u9500\u603b\u76d1',<\/span> 40000<\/span>,<\/span> '2019<\/span>–<\/span>11<\/span>–<\/span>01<\/span>',<\/span> 1<\/span>)<\/span>,<\/span>
      \n (<\/span>4<\/span>,<\/span> '\u8d75\u516d',<\/span> 'zhaoliu@company.<\/span>com',<\/span> 4<\/span>,<\/span> 'HR\u7ecf\u7406',<\/span> 30000<\/span>,<\/span> '2022<\/span>–<\/span>01<\/span>–<\/span>10<\/span>',<\/span> 1<\/span>)<\/span>,<\/span>
      \n (<\/span>5<\/span>,<\/span> '\u94b1\u4e03',<\/span> 'qianqi@company.<\/span>com',<\/span> 5<\/span>,<\/span> '\u8d22\u52a1\u7ecf\u7406',<\/span> 32000<\/span>,<\/span> '2021<\/span>–<\/span>08<\/span>–<\/span>05<\/span>',<\/span> 1<\/span>)<\/span>,<\/span>
      \n (<\/span>6<\/span>,<\/span> '\u5b59\u516b',<\/span> 'sunba@company.<\/span>com',<\/span> 1<\/span>,<\/span> '\u9ad8\u7ea7\u5de5\u7a0b\u5e08',<\/span> 38000<\/span>,<\/span> '2020<\/span>–<\/span>07<\/span>–<\/span>22<\/span>',<\/span> 1<\/span>)<\/span>,<\/span>
      \n (<\/span>7<\/span>,<\/span> '\u5468\u4e5d',<\/span> 'zhoujiu@company.<\/span>com',<\/span> 1<\/span>,<\/span> '\u524d\u7aef\u5de5\u7a0b\u5e08',<\/span> 28000<\/span>,<\/span> '2022<\/span>–<\/span>04<\/span>–<\/span>18<\/span>',<\/span> 1<\/span>)<\/span>,<\/span>
      \n (<\/span>8<\/span>,<\/span> '\u5434\u5341',<\/span> 'wushi@company.<\/span>com',<\/span> 1<\/span>,<\/span> '\u540e\u7aef\u5de5\u7a0b\u5e08',<\/span> 30000<\/span>,<\/span> '2022<\/span>–<\/span>09<\/span>–<\/span>01<\/span>',<\/span> 1<\/span>)<\/span>,<\/span>
      \n (<\/span>9<\/span>,<\/span> '\u90d1\u4e00',<\/span> 'zhengyi@company.<\/span>com',<\/span> 2<\/span>,<\/span> 'UI\u8bbe\u8ba1\u5e08',<\/span> 25000<\/span>,<\/span> '2023<\/span>–<\/span>02<\/span>–<\/span>14<\/span>',<\/span> 1<\/span>)<\/span>,<\/span>
      \n (<\/span>10<\/span>,<\/span> '\u51af\u4e8c',<\/span> 'fengerr@company.<\/span>com',<\/span> 3<\/span>,<\/span> '\u5e02\u573a\u4e13\u5458',<\/span> 18000<\/span>,<\/span> '2023<\/span>–<\/span>06<\/span>–<\/span>01<\/span>',<\/span> 1<\/span>)<\/span>,<\/span>
      \n (<\/span>11<\/span>,<\/span> '\u9648\u4e09',<\/span> 'chensan@company.<\/span>com',<\/span> 1<\/span>,<\/span> '\u6d4b\u8bd5\u5de5\u7a0b\u5e08',<\/span> 26000<\/span>,<\/span> '2022<\/span>–<\/span>11<\/span>–<\/span>20<\/span>',<\/span> 1<\/span>)<\/span>,<\/span>
      \n (<\/span>12<\/span>,<\/span> '\u891a\u56db',<\/span> 'chusi@company.<\/span>com',<\/span> 2<\/span>,<\/span> '\u4ea7\u54c1\u52a9\u7406',<\/span> 15000<\/span>,<\/span> '2024<\/span>–<\/span>01<\/span>–<\/span>15<\/span>',<\/span> 1<\/span>)<\/span>,<\/span>
      \n (<\/span>13<\/span>,<\/span> '\u536b\u4e94',<\/span> 'weiwu@company.<\/span>com',<\/span> 3<\/span>,<\/span> '\u8fd0\u8425\u4e13\u5458',<\/span> 16000<\/span>,<\/span> '2024<\/span>–<\/span>03<\/span>–<\/span>01<\/span>',<\/span> 0<\/span>)<\/span>,<\/span>
      \n (<\/span>14<\/span>,<\/span> '\u848b\u516d',<\/span> 'jiangliu@company.<\/span>com',<\/span> 1<\/span>,<\/span> '\u67b6\u6784\u5e08',<\/span> 50000<\/span>,<\/span> '2018<\/span>–<\/span>05<\/span>–<\/span>10<\/span>',<\/span> 1<\/span>)<\/span>,<\/span>
      \n (<\/span>15<\/span>,<\/span> '\u6c88\u4e03',<\/span> 'shenqi@company.<\/span>com',<\/span> 4<\/span>,<\/span> 'HR\u4e13\u5458',<\/span> 15000<\/span>,<\/span> '2024<\/span>–<\/span>06<\/span>–<\/span>01<\/span>',<\/span> 1<\/span>)<\/span>
      \n""<\/span>")<\/span>;<\/span><\/p>\n

      \/\/ \u63d2\u5165\u793a\u4f8b\u6570\u636e – \u9879\u76ee<\/span>
      \nconnection.<\/span>Execute<\/span>(<\/span>""<\/span>"
      \n INSERT OR IGNORE INTO<\/span> Projects (<\/span>Id,<\/span> ProjectName,<\/span> Description,<\/span> DepartmentId,<\/span> StartDate,<\/span> EndDate,<\/span> Status,<\/span> Budget)<\/span><\/span>
      \n VALUES
      \n (<\/span>1<\/span>,<\/span> '\u667a\u80fd\u5ba2\u670d\u7cfb\u7edf',<\/span> '\u57fa\u4e8eAI\u7684\u5ba2\u6237\u670d\u52a1\u81ea\u52a8\u5316\u5e73\u53f0',<\/span> 1<\/span>,<\/span> '2024<\/span>–<\/span>01<\/span>–<\/span>01<\/span>',<\/span> '2024<\/span>–<\/span>12<\/span>–<\/span>31<\/span>',<\/span> 'Active',<\/span> 800000<\/span>)<\/span>,<\/span>
      \n (<\/span>2<\/span>,<\/span> '\u79fb\u52a8\u7aefApp\u6539\u7248',<\/span> '\u516c\u53f8\u5b98\u65b9App 3.0<\/span>\u7248\u672c\u91cd\u6784',<\/span> 2<\/span>,<\/span> '2024<\/span>–<\/span>03<\/span>–<\/span>01<\/span>',<\/span> '2024<\/span>–<\/span>09<\/span>–<\/span>30<\/span>',<\/span> 'Completed',<\/span> 500000<\/span>)<\/span>,<\/span>
      \n (<\/span>3<\/span>,<\/span> '\u54c1\u724c\u63a8\u5e7f\u6d3b\u52a8',<\/span> '2024<\/span>\u5e74\u5ea6\u54c1\u724c\u63a8\u5e7f\u8ba1\u5212',<\/span> 3<\/span>,<\/span> '2024<\/span>–<\/span>06<\/span>–<\/span>01<\/span>',<\/span> '2024<\/span>–<\/span>12<\/span>–<\/span>31<\/span>',<\/span> 'Active',<\/span> 1200000<\/span>)<\/span>,<\/span>
      \n (<\/span>4<\/span>,<\/span> '\u5458\u5de5\u57f9\u8bad\u5e73\u53f0',<\/span> '\u5728\u7ebf\u5b66\u4e60\u4e0e\u6280\u80fd\u63d0\u5347\u5e73\u53f0',<\/span> 4<\/span>,<\/span> '2024<\/span>–<\/span>04<\/span>–<\/span>01<\/span>',<\/span> '2025<\/span>–<\/span>03<\/span>–<\/span>31<\/span>',<\/span> 'Active',<\/span> 300000<\/span>)<\/span>,<\/span>
      \n (<\/span>5<\/span>,<\/span> '\u6570\u636e\u4e2d\u53f0\u5efa\u8bbe',<\/span> '\u4f01\u4e1a\u7ea7\u6570\u636e\u6cbb\u7406\u4e0e\u5206\u6790\u5e73\u53f0',<\/span> 1<\/span>,<\/span> '2024<\/span>–<\/span>07<\/span>–<\/span>01<\/span>',<\/span> '2025<\/span>–<\/span>06<\/span>–<\/span>30<\/span>',<\/span> 'Planning',<\/span> 2000000<\/span>)<\/span>,<\/span>
      \n (<\/span>6<\/span>,<\/span> '\u5fae\u670d\u52a1\u67b6\u6784\u8fc1\u79fb',<\/span> '\u5355\u4f53\u5e94\u7528\u62c6\u5206\u4e3a\u5fae\u670d\u52a1\u67b6\u6784',<\/span> 1<\/span>,<\/span> '2023<\/span>–<\/span>10<\/span>–<\/span>01<\/span>',<\/span> '2024<\/span>–<\/span>08<\/span>–<\/span>31<\/span>',<\/span> 'Completed',<\/span> 1500000<\/span>)<\/span>
      \n""<\/span>")<\/span>;<\/span><\/p>\n

      Console.<\/span>WriteLine<\/span>(<\/span>"\u2705 \u793a\u4f8b\u6570\u636e\u5e93\u521d\u59cb\u5316\u5b8c\u6210！"<\/span>)<\/span>;<\/span>
      \nConsole.<\/span>WriteLine<\/span>(<\/span>$" – \u90e8\u95e8: <\/span>{<\/span>connection.<\/span>ExecuteScalar<\/span><<\/span>int<\/span>><\/span><\/span><\/span>(<\/span>"SELECT COUNT(*) FROM Departments"<\/span>)<\/span><\/span>}<\/span><\/span> \u6761"<\/span><\/span>)<\/span>;<\/span>
      \nConsole.<\/span>WriteLine<\/span>(<\/span>$" – \u5458\u5de5: <\/span>{<\/span>connection.<\/span>ExecuteScalar<\/span><<\/span>int<\/span>><\/span><\/span><\/span>(<\/span>"SELECT COUNT(*) FROM Employees"<\/span>)<\/span><\/span>}<\/span><\/span> \u6761"<\/span><\/span>)<\/span>;<\/span>
      \nConsole.<\/span>WriteLine<\/span>(<\/span>$" – \u9879\u76ee: <\/span>{<\/span>connection.<\/span>ExecuteScalar<\/span><<\/span>int<\/span>><\/span><\/span><\/span>(<\/span>"SELECT COUNT(*) FROM Projects"<\/span>)<\/span><\/span>}<\/span><\/span> \u6761"<\/span><\/span>)<\/span>;<\/span><\/p>\n

      \n

      \u56db\u3001\u914d\u7f6e AI \u5ba2\u6237\u7aef<\/h3>\n

      4.1 \u5728 Cursor \u4e2d\u914d\u7f6e<\/h4>\n

      \u5728\u9879\u76ee\u6839\u76ee\u5f55\u6216 Cursor \u7684\u5168\u5c40\u914d\u7f6e\u4e2d\u521b\u5efa .cursor\/mcp.json：<\/p>\n

      {<\/span>
      \n "mcpServers"<\/span>:<\/span> {<\/span>
      \n "db-query"<\/span>:<\/span> {<\/span>
      \n "command"<\/span>:<\/span> "dotnet"<\/span>,<\/span>
      \n "args"<\/span>:<\/span> [<\/span>
      \n "run"<\/span>,<\/span>
      \n "–project"<\/span>,<\/span>
      \n "D:\\\\\\\\path\\\\\\\\to\\\\\\\\DbQueryMCP\\\\\\\\DbQueryMCP.csproj"<\/span>
      \n ]<\/span>,<\/span>
      \n "env"<\/span>:<\/span> {<\/span>
      \n "DOTNET_ENVIRONMENT"<\/span>:<\/span> "Development"<\/span>
      \n }<\/span>
      \n }<\/span>
      \n }<\/span>
      \n}<\/span><\/p>\n

      4.2 \u5728 VS Code \u4e2d\u914d\u7f6e<\/h4>\n

      \u5728 .vscode\/mcp.json \u4e2d\u6dfb\u52a0：<\/p>\n

      {<\/span>
      \n "inputs"<\/span>:<\/span> [<\/span>]<\/span>,<\/span>
      \n "servers"<\/span>:<\/span> {<\/span>
      \n "db-query"<\/span>:<\/span> {<\/span>
      \n "type"<\/span>:<\/span> "stdio"<\/span>,<\/span>
      \n "command"<\/span>:<\/span> "dotnet"<\/span>,<\/span>
      \n "args"<\/span>:<\/span> [<\/span>
      \n "run"<\/span>,<\/span>
      \n "–project"<\/span>,<\/span>
      \n "D:\\\\\\\\path\\\\\\\\to\\\\\\\\DbQueryMCP\\\\\\\\DbQueryMCP.csproj"<\/span>
      \n ]<\/span>
      \n }<\/span>
      \n }<\/span>
      \n}<\/span><\/p>\n

      4.3 \u4f7f\u7528\u7f16\u8bd1\u540e\u7684\u53ef\u6267\u884c\u6587\u4ef6（\u63a8\u8350\u751f\u4ea7\u65b9\u5f0f）<\/h4>\n

      \u5148\u53d1\u5e03\u5e94\u7528：<\/p>\n

      dotnet publish -c Release -o .\/publish<\/p>\n

      \u7136\u540e\u914d\u7f6e\u4f7f\u7528\u7f16\u8bd1\u540e\u7684 exe：<\/p>\n

      {<\/span>
      \n "mcpServers"<\/span>:<\/span> {<\/span>
      \n "db-query"<\/span>:<\/span> {<\/span>
      \n "command"<\/span>:<\/span> "D:\\\\\\\\path\\\\\\\\to\\\\\\\\publish\\\\\\\\DbQueryMCP.exe"<\/span>,<\/span>
      \n "args"<\/span>:<\/span> [<\/span>]<\/span>
      \n }<\/span>
      \n }<\/span>
      \n}<\/span><\/p>\n

      \n

      \u4e94\u3001\u5b9e\u9645\u4f7f\u7528\u6548\u679c<\/h3>\n

      5.1 \u67e5\u8be2\u6570\u636e\u5e93\u7ed3\u6784<\/h4>\n

      \u5728 Cursor \/ Copilot \u7684\u5bf9\u8bdd\u4e2d，\u4f60\u53ef\u4ee5\u8fd9\u6837\u95ee：<\/p>\n

      \u63d0\u95ee：\u201c\u5e2e\u6211\u770b\u770b\u6570\u636e\u5e93\u91cc\u6709\u54ea\u4e9b\u8868？\u201d<\/p>\n

      AI \u4f1a\u81ea\u52a8\u8c03\u7528 GetAllTables \u5de5\u5177，cursor\u622a\u56fe： \"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

      5.2 \u5206\u6790\u8868\u7ed3\u6784<\/h4>\n

      \u63d0\u95ee：\u201c\u5458\u5de5\u8868\u6709\u54ea\u4e9b\u5b57\u6bb5？\u201d<\/p>\n

      AI \u8c03\u7528 GetTableColumns： \"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

      5.3 \u667a\u80fd\u67e5\u8be2\u6570\u636e<\/h4>\n

      \u63d0\u95ee：\u201c\u5e2e\u6211\u67e5\u4e00\u4e0b\u6280\u672f\u7814\u53d1\u90e8\u6240\u6709\u5728\u804c\u5458\u5de5\u7684\u59d3\u540d\u548c\u85aa\u8d44，\u6309\u85aa\u8d44\u4ece\u9ad8\u5230\u4f4e\u6392\u5217\u3002\u201d<\/p>\n

      AI \u4f1a\u81ea\u52a8\u7ec4\u88c5 SQL \u5e76\u8c03\u7528 ExecuteSelectQuery：<\/p>\n

      SELECT<\/span> e.<\/span>Name,<\/span> e.<\/span>Position,<\/span> e.<\/span>Salary
      \nFROM<\/span> Employees e
      \nJOIN<\/span> Departments d ON<\/span> e.<\/span>DepartmentId =<\/span> d.<\/span>Id
      \nWHERE<\/span> d.<\/span>Name =<\/span> '\u6280\u672f\u7814\u53d1\u90e8'<\/span> AND<\/span> e.<\/span>IsActive =<\/span> 1<\/span>
      \nORDER<\/span> BY<\/span> e.<\/span>Salary DESC<\/span><\/p>\n

      \"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

      5.4 \u6570\u636e\u7edf\u8ba1<\/h4>\n

      \u63d0\u95ee：\u201c\u5404\u90e8\u95e8\u7684\u5e73\u5747\u85aa\u8d44\u662f\u591a\u5c11？\u201d<\/p>\n

      AI \u81ea\u52a8\u6784\u9020\u805a\u5408\u67e5\u8be2：<\/p>\n

      SELECT<\/span> d.<\/span>Name AS<\/span> \u90e8\u95e8,<\/span> AVG<\/span>(<\/span>e.<\/span>Salary)<\/span> AS<\/span> \u5e73\u5747\u85aa\u8d44,<\/span> COUNT<\/span>(<\/span>e.<\/span>Id)<\/span> AS<\/span> \u4eba\u6570
      \nFROM<\/span> Employees e
      \nJOIN<\/span> Departments d ON<\/span> e.<\/span>DepartmentId =<\/span> d.<\/span>Id
      \nWHERE<\/span> e.<\/span>IsActive =<\/span> 1<\/span>
      \nGROUP<\/span> BY<\/span> d.<\/span>Name
      \nORDER<\/span> BY<\/span> \u5e73\u5747\u85aa\u8d44 DESC<\/span><\/p>\n

      \n

      \"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

      \u516d\u3001\u8fdb\u9636：HTTP\/SSE \u4f20\u8f93\u6a21\u5f0f<\/h3>\n

      6.1 \u4e3a\u4ec0\u4e48\u9700\u8981 HTTP \u4f20\u8f93？<\/h4>\n

      stdio \u6a21\u5f0f \u9002\u5408\u672c\u5730\u5f00\u53d1，MCP \u5ba2\u6237\u7aef\u76f4\u63a5\u542f\u52a8\u670d\u52a1\u5668\u8fdb\u7a0b\u3002\u4f46\u5728\u4ee5\u4e0b\u573a\u666f\u9700\u8981 HTTP \u4f20\u8f93：<\/p>\n

        \n
      • MCP \u670d\u52a1\u5668\u90e8\u7f72\u5728\u8fdc\u7a0b\u670d\u52a1\u5668<\/li>\n
      • \u591a\u4e2a\u7528\u6237\u5171\u4eab\u4e00\u4e2a MCP \u670d\u52a1\u5668<\/li>\n
      • \u670d\u52a1\u5668\u9700\u8981\u8fde\u63a5\u4f01\u4e1a\u5185\u7f51\u6570\u636e\u5e93<\/li>\n
      • \u9700\u8981\u66f4\u597d\u7684\u8ba4\u8bc1\u548c\u6388\u6743\u63a7\u5236<\/li>\n<\/ul>\n

        6.2 \u6539\u9020\u4e3a ASP.NET Core \u5e94\u7528<\/h4>\n

        using<\/span> DbQueryMCP.<\/span>Services<\/span>;<\/span>
        \nusing<\/span> ModelContextProtocol.<\/span>AspNetCore<\/span>;<\/span><\/p>\n

        var<\/span><\/span> builder =<\/span> WebApplication.<\/span>CreateBuilder<\/span>(<\/span>args)<\/span>;<\/span><\/p>\n

        \/\/ \u6ce8\u518c\u670d\u52a1<\/span>
        \nbuilder.<\/span>Services.<\/span>AddSingleton<\/span><<\/span>DatabaseService><\/span><\/span><\/span>(<\/span>)<\/span>;<\/span><\/p>\n

        \/\/ \u914d\u7f6e MCP \u670d\u52a1\u5668（HTTP \u6a21\u5f0f）<\/span>
        \nbuilder.<\/span>Services
        \n .<\/span>AddMcpServer<\/span>(<\/span>)<\/span>
        \n .<\/span>WithHttpTransport<\/span>(<\/span>)<\/span>
        \n .<\/span>WithToolsFromAssembly<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

        var<\/span><\/span> app =<\/span> builder.<\/span>Build<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

        \/\/ \u6620\u5c04 MCP \u7aef\u70b9<\/span>
        \napp.<\/span>MapMcp<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

        app.<\/span>Run<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

        \u5bf9\u5e94\u7684\u5ba2\u6237\u7aef\u914d\u7f6e（mcp.json）：<\/p>\n

        {<\/span>
        \n "servers"<\/span>:<\/span> {<\/span>
        \n "db-query-remote"<\/span>:<\/span> {<\/span>
        \n "type"<\/span>:<\/span> "http"<\/span>,<\/span>
        \n "url"<\/span>:<\/span> "http:\/\/localhost:5000"<\/span>
        \n }<\/span>
        \n }<\/span>
        \n}<\/span><\/p>\n

        6.3 \u6dfb\u52a0\u8ba4\u8bc1\u652f\u6301<\/h4>\n

        \u5728\u751f\u4ea7\u73af\u5883\u4e2d，MCP \u670d\u52a1\u5668\u5e94\u8be5\u8981\u6c42\u8ba4\u8bc1：<\/p>\n

        var<\/span><\/span> builder =<\/span> WebApplication.<\/span>CreateBuilder<\/span>(<\/span>args)<\/span>;<\/span><\/p>\n

        builder.<\/span>Services.<\/span>AddAuthentication<\/span>(<\/span>"Bearer"<\/span>)<\/span>
        \n .<\/span>AddJwtBearer<\/span>(<\/span>options =><\/span>
        \n {<\/span>
        \n options.<\/span>Authority =<\/span> "https:\/\/your-auth-server.com"<\/span>;<\/span>
        \n options.<\/span>Audience =<\/span> "mcp-server"<\/span>;<\/span>
        \n }<\/span>)<\/span>;<\/span><\/p>\n

        builder.<\/span>Services.<\/span>AddAuthorization<\/span>(<\/span>)<\/span>;<\/span>
        \nbuilder.<\/span>Services.<\/span>AddSingleton<\/span><<\/span>DatabaseService><\/span><\/span><\/span>(<\/span>)<\/span>;<\/span><\/p>\n

        builder.<\/span>Services
        \n .<\/span>AddMcpServer<\/span>(<\/span>)<\/span>
        \n .<\/span>WithHttpTransport<\/span>(<\/span>)<\/span>
        \n .<\/span>WithToolsFromAssembly<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

        var<\/span><\/span> app =<\/span> builder.<\/span>Build<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

        app.<\/span>UseAuthentication<\/span>(<\/span>)<\/span>;<\/span>
        \napp.<\/span>UseAuthorization<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

        app.<\/span>MapMcp<\/span>(<\/span>)<\/span>.<\/span>RequireAuthorization<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

        app.<\/span>Run<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

        \n

        \u4e03\u3001\u5bb9\u5668\u5316\u90e8\u7f72<\/h3>\n

        7.1 Dockerfile<\/h4>\n

        FROM mcr.microsoft.com\/dotnet\/sdk:8.0 AS build
        \nWORKDIR \/src
        \nCOPY . .
        \nRUN dotnet publish -c Release -o \/app<\/p>\n

        FROM mcr.microsoft.com\/dotnet\/aspnet:8.0 AS runtime
        \nWORKDIR \/app
        \nCOPY –from=build \/app .
        \nEXPOSE 5000
        \nENTRYPOINT ["dotnet", "DbQueryMCP.dll"]<\/p>\n

        7.2 Docker Compose（\u8fde\u63a5\u5916\u90e8\u6570\u636e\u5e93）<\/h4>\n

        version<\/span>:<\/span> '3.8'<\/span>
        \nservices<\/span>:<\/span>
        \n mcp-server<\/span>:<\/span>
        \n build<\/span>:<\/span> .
        \n ports<\/span>:<\/span>
        \n –<\/span> "5000:5000"<\/span>
        \n environment<\/span>:<\/span>
        \n –<\/span> ConnectionStrings__DefaultConnection=Data Source=\/data\/production.db
        \n –<\/span> ASPNETCORE_ENVIRONMENT=Production
        \n volumes<\/span>:<\/span>
        \n –<\/span> .\/data:<\/span>\/data<\/p>\n

        7.3 \u5728 MCP \u5ba2\u6237\u7aef\u4e2d\u4f7f\u7528 Docker \u955c\u50cf<\/h4>\n

        {<\/span>
        \n "mcpServers"<\/span>:<\/span> {<\/span>
        \n "db-query-docker"<\/span>:<\/span> {<\/span>
        \n "command"<\/span>:<\/span> "docker"<\/span>,<\/span>
        \n "args"<\/span>:<\/span> [<\/span>"run"<\/span>,<\/span> "-i"<\/span>,<\/span> "–rm"<\/span>,<\/span>
        \n "-v"<\/span>,<\/span> "D:\/data:\/data"<\/span>,<\/span>
        \n "your-registry\/db-query-mcp:latest"<\/span>]<\/span>
        \n }<\/span>
        \n }<\/span>
        \n}<\/span><\/p>\n

        \n

        \u516b\u3001\u6700\u4f73\u5b9e\u8df5\u4e0e\u5b89\u5168\u8003\u91cf<\/h3>\n

        8.1 \u5b89\u5168\u6700\u4f73\u5b9e\u8df5<\/h4>\n\n\u5b9e\u8df5\u8bf4\u660e<\/tr>\n\n\n\n\n\n\n\n
        \u53ea\u8bfb\u67e5\u8be2<\/td>\nMCP \u5de5\u5177\u4ec5\u66b4\u9732 SELECT \u64cd\u4f5c，\u7981\u6b62\u6570\u636e\u4fee\u6539<\/td>\n<\/tr>\n
        SQL \u6ce8\u5165\u9632\u62a4<\/td>\n\u4f7f\u7528\u53c2\u6570\u5316\u67e5\u8be2，\u4e25\u683c\u8fc7\u6ee4\u5371\u9669\u5173\u952e\u5b57<\/td>\n<\/tr>\n
        \u884c\u6570\u9650\u5236<\/td>\n\u9ed8\u8ba4\u9650\u5236\u8fd4\u56de\u884c\u6570，\u9632\u6b62\u5168\u8868\u626b\u63cf<\/td>\n<\/tr>\n
        \u8fde\u63a5\u5b57\u7b26\u4e32\u5b89\u5168<\/td>\n\u4f7f\u7528\u73af\u5883\u53d8\u91cf\u6216 Secret Manager \u7ba1\u7406\u8fde\u63a5\u5b57\u7b26\u4e32<\/td>\n<\/tr>\n
        \u5ba1\u8ba1\u65e5\u5fd7<\/td>\n\u8bb0\u5f55\u6240\u6709\u67e5\u8be2\u64cd\u4f5c，\u4fbf\u4e8e\u8ffd\u6eaf<\/td>\n<\/tr>\n
        \u6700\u5c0f\u6743\u9650<\/td>\n\u6570\u636e\u5e93\u8d26\u6237\u4ec5\u6388\u4e88 SELECT \u6743\u9650<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        8.2 \u5de5\u5177\u63cf\u8ff0\u7684\u91cd\u8981\u6027<\/h4>\n

        [Description] \u7279\u6027\u4e2d\u7684\u6587\u672c\u4f1a\u88ab\u76f4\u63a5\u4f20\u9012\u7ed9 AI \u6a21\u578b，\u5b83\u51b3\u5b9a\u4e86 AI \u4f55\u65f6\u4ee5\u53ca\u5982\u4f55\u8c03\u7528\u4f60\u7684\u5de5\u5177\u3002\u597d\u7684\u63cf\u8ff0\u5e94\u8be5：<\/p>\n

        \/\/ \u274c \u5dee\u7684\u63cf\u8ff0 – \u592a\u7b80\u77ed，AI \u4e0d\u77e5\u9053\u4f55\u65f6\u4f7f\u7528<\/span>
        \n[<\/span>McpServerTool,<\/span> Description<\/span>(<\/span>"\u67e5\u8be2\u6570\u636e"<\/span>)<\/span>]<\/span>
        \npublic<\/span> static<\/span> async<\/span> Task<<\/span>string<\/span>><\/span><\/span> Query<\/span>(<\/span>..<\/span>.<\/span>)<\/span><\/p>\n

        \/\/ \u2705 \u597d\u7684\u63cf\u8ff0 – \u660e\u786e\u8bf4\u660e\u529f\u80fd\u3001\u4f7f\u7528\u573a\u666f\u548c\u9650\u5236<\/span>
        \n[<\/span>McpServerTool<\/span>,<\/span> Description<\/span>(<\/span>
        \n "\u5728\u6570\u636e\u5e93\u4e0a\u6267\u884c SQL SELECT \u67e5\u8be2\u5e76\u8fd4\u56de\u7ed3\u679c\u3002"<\/span> +<\/span>
        \n "\u4ec5\u652f\u6301 SELECT \u8bed\u53e5，\u7981\u6b62\u6570\u636e\u4fee\u6539\u64cd\u4f5c\u3002"<\/span> +<\/span>
        \n "\u7ed3\u679c\u9ed8\u8ba4\u9650\u5236\u6700\u591a\u8fd4\u56de 100 \u884c\u3002"<\/span>)<\/span><\/span><\/span>]<\/span>
        \npublic<\/span> static<\/span> async<\/span> Task<<\/span>string<\/span>><\/span><\/span> ExecuteSelectQuery<\/span>(<\/span>..<\/span>.<\/span>)<\/span><\/p>\n

        8.3 \u53c2\u6570\u63cf\u8ff0\u540c\u6837\u91cd\u8981<\/h4>\n

        \/\/ \u274c \u6ca1\u6709\u63cf\u8ff0<\/span>
        \npublic<\/span> static<\/span> async<\/span> Task<<\/span>string<\/span>><\/span><\/span> Search<\/span>(<\/span>string<\/span><\/span> table,<\/span> string<\/span><\/span> col,<\/span> string<\/span><\/span> val)<\/span><\/p>\n

        \/\/ \u2705 \u6bcf\u4e2a\u53c2\u6570\u90fd\u6709\u6e05\u6670\u63cf\u8ff0<\/span>
        \npublic<\/span> static<\/span> async<\/span> Task<<\/span>string<\/span>><\/span><\/span> SearchInTable<\/span>(<\/span>
        \n [<\/span>Description<\/span>(<\/span>"\u8981\u641c\u7d22\u7684\u8868\u540d，\u5982 Employees\u3001Departments"<\/span>)<\/span><\/span><\/span>]<\/span> string<\/span><\/span> tableName,<\/span>
        \n [<\/span>Description<\/span>(<\/span>"\u8981\u641c\u7d22\u7684\u5217\u540d，\u5982 Name\u3001Email"<\/span>)<\/span><\/span><\/span>]<\/span> string<\/span><\/span> columnName,<\/span>
        \n [<\/span>Description<\/span>(<\/span>"\u641c\u7d22\u5173\u952e\u5b57，\u652f\u6301\u90e8\u5206\u5339\u914d"<\/span>)<\/span><\/span><\/span>]<\/span> string<\/span><\/span> keyword)<\/span><\/p>\n

        8.4 \u9519\u8bef\u5904\u7406<\/h4>\n

        MCP \u5de5\u5177\u5e94\u5f53\u4f18\u96c5\u5730\u5904\u7406\u9519\u8bef，\u8fd4\u56de\u6709\u610f\u4e49\u7684\u9519\u8bef\u4fe1\u606f\u800c\u975e\u629b\u51fa\u5f02\u5e38：<\/p>\n

        [<\/span>McpServerTool<\/span>,<\/span> Description<\/span>(<\/span>"\u6267\u884c\u67e5\u8be2"<\/span>)<\/span><\/span><\/span>]<\/span>
        \npublic<\/span> static<\/span> async<\/span> Task<<\/span>string<\/span>><\/span><\/span> ExecuteQuery<\/span>(<\/span>
        \n DatabaseService<\/span> dbService,<\/span>
        \n [<\/span>Description<\/span>(<\/span>"SQL \u67e5\u8be2\u8bed\u53e5"<\/span>)<\/span><\/span><\/span>]<\/span> string<\/span><\/span> sql)<\/span>
        \n{<\/span>
        \n try<\/span>
        \n {<\/span>
        \n return<\/span> await<\/span> dbService.<\/span>ExecuteQueryAsync<\/span>(<\/span>sql)<\/span>;<\/span>
        \n }<\/span>
        \n catch<\/span> (<\/span>InvalidOperationException<\/span> ex)<\/span>
        \n {<\/span>
        \n \/\/ \u4e1a\u52a1\u903b\u8f91\u9519\u8bef – \u8fd4\u56de\u53cb\u597d\u63d0\u793a<\/span>
        \n return<\/span> $"\u26a0\ufe0f \u67e5\u8be2\u88ab\u62d2\u7edd：<\/span>{<\/span>ex.<\/span>Message<\/span>}<\/span><\/span>"<\/span><\/span>;<\/span>
        \n }<\/span>
        \n catch<\/span> (<\/span>SqliteException<\/span> ex)<\/span>
        \n {<\/span>
        \n \/\/ SQL \u6267\u884c\u9519\u8bef – \u8fd4\u56de\u6709\u52a9\u4e8e AI \u4fee\u6b63\u7684\u4fe1\u606f<\/span>
        \n return<\/span> $"\u274c SQL \u8bed\u6cd5\u9519\u8bef：<\/span>{<\/span>ex.<\/span>Message<\/span>}<\/span><\/span>\\\\n\u8bf7\u68c0\u67e5\u8868\u540d\u548c\u5217\u540d\u662f\u5426\u6b63\u786e\u3002"<\/span><\/span>;<\/span>
        \n }<\/span>
        \n catch<\/span> (<\/span>Exception<\/span> ex)<\/span>
        \n {<\/span>
        \n \/\/ \u672a\u9884\u671f\u7684\u9519\u8bef<\/span>
        \n return<\/span> $"\u274c \u53d1\u751f\u610f\u5916\u9519\u8bef：<\/span>{<\/span>ex.<\/span>Message<\/span>}<\/span><\/span>"<\/span><\/span>;<\/span>
        \n }<\/span>
        \n}<\/span><\/p>\n

        8.5 \u4f9d\u8d56\u6ce8\u5165\u7684\u5de7\u5999\u8fd0\u7528<\/h4>\n

        MCP C# SDK \u5b8c\u7f8e\u652f\u6301\u4f9d\u8d56\u6ce8\u5165\u3002\u5de5\u5177\u65b9\u6cd5\u7684\u53c2\u6570\u4e2d，\u975e\u57fa\u672c\u7c7b\u578b\u4f1a\u81ea\u52a8\u4ece DI \u5bb9\u5668\u4e2d\u89e3\u6790：<\/p>\n

        [<\/span>McpServerToolType<\/span><\/span>]<\/span>
        \npublic<\/span> static<\/span> class<\/span> MyTools<\/span>
        \n{<\/span>
        \n \/\/ dbService \u4ece DI \u5bb9\u5668\u81ea\u52a8\u6ce8\u5165<\/span>
        \n \/\/ tableName \u7531 AI \u5ba2\u6237\u7aef\u4f20\u5165<\/span>
        \n [<\/span>McpServerTool<\/span>,<\/span> Description<\/span>(<\/span>"\u83b7\u53d6\u6307\u5b9a\u8868\u7684\u7edf\u8ba1\u6458\u8981\u4fe1\u606f"<\/span>)<\/span><\/span><\/span>]<\/span>
        \n public<\/span> static<\/span> async<\/span> Task<<\/span>string<\/span>><\/span><\/span> GetData<\/span>(<\/span>
        \n DatabaseService<\/span> dbService,<\/span> \/\/ \u2190 \u81ea\u52a8\u6ce8\u5165<\/span>
        \n ILogger<<\/span>MyTools><\/span><\/span> logger,<\/span> \/\/ \u2190 \u81ea\u52a8\u6ce8\u5165<\/span>
        \n [<\/span>Description<\/span>(<\/span>"\u8868\u540d"<\/span>)<\/span><\/span><\/span>]<\/span> string<\/span><\/span> tableName)<\/span> \/\/ \u2190 AI \u4f20\u5165<\/span>
        \n {<\/span>
        \n logger.<\/span>LogInformation<\/span>(<\/span>"\u67e5\u8be2\u8868: {Table}"<\/span>,<\/span> tableName)<\/span>;<\/span>
        \n return<\/span> await<\/span> dbService.<\/span>GetTableSummaryAsync<\/span>(<\/span>tableName)<\/span>;<\/span>
        \n }<\/span>
        \n}<\/span><\/p>\n

        \n

        \u4e5d\u3001\u9002\u914d SQL Server \/ PostgreSQL<\/h3>\n

        \u4e0a\u9762\u7684\u793a\u4f8b\u4f7f\u7528 SQLite，\u5b9e\u9645\u9879\u76ee\u4e2d\u901a\u5e38\u4f7f\u7528 SQL Server \u6216 PostgreSQL\u3002\u4ee5\u4e0b\u662f\u9002\u914d\u8981\u70b9：<\/p>\n

        9.1 SQL Server \u9002\u914d<\/h4>\n

        # \u66ff\u6362 NuGet \u5305<\/span>
        \ndotnet remove package Microsoft.Data.Sqlite
        \ndotnet add<\/span> package Microsoft.Data.SqlClient<\/p>\n

        \u4fee\u6539 DatabaseService \u4e2d\u83b7\u53d6\u8868\u548c\u5217\u4fe1\u606f\u7684 SQL：<\/p>\n

        \/\/ \u83b7\u53d6\u6240\u6709\u8868<\/span>
        \nvar<\/span><\/span> tables =<\/span> await<\/span> conn.<\/span>QueryAsync<\/span><<\/span>string<\/span>><\/span><\/span><\/span>(<\/span>
        \n "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'"<\/span>)<\/span>;<\/span><\/p>\n

        \/\/ \u83b7\u53d6\u5217\u4fe1\u606f<\/span>
        \nvar<\/span><\/span> columns =<\/span> await<\/span> conn.<\/span>QueryAsync<\/span><<\/span>ColumnInfo><\/span><\/span><\/span>(<\/span>
        \n @"SELECT
        \n COLUMN_NAME AS ColumnName,
        \n DATA_TYPE AS DataType,
        \n CASE IS_NULLABLE WHEN 'YES' THEN 1 ELSE 0 END AS IsNullable,
        \n CASE WHEN pk.COLUMN_NAME IS NOT NULL THEN 1 ELSE 0 END AS IsPrimaryKey,
        \n COLUMN_DEFAULT AS DefaultValue
        \n FROM INFORMATION_SCHEMA.COLUMNS c
        \n LEFT JOIN (
        \n SELECT ku.COLUMN_NAME
        \n FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
        \n JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE ku
        \n ON tc.CONSTRAINT_NAME = ku.CONSTRAINT_NAME
        \n WHERE tc.CONSTRAINT_TYPE = 'PRIMARY KEY'
        \n AND ku.TABLE_NAME = @TableName
        \n ) pk ON c.COLUMN_NAME = pk.COLUMN_NAME
        \n WHERE c.TABLE_NAME = @TableName"<\/span>,<\/span>
        \n new<\/span> {<\/span> TableName =<\/span> tableName }<\/span>)<\/span>;<\/span><\/p>\n

        9.2 PostgreSQL \u9002\u914d<\/h4>\n

        dotnet remove package Microsoft.Data.Sqlite
        \ndotnet add<\/span> package Npgsql<\/p>\n

        \/\/ \u83b7\u53d6\u6240\u6709\u8868<\/span>
        \nvar<\/span><\/span> tables =<\/span> await<\/span> conn.<\/span>QueryAsync<\/span><<\/span>string<\/span>><\/span><\/span><\/span>(<\/span>
        \n @"SELECT tablename FROM pg_tables
        \n WHERE schemaname = 'public'"<\/span>)<\/span>;<\/span><\/p>\n

        \/\/ \u83b7\u53d6\u5217\u4fe1\u606f<\/span>
        \nvar<\/span><\/span> columns =<\/span> await<\/span> conn.<\/span>QueryAsync<\/span><<\/span>ColumnInfo><\/span><\/span><\/span>(<\/span>
        \n @"SELECT
        \n column_name AS ColumnName,
        \n data_type AS DataType,
        \n CASE is_nullable WHEN 'YES' THEN true ELSE false END AS IsNullable,
        \n CASE WHEN pk.column_name IS NOT NULL THEN true ELSE false END AS IsPrimaryKey,
        \n column_default AS DefaultValue
        \n FROM information_schema.columns c
        \n LEFT JOIN (
        \n SELECT kcu.column_name
        \n FROM information_schema.table_constraints tc
        \n JOIN information_schema.key_column_usage kcu
        \n ON tc.constraint_name = kcu.constraint_name
        \n WHERE tc.constraint_type = 'PRIMARY KEY'
        \n AND kcu.table_name = @TableName
        \n ) pk ON c.column_name = pk.column_name
        \n WHERE c.table_name = @TableName"<\/span>,<\/span>
        \n new<\/span> {<\/span> TableName =<\/span> tableName }<\/span>)<\/span>;<\/span><\/p>\n

        \n

        \u5341\u3001\u5b8c\u6574\u9879\u76ee\u6587\u4ef6\u53c2\u8003<\/h3>\n

        DbQueryMCP.csproj<\/h4>\n

        <<\/span>Project<\/span> Sdk<\/span>=<\/span>"<\/span>Microsoft.NET.Sdk"<\/span><\/span>><\/span><\/span><\/p>\n

        <<\/span>PropertyGroup<\/span>><\/span><\/span>
        \n <<\/span>OutputType<\/span>><\/span><\/span>Exe<\/<\/span>OutputType<\/span>><\/span><\/span>
        \n <<\/span>TargetFramework<\/span>><\/span><\/span>net8.0<\/<\/span>TargetFramework<\/span>><\/span><\/span>
        \n <<\/span>ImplicitUsings<\/span>><\/span><\/span>enable<\/<\/span>ImplicitUsings<\/span>><\/span><\/span>
        \n <<\/span>Nullable<\/span>><\/span><\/span>enable<\/<\/span>Nullable<\/span>><\/span><\/span>
        \n <\/<\/span>PropertyGroup<\/span>><\/span><\/span><\/p>\n

        <<\/span>ItemGroup<\/span>><\/span><\/span>
        \n <<\/span>PackageReference<\/span> Include<\/span>=<\/span>"<\/span>ModelContextProtocol"<\/span><\/span> Version<\/span>=<\/span>"<\/span>0.8.0-preview.1"<\/span><\/span> \/><\/span><\/span>
        \n <<\/span>PackageReference<\/span> Include<\/span>=<\/span>"<\/span>Microsoft.Extensions.Hosting"<\/span><\/span> Version<\/span>=<\/span>"<\/span>8.0.0"<\/span><\/span> \/><\/span><\/span>
        \n <<\/span>PackageReference<\/span> Include<\/span>=<\/span>"<\/span>Microsoft.Data.Sqlite"<\/span><\/span> Version<\/span>=<\/span>"<\/span>8.0.0"<\/span><\/span> \/><\/span><\/span>
        \n <<\/span>PackageReference<\/span> Include<\/span>=<\/span>"<\/span>Dapper"<\/span><\/span> Version<\/span>=<\/span>"<\/span>2.1.66"<\/span><\/span> \/><\/span><\/span>
        \n <\/<\/span>ItemGroup<\/span>><\/span><\/span><\/p>\n

        <<\/span>ItemGroup<\/span>><\/span><\/span>
        \n <<\/span>None<\/span> Update<\/span>=<\/span>"<\/span>appsettings.json"<\/span><\/span>><\/span><\/span>
        \n <<\/span>CopyToOutputDirectory<\/span>><\/span><\/span>PreserveNewest<\/<\/span>CopyToOutputDirectory<\/span>><\/span><\/span>
        \n <\/<\/span>None<\/span>><\/span><\/span>
        \n <\/<\/span>ItemGroup<\/span>><\/span><\/span><\/p>\n

        <\/<\/span>Project<\/span>><\/span><\/span><\/p>\n

        \n

        \u5341\u4e00\u3001\u603b\u7ed3\u4e0e\u5c55\u671b<\/h3>\n

        11.1 \u672c\u6587\u8981\u70b9\u56de\u987e<\/h4>\n
      • MCP \u534f\u8bae \u662f AI \u4e0e\u5916\u90e8\u5de5\u5177\u4e4b\u95f4\u7684\u6807\u51c6\u5316\u901a\u4fe1\u534f\u8bae<\/li>\n
      • C# MCP SDK \u7531\u5fae\u8f6f\u4e0e Anthropic \u8054\u5408\u7ef4\u62a4，\u662f\u5b98\u65b9\u7ea7\u5b9e\u73b0<\/li>\n
      • \u901a\u8fc7 [McpServerToolType] \u548c [McpServerTool] \u7279\u6027\u5373\u53ef\u5feb\u901f\u66b4\u9732\u5de5\u5177<\/li>\n
      • \u4f9d\u8d56\u6ce8\u5165 \u8ba9 MCP \u5de5\u5177\u53ef\u4ee5\u65b9\u4fbf\u5730\u4f7f\u7528\u5404\u79cd\u670d\u52a1<\/li>\n
      • \u5b89\u5168\u81f3\u4e0a：\u53ea\u8bfb\u67e5\u8be2\u3001SQL \u6ce8\u5165\u9632\u62a4\u3001\u884c\u6570\u9650\u5236\u662f\u5e95\u7ebf<\/li>\n
      • \u652f\u6301 stdio \u548c HTTP\/SSE \u4e24\u79cd\u4f20\u8f93\u6a21\u5f0f，\u9002\u914d\u4e0d\u540c\u90e8\u7f72\u573a\u666f<\/li>\n

        11.2 MCP \u751f\u6001\u5c55\u671b<\/h4>\n

        MCP \u6b63\u5904\u4e8e\u5feb\u901f\u53d1\u5c55\u9636\u6bb5，\u503c\u5f97\u5173\u6ce8\u7684\u65b9\u5411：<\/p>\n

          \n
        • NuGet \u5206\u53d1：MCP \u670d\u52a1\u5668\u53ef\u4ee5\u6253\u5305\u4e3a NuGet \u5de5\u5177\u5305\u76f4\u63a5\u5206\u53d1<\/li>\n
        • Azure Functions：\u901a\u8fc7 Azure Functions \u6784\u5efa\u65e0\u670d\u52a1\u5668\u7684\u8fdc\u7a0b MCP \u670d\u52a1\u5668<\/li>\n
        • .NET Aspire \u96c6\u6210：\u672a\u6765\u53ef\u80fd\u4e0e .NET Aspire \u6df1\u5ea6\u6574\u5408<\/li>\n
        • Semantic Kernel \u534f\u540c：MCP \u5de5\u5177\u4e0e Semantic Kernel \u7684 Plugin \u4f53\u7cfb\u4e92\u8865<\/li>\n<\/ul>\n

          11.3 \u63a8\u8350\u8d44\u6e90<\/h4>\n\n\u8d44\u6e90\u94fe\u63a5<\/tr>\n\n\n\n\n\n\n\n
          MCP \u5b98\u65b9\u7f51\u7ad9<\/td>\nhttps:\/\/modelcontextprotocol.io<\/td>\n<\/tr>\n
          C# MCP SDK（GitHub）<\/td>\nhttps:\/\/github.com\/modelcontextprotocol\/csharp-sdk<\/td>\n<\/tr>\n
          \u5fae\u8f6f\u5b98\u65b9\u6559\u7a0b<\/td>\nhttps:\/\/learn.microsoft.com\/dotnet\/ai\/get-started-mcp<\/td>\n<\/tr>\n
          .NET \u5b98\u65b9\u535a\u5ba2<\/td>\nhttps:\/\/devblogs.microsoft.com\/dotnet\/build-a-model-context-protocol-mcp-server-in-csharp<\/td>\n<\/tr>\n
          MCP \u670d\u52a1\u5668\u793a\u4f8b\u5408\u96c6<\/td>\nhttps:\/\/github.com\/microsoft\/mcp-dotnet-samples<\/td>\n<\/tr>\n
          NuGet \u4e0a\u7684 MCP SDK<\/td>\nhttps:\/\/www.nuget.org\/packages\/ModelContextProtocol<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
          \n

          \u5199\u5728\u6700\u540e：MCP \u8ba9 AI \u4ece"\u53ea\u80fd\u770b\u4ee3\u7801"\u8fdb\u5316\u5230"\u80fd\u64cd\u4f5c\u4f60\u7684\u7cfb\u7edf"\u3002\u4f5c\u4e3a .NET \u5f00\u53d1\u8005，\u6211\u4eec\u62e5\u6709\u5f3a\u5927\u7684\u5de5\u5177\u94fe\u548c\u751f\u6001\u7cfb\u7edf\u6765\u6784\u5efa\u751f\u4ea7\u7ea7\u7684 MCP \u670d\u52a1\u5668\u3002\u65e0\u8bba\u662f\u8fde\u63a5\u4f01\u4e1a\u6570\u636e\u5e93\u3001\u8c03\u7528\u5185\u90e8 API，\u8fd8\u662f\u6574\u5408\u4e1a\u52a1\u6d41\u7a0b，MCP + .NET \u90fd\u662f\u4e00\u4e2a\u503c\u5f97\u6295\u5165\u7684\u6280\u672f\u7ec4\u5408\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

          \u5f53 AI \u52a9\u624b\u4e0d\u518d\u53ea\u662f\u751f\u6210 SQL \u8bed\u53e5，\u800c\u662f\u80fd\u591f\u76f4\u63a5\u8fde\u63a5\u4f60\u7684\u6570\u636e\u5e93\u3001\u67e5\u8be2\u6570\u636e\u3001\u5206\u6790\u7ed3\u6784\u2014\u2014\u8fd9\u5c31\u662f MCP \u4e3a .NET \u5f00\u53d1\u8005\u5e26\u6765\u7684\u5168\u65b0\u53ef\u80fd\u3002 \u4e00\u3001MCP \u662f\u4ec0\u4e48？\u4e3a\u4ec0\u4e48 .NET \u5f00\u53d1\u8005\u5e94\u8be5\u5173\u6ce8？
          \n1.1 MCP \u534f\u8bae\u7b80\u4ecb
          \nMCP（Model Context Protocol，\u6a21\u578b\u4e0a\u4e0b\u6587\u534f\u8bae） \u662f\u7531 Anthropic \u63a8\u51fa\u7684\u5f00\u6e90\u6807\u51c6\u534f\u8bae，\u65e8\u5728\u4e3a\u5927\u8bed\u8a00\u6a21\u578b（<\/p>\n","protected":false},"author":2,"featured_media":74432,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[893,2380,50,100],"topic":[],"class_list":["post-74436","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-netcore","tag-asp-net","tag-50","tag-100"],"yoast_head":"\n.NET \u5f00\u53d1 MCP \u670d\u52a1\u5668\u5b8c\u5168\u6307\u5357\uff1a\u6253\u9020\u667a\u80fd\u6570\u636e\u5e93\u67e5\u8be2\u52a9\u624b - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/74436.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\".NET \u5f00\u53d1 MCP \u670d\u52a1\u5668\u5b8c\u5168\u6307\u5357\uff1a\u6253\u9020\u667a\u80fd\u6570\u636e\u5e93\u67e5\u8be2\u52a9\u624b - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u5f53 AI \u52a9\u624b\u4e0d\u518d\u53ea\u662f\u751f\u6210 SQL \u8bed\u53e5，\u800c\u662f\u80fd\u591f\u76f4\u63a5\u8fde\u63a5\u4f60\u7684\u6570\u636e\u5e93\u3001\u67e5\u8be2\u6570\u636e\u3001\u5206\u6790\u7ed3\u6784\u2014\u2014\u8fd9\u5c31\u662f MCP \u4e3a .NET \u5f00\u53d1\u8005\u5e26\u6765\u7684\u5168\u65b0\u53ef\u80fd\u3002 \u4e00\u3001MCP \u662f\u4ec0\u4e48？\u4e3a\u4ec0\u4e48 .NET \u5f00\u53d1\u8005\u5e94\u8be5\u5173\u6ce8？ 1.1 MCP \u534f\u8bae\u7b80\u4ecb MCP（Model Context Protocol，\u6a21\u578b\u4e0a\u4e0b\u6587\u534f\u8bae） \u662f\u7531 Anthropic \u63a8\u51fa\u7684\u5f00\u6e90\u6807\u51c6\u534f\u8bae，\u65e8\u5728\u4e3a\u5927\u8bed\u8a00\u6a21\u578b（\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/74436.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-02-09T12:05:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260209120529-6989cd8991d90.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/74436.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/74436.html\",\"name\":\".NET \u5f00\u53d1 MCP \u670d\u52a1\u5668\u5b8c\u5168\u6307\u5357\uff1a\u6253\u9020\u667a\u80fd\u6570\u636e\u5e93\u67e5\u8be2\u52a9\u624b - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-02-09T12:05:31+00:00\",\"dateModified\":\"2026-02-09T12:05:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/74436.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/74436.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/74436.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\".NET \u5f00\u53d1 MCP \u670d\u52a1\u5668\u5b8c\u5168\u6307\u5357\uff1a\u6253\u9020\u667a\u80fd\u6570\u636e\u5e93\u67e5\u8be2\u52a9\u624b\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":".NET \u5f00\u53d1 MCP \u670d\u52a1\u5668\u5b8c\u5168\u6307\u5357\uff1a\u6253\u9020\u667a\u80fd\u6570\u636e\u5e93\u67e5\u8be2\u52a9\u624b - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/74436.html","og_locale":"zh_CN","og_type":"article","og_title":".NET \u5f00\u53d1 MCP \u670d\u52a1\u5668\u5b8c\u5168\u6307\u5357\uff1a\u6253\u9020\u667a\u80fd\u6570\u636e\u5e93\u67e5\u8be2\u52a9\u624b - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u5f53 AI \u52a9\u624b\u4e0d\u518d\u53ea\u662f\u751f\u6210 SQL \u8bed\u53e5，\u800c\u662f\u80fd\u591f\u76f4\u63a5\u8fde\u63a5\u4f60\u7684\u6570\u636e\u5e93\u3001\u67e5\u8be2\u6570\u636e\u3001\u5206\u6790\u7ed3\u6784\u2014\u2014\u8fd9\u5c31\u662f MCP \u4e3a .NET \u5f00\u53d1\u8005\u5e26\u6765\u7684\u5168\u65b0\u53ef\u80fd\u3002 \u4e00\u3001MCP \u662f\u4ec0\u4e48？\u4e3a\u4ec0\u4e48 .NET \u5f00\u53d1\u8005\u5e94\u8be5\u5173\u6ce8？ 1.1 MCP \u534f\u8bae\u7b80\u4ecb MCP（Model Context Protocol，\u6a21\u578b\u4e0a\u4e0b\u6587\u534f\u8bae） \u662f\u7531 Anthropic \u63a8\u51fa\u7684\u5f00\u6e90\u6807\u51c6\u534f\u8bae，\u65e8\u5728\u4e3a\u5927\u8bed\u8a00\u6a21\u578b（","og_url":"https:\/\/www.wsisp.com\/helps\/74436.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-02-09T12:05:31+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260209120529-6989cd8991d90.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"15 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/74436.html","url":"https:\/\/www.wsisp.com\/helps\/74436.html","name":".NET \u5f00\u53d1 MCP \u670d\u52a1\u5668\u5b8c\u5168\u6307\u5357\uff1a\u6253\u9020\u667a\u80fd\u6570\u636e\u5e93\u67e5\u8be2\u52a9\u624b - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-02-09T12:05:31+00:00","dateModified":"2026-02-09T12:05:31+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/74436.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/74436.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/74436.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":".NET \u5f00\u53d1 MCP \u670d\u52a1\u5668\u5b8c\u5168\u6307\u5357\uff1a\u6253\u9020\u667a\u80fd\u6570\u636e\u5e93\u67e5\u8be2\u52a9\u624b"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/74436","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=74436"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/74436\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/74432"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=74436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=74436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=74436"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=74436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}