Mssqlclient MCP Server
未认领A Microsoft SQL Server client implementing the Model Context Protocol (MCP). This server provides SQL query capabilities through a simple MCP interface.
安装
docker run -d --name mssql-mcp -e "MSSQL_CONNECTIONSTRING=Server=your_server;Database=your_db;User Id=your_user;Password=your_password;TrustServerCertificate=True;" mssqlclient-mcp-server:latest更多Databases服务器
浏览完整目录安全概况
已认领和已认证的服务器每周接受一次静态扫描，显示代码能触及的范围（外部服务、环境变量、shell 命令、代理配置目录）以及带有已知公告的依赖。认领此列表即可获得。 安全概况的工作原理
25 个工具中显示 25 个
文档中列出的工具 (25)
内容来自项目文档。服务器握手不会验证每个工具的说明或行为。
execute_query
Executes a SQL query on the connected SQL Server database.
execute_query_in_database
Executes a SQL query in a specific database.
execute_stored_procedure
Executes a stored procedure with automatic parameter type conversion.
execute_stored_procedure_in_database
Executes a stored procedure in a specific database with automatic parameter type conversion.
get_command_timeout
Returns current timeout configuration settings.
get_session_results
Get results from a completed or running query/stored procedure session.
get_session_status
Check the status of a running query or stored procedure session.
get_stored_procedure_definition
Gets the SQL definition of a stored procedure.
get_stored_procedure_definition_in_database
Gets the SQL definition of a stored procedure from a specific database.
get_stored_procedure_parameters
Gets parameter information for a stored procedure in table or JSON Schema format.
get_table_schema
Gets the schema of a table from the connected SQL Server database.
get_table_schema_in_database
Gets the schema of a table from a specific database.
list_databases
Lists all databases on the SQL Server instance.
list_sessions
List all query and stored procedure sessions.
list_stored_procedures
Lists all stored procedures in the current database with detailed information.
list_stored_procedures_in_database
Lists all stored procedures in a specific database.
list_tables
Lists all tables in the connected SQL Server database with schema and row count information.
list_tables_in_database
Lists all tables in a specific database.
server_capabilities
Returns detailed information about the capabilities and features of the connected SQL Server instance.
set_command_timeout
Updates the default command timeout for all new operations.
start_query
Start a SQL query in the background on the connected database. Returns a session ID to check progress. Best for long-running queries.
start_query_in_database
Start a SQL query in the background for a specific database. Returns a session ID to check progress. Best for long-running queries (server mode).
start_stored_procedure
Start a stored procedure execution in the background. Returns a session ID to check progress. Best for long-running procedures.
start_stored_procedure_in_database
Start a stored procedure execution in the background for a specific database. Returns a session ID to check progress. Best for long-running procedures (server mode).
stop_session
Stop a running query or stored procedure session.