MCP.so
Sign In

MS SQL Server MCP Server

@bymcs

Repository

About MS SQL Server MCP Server

No overview available yet

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.

Frequently asked questions

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

Basic information

Category

Databases

License

MIT

Transports

stdio

Author

bymcs

More Databases MCP servers

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

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

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K