Advertise
MCP.so
Sign In

MCP MSSQL Server

@blueshiftlabs-ai

Repository

Basic information

Category

Databases

Transports

stdio

Author

blueshiftlabs-ai

About MCP MSSQL Server

MCP (Model Context Protocol) server for Microsoft SQL Server integration built with NestJS

#mcp#mssql#database-integration

MCP MSSQL Server config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

MCP MSSQL Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

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

Frequently asked questions

1

What authentication methods are supported?

Both Windows (NTLM) authentication and SQL Server authentication are supported, configured via environment variables.

2

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`.

3

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`).

4

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`.

5

Does the server expose any REST endpoints?

No, all functionality is exposed exclusively through MCP tools; there are no REST endpoints.

Comments

More Databases MCP servers

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Elasticsearch MCP Server

elastic

685

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397
Advertise