Mssql MCP Server

Enables secure interaction with Microsoft SQL Server databases via a controlled interface for AI assistants.

Local serverstdioPython★ 380

What is the Mssql MCP Server?

Enables secure interaction with Microsoft SQL Server databases via a controlled interface for AI assistants.

What it actually does

A Model Context Protocol (MCP) server for secure SQL Server database access through Claude Desktop.

  • 🔍 List database tables
  • 📊 Execute SQL queries (SELECT, INSERT, UPDATE, DELETE)
  • 🔐 Multiple authentication methods (SQL, Windows, Azure AD)
  • 🏢 LocalDB and Azure SQL support
  • 🔌 Custom port configuration

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 Mssql MCP Server

{
  "mcpServers": {
    "mssql": {
      "command": "uvx",
      "args": [
        "microsoft_sql_server_mcp"
      ],
      "env": {
        "MSSQL_SERVER": "localhost",
        "MSSQL_DATABASE": "your_database",
        "MSSQL_USER": "your_username",
        "MSSQL_PASSWORD": "YOUR_MSSQL_PASSWORD"
      }
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

VariableDescriptionRequired
MSSQL_SERVERDeclared in the maintainer’s client configuration.Yes
MSSQL_DATABASEDeclared in the maintainer’s client configuration.Yes
MSSQL_USERDeclared in the maintainer’s client configuration.Yes
MSSQL_PASSWORDDeclared in the maintainer’s client configuration.Yes

Example prompts to try

  • “Use Mssql to Development.”

Frequently asked questions

Mssql uses environment variables for credentials and promotes secure database access through restricted user permissions, query logging, and adherence to the principle of least privilege.