Mssql MCP
未认领A Model Context Protocol (MCP) server for Microsoft SQL Server, built in C#/.NET 10
01 / 选择客户端
03 / 添加配置
claude mcp add --transport stdio 'codegiveness-mssql-mcp' -- 'npx' '-y' '@codegiveness/mssql-mcp' '--version'04 / 在客户端中确认
打开客户端的 MCP 设置，确认服务器已连接并列出工具。复制配置不代表连接成功。
更多Databases服务器
浏览完整目录安全概况
已认领和已认证的服务器每周接受一次静态扫描，显示代码能触及的范围（外部服务、环境变量、shell 命令、代理配置目录）以及带有已知公告的依赖。认领此列表即可获得。 安全概况的工作原理
9 个工具中显示 9 个
文档中列出的工具 (9)
内容来自项目文档。服务器握手不会验证每个工具的说明或行为。
analyze_db_health
Summary health check: size, VLFs, fragmentation, stats staleness, blocking.
analyze_indexes
Missing-index analysis from sys.dmdbmissingindex DMVs (workload-wide or per-query).
execute_sql
Execute a T-SQL batch. SELECT in Restricted; DML/DDL in Unrestricted.
explain_query
Show the execution plan summary (or raw XML) without executing the query.
get_object_details
Return columns, parameters, indexes, and triggers for a specific object.
get_top_queries
Top queries by CPU/duration/reads from sys.dmexecquerystats.
list_databases
List all databases with an iscurrent flag (system DBs excluded).
list_objects
List tables/views/procedures/functions with schema, type, and limit filters (default 1000).
list_schemas
List schemas in the current or specified database.