Skip to main content
Glama
deenesjakoruzh
RichardHan

Microsoft SQL Server MCP Server

by RichardHan
OverviewInspectSchemaRelated ServersScoreDiscussions
Python
Hybrid

Microsoft SQL Server MCP Server

PyPI License: MIT

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

Features

  • 🔍 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

Related MCP server: SQLite MCP Server

Quick Start

Install with Claude Desktop

Add to your claude_desktop_config.json:

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

Configuration

Basic SQL Authentication

MSSQL_SERVER=localhost # Required MSSQL_DATABASE=your_database # Required MSSQL_USER=your_username # Required for SQL auth MSSQL_PASSWORD=your_password # Required for SQL auth

Windows Authentication

MSSQL_SERVER=localhost MSSQL_DATABASE=your_database MSSQL_WINDOWS_AUTH=true # Use Windows credentials

Azure SQL Database

MSSQL_SERVER=your-server.database.windows.net MSSQL_DATABASE=your_database MSSQL_USER=your_username MSSQL_PASSWORD=your_password # Encryption is automatic for Azure

Optional Settings

MSSQL_PORT=1433 # Custom port (default: 1433) MSSQL_ENCRYPT=true # Force encryption

Alternative Installation Methods

Using pip

pip install microsoft_sql_server_mcp

Then in claude_desktop_config.json:

{ "mcpServers": { "mssql": { "command": "python", "args": ["-m", "mssql_mcp_server"], "env": { ... } } } }

Development

git clone https://github.com/RichardHan/mssql_mcp_server.git cd mssql_mcp_server pip install -e .

Security

  • Create a dedicated SQL user with minimal permissions

  • Never use admin/sa accounts

  • Use Windows Authentication when possible

  • Enable encryption for sensitive data

License

MIT

One-click Deploy
A
security – no known vulnerabilities
A
license - permissive license
A
quality - confirmed to work

How are these scores calculated?

Resources

Appeared in Searches

New MCP Servers

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/RichardHan/mssql_mcp_server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server