MCP Sql Server2 MCP Server

MCP server for MS SQL Server database queries

Local serverstdio

What is the MCP Sql Server2 MCP Server?

MCP server for MS SQL Server database queries

The short version

A Model Context Protocol (MCP) server that provides a standardized interface for AI models to interact with MS SQL Server databases. This server implements the MCP specification to enable seamless database operations through a consistent API.

  • Execute SQL queries with parameter support
  • List all tables in the database
  • Describe table schemas
  • Support for both stdio and HTTP transport modes
  • Comprehensive logging system
  • Environment-based configuration

What it needs from you

  • Node.js (version that supports ES modules) - MS SQL Server instance - Access credentials for the database

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

How to install the MCP Sql Server2 MCP Server

{
  "mcpServers": {
    "sql-server2": {
      "command": "npx",
      "args": ["-y", "mcp-mssql-server"]
    }
  }
}

Add to claude_desktop_config.json, then restart Claude Desktop.

Configuration

  • Node.js (version that supports ES modules) - MS SQL Server instance - Access credentials for the database

Frequently asked questions

MCP server for MS SQL Server database queries Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.