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未申請リスティング
このMCPサーバーはあなたのものですか?
このリスティングは公開情報から自動的にインデックスされました。申請することで、ページの編集、互換性の設定、成長ツールのアンロックができます。2分以内に完了します。
このサーバーを申請するツール(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.