Mssql MCP Server
未认领Enterprise MCP server for SQL Server with 20 tools for schema discovery, data operations, and administration.
安装
npm install -g @connorbritain/mssql-mcp-server@latest工具（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.