Mssql MCP Server
未认领Enterprise MCP server for SQL Server with 20 tools for schema discovery, data operations, and administration.
01 / 选择客户端
03 / 添加配置
claude mcp add --transport stdio 'connorbritain-mssql-mcp-server' -- 'npx' '-y' '@connorbritain/mssql-mcp-server@latest'04 / 在客户端中确认
打开客户端的 MCP 设置，确认服务器已连接并列出工具。复制配置不代表连接成功。
更多Databases服务器
浏览完整目录安全概况
已认领和已认证的服务器每周接受一次静态扫描，显示代码能触及的范围（外部服务、环境变量、shell 命令、代理配置目录）以及带有已知公告的依赖。认领此列表即可获得。 安全概况的工作原理
20 个工具中显示 20 个
文档中列出的工具 (20)
内容来自项目文档。服务器握手不会验证每个工具的说明或行为。
create_index
Create indexes on existing tables.
create_table
Create tables with column definitions.
delete_data
Preview affected rows, require confirmation.
describe_table
Column definitions, types, nullability, keys.
drop_table
Drop tables (requires confirmation).
explain_query
Execution plan analysis via SHOWPLAN.
insert_data
Parameterized inserts (single or batch).
inspect_dependencies
Full dependency analysis (views, procs, functions, triggers referencing an object).
inspect_relationships
FK mappings in both directions.
list_databases
List databases on server-level environments.
list_environments
Show configured environments and their policies.
list_scripts
Show available pre-approved SQL scripts.
list_table
List all tables in a database with optional filtering.
profile_table
Column stats (null %, cardinality, min/max/avg/median/p90) with optional sample rows.
read_data
Safe SELECT with automatic row limits.
run_script
Execute named scripts with parameters and governance controls.
search_schema
Wildcard/fuzzy search across tables and columns with pagination.
test_connection
Verify connectivity and latency.
update_data
Preview affected rows, require confirmation.
validate_environment_config
Check environment configuration for errors.