MS SQL Server MCP Server

Name: MS SQL Server MCP Server
Author: bymcs

@bymcs

Repository

About MS SQL Server MCP Server

No overview available yet

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mssql": {
      "command": "npx",
      "args": [
        "-y",
        "mssql-mcp@latest"
      ],
      "env": {
        "DB_SERVER": "your-server.com",
        "DB_DATABASE": "your-database",
        "DB_USER": "your-username",
        "DB_PASSWORD": "your-password",
        "DB_PORT": "1433",
        "DB_TRUST_SERVER_CERTIFICATE": "true"
      }
    }
  }
}

Tools

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 MS SQL Server MCP Server?

A Model Context Protocol (MCP) server for Microsoft SQL Server, compatible with Claude Desktop, Cursor, Windsurf, and VS Code. It provides a set of tools for AI assistants to connect to and interact with SQL Server databases, execute queries, explore schemas, and manage connections.

How to use MS SQL Server MCP Server?

Install globally via npm install -g mssql-mcp. Configure an MCP server entry in your IDE’s config file (e.g., claude_desktop_config.json or .vscode/mcp.json) with environment variables for the database connection. The server runs in stdio mode by default for local IDEs, or can be switched to http mode for remote deployments.

Key features of MS SQL Server MCP Server

Connection management: connect, disconnect, and check status.
Execute arbitrary SQL queries (mutation‑capable).
List schema objects (tables, views, procedures, functions) with pagination.
Describe table columns with full definitions.
Read table rows with pagination, projection, and safe WHERE clauses.
Execute stored procedures.
List all databases on the instance.
Response format selectable between JSON and markdown.

Use cases of MS SQL Server MCP Server

Allow Claude or other MCP clients to explore and query a SQL Server database.
Enable AI assistants to retrieve table schemas and row data for context.
Execute stored procedures from within an AI‑powered IDE.
Perform database debugging and ad‑hoc SQL queries via natural language.
Integrate SQL Server data into automated workflows in VS Code, Cursor, or Windsurf.

FAQ from MS SQL Server MCP Server

What are the runtime dependencies?

Node.js (via npm) and a network‑accessible SQL Server instance. The server uses the @modelcontextprotocol/sdk pinned to 1.28.0.

How are credentials configured and secured?

All connection settings (server, database, user, password) are read only from environment variables — never from tool parameters. The server enforces that credentials cannot be overridden at runtime.

What transport modes are available?

Two modes: stdio (default) for local IDE integration (Claude Desktop, Cursor, VS Code) and http for remote or hosted deployments. The HTTP binding can be customized with environment variables.

Is the server completely read‑only?

No. Tools like mssql_run_sql_query and mssql_execute_stored_procedure are explicitly labeled as non‑read‑only and can mutate data. Read‑only tools are marked with a ✅ badge in the tool catalog.

What security measures are built in?

Identifier validation, parameterized queries, HTTP origin validation (localhost by default), and a recommendation to use a least‑privilege SQL login. The server never embeds user‑supplied values directly into SQL strings.

Comments

More Databases MCP servers

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245