The Microsoft SQL Server MCP Server provides a secure interface to interact with SQL Server databases. With this server, you can:
Execute SQL queries against the configured database with proper error handling
List available SQL Server tables through appropriate system queries
Read table contents via SELECT statements
Secure database access through environment variables
Track operations with comprehensive logging
Benefit from automatic installation of required system dependencies
All operations are subject to the database user's permissions.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Microsoft SQL Server MCP Servershow me the top 10 customers by total purchases"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Microsoft SQL Server MCP Server
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 authWindows Authentication
MSSQL_SERVER=localhost
MSSQL_DATABASE=your_database
MSSQL_WINDOWS_AUTH=true # Use Windows credentialsAzure 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 AzureOptional Settings
MSSQL_PORT=1433 # Custom port (default: 1433)
MSSQL_ENCRYPT=true # Force encryptionAlternative Installation Methods
Using pip
pip install microsoft_sql_server_mcpThen 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