mssql-mcp-server

vpro1032/mssql-mcp-server

3.2

If you are the rightful owner of mssql-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

An enterprise-grade Model Context Protocol (MCP) server for Microsoft SQL Server, enabling secure interaction with MSSQL databases.

Tools

Functions exposed to the LLM to take actions

mssql_query

Execute SELECT queries with safety checks.

mssql_list_databases

List all accessible databases.

mssql_list_tables

List tables in a specific database/schema.

mssql_describe_table

Get detailed schema information for a table.

mssql_pool_stats

Get connection pool statistics for monitoring.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources