Py MCP Mssql MCP Server

A Model Context Protocol server implementation in Python that provides access to Microsoft SQL Server databases. This server enables Language Models

Local serverstdioPython

What is the Py MCP Mssql MCP Server?

A Model Context Protocol server implementation in Python that provides access to Microsoft SQL Server databases. This server enables Language Models to inspect

Configuration

  • Python 3.x * Required Python packages: * pyodbc * pydantic * python-dotenv * mcp-server * ODBC Driver 17 for SQL Server

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

{
  "mcpServers": {
    "mssql": {
      "command": "python",
      "args": [
        "server.py"
      ],
      "env": {
        "MSSQL_SERVER": "your_server",
        "MSSQL_DATABASE": "your_database",
        "MSSQL_USER": "your_username",
        "MSSQL_PASSWORD": "YOUR_MSSQL_PASSWORD",
        "MSSQL_DRIVER": "{ODBC Driver 17 for SQL Server}"
      }
    }
  }
}

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

Configuration

  • Python 3.x * Required Python packages: * pyodbc * pydantic * python-dotenv * mcp-server * ODBC Driver 17 for SQL Server
VariableDescriptionRequired
MSSQL_SERVERDeclared in the maintainer’s client configuration.Check documentation
MSSQL_DATABASEDeclared in the maintainer’s client configuration.Check documentation
MSSQL_USERDeclared in the maintainer’s client configuration.Check documentation
MSSQL_PASSWORDDeclared in the maintainer’s client configuration.Check documentation
MSSQL_DRIVERDeclared in the maintainer’s client configuration.Check documentation

Frequently asked questions

A Model Context Protocol server implementation in Python that provides access to Microsoft SQL Server databases. This server enables Language Models to inspect Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.