MCP MSSQL Server
@blueshiftlabs-ai
About MCP MSSQL Server
MCP (Model Context Protocol) server for Microsoft SQL Server integration built with NestJS
Config
No standard config provided
This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.
RepositoryTools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is MCP MSSQL Server?
MCP MSSQL Server is a Model Context Protocol (MCP) server built with NestJS that enables Claude Code and other MCP clients to interact with Microsoft SQL Server databases through standardized tools.
How to use MCP MSSQL Server?
Install the package, create a .env file with database configuration (SQL Server or Windows authentication), then start the server with npm run start:dev. Configure Claude Code to connect to the MCP endpoint at http://localhost:3000/mssql/mcp.
Key features of MCP MSSQL Server
- Full MCP protocol implementation for SQL Server operations
- Supports Windows (NTLM) and SQL Server authentication
- Connection pooling for efficient database management
- Built-in health checks for database connectivity
- Six SQL tools: query, schema, tables, procedures, and more
- Exposed via HTTP and SSE transports
Use cases of MCP MSSQL Server
- Execute parameterized SQL queries through an MCP client
- Retrieve and explore database schema, tables, and column details
- Manage tables with structured descriptions and constraints
- Call stored procedures with input parameters
- Monitor database connectivity with built-in health checks
FAQ from MCP MSSQL Server
What authentication methods are supported?
Both Windows (NTLM) authentication and SQL Server authentication are supported, configured via environment variables.
What MCP tools does the server expose?
It exposes six tools: execute-query, get-schema, list-tables, describe-table, get-table-data, and execute-procedure.
How can I connect Claude Code to this server?
Start the server, then configure Claude Code to use the MCP endpoint at http://localhost:3000/mssql/mcp (or the SSE endpoint at http://localhost:3000/mssql/sse).
What are the available MCP endpoints?
When running on default port 3000, the MCP protocol endpoint is /mssql/mcp, SSE endpoint is /mssql/sse, and health check is /mssql/health.
Does the server expose any REST endpoints?
No, all functionality is exposed exclusively through MCP tools; there are no REST endpoints.
Frequently asked questions
What authentication methods are supported?
Both Windows (NTLM) authentication and SQL Server authentication are supported, configured via environment variables.
What MCP tools does the server expose?
It exposes six tools: `execute-query`, `get-schema`, `list-tables`, `describe-table`, `get-table-data`, and `execute-procedure`.
How can I connect Claude Code to this server?
Start the server, then configure Claude Code to use the MCP endpoint at `http://localhost:3000/mssql/mcp` (or the SSE endpoint at `http://localhost:3000/mssql/sse`).
What are the available MCP endpoints?
When running on default port 3000, the MCP protocol endpoint is `/mssql/mcp`, SSE endpoint is `/mssql/sse`, and health check is `/mssql/health`.
Does the server expose any REST endpoints?
No, all functionality is exposed exclusively through MCP tools; there are no REST endpoints.
Basic information
More Databases MCP servers
MCP MongoDB Server
kiliczshA Model Context Protocol Server for MongoDB
MCP Alchemy
runekaagaardA MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.
Postgres Mcp
crystaldbaPostgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.
Sqlite
modelcontextprotocolModel Context Protocol Servers
mcp_mysql_server
wenb1n-devModel Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
Comments