MS SQL Server MCP Server v2.1.1

🚀 Model Context Protocol (MCP) server for Microsoft SQL Server - compatible with Claude Desktop, Cursor, Windsurf and VS Code.

🚀 Quick Start

1. Install

npm install -g mssql-mcp

2. Configure IDE

Claude Desktop (claude_desktop_config.json):

{
  "mcpServers": {
    "mssql": {
      "command": "npx",
      "args": ["-y", "mssql-mcp@latest"],
      "env": {
        "DB_SERVER": "your-server.com",
        "DB_DATABASE": "your-database",
        "DB_USER": "your-username",
        "DB_PASSWORD": "your-password",
        "DB_ENCRYPT": "true",
        "DB_TRUST_SERVER_CERTIFICATE": "true"
      }
    }
  }
}

Cursor/Windsurf/VS Code (.vscode/mcp.json):

{
  "servers": {
    "mssql": {
      "command": "npx",
      "args": ["-y", "mssql-mcp@latest"],
      "env": {
        "DB_SERVER": "your-server.com",
        "DB_DATABASE": "your-database",
        "DB_USER": "your-username",
        "DB_PASSWORD": "your-password",
        "DB_ENCRYPT": "true",
        "DB_TRUST_SERVER_CERTIFICATE": "true"
      }
    }
  }
}

Replace with your actual database credentials.

🛠️ Available Tools

🔧 Environment Variables

Azure SQL Configuration

For Azure SQL Database, use these settings:

{
  "DB_ENCRYPT": "true",
  "DB_TRUST_SERVER_CERTIFICATE": "false"
}

Local SQL Server (Self-signed cert)

For local development with self-signed certificates:

{
  "DB_ENCRYPT": "true",
  "DB_TRUST_SERVER_CERTIFICATE": "true"
}

🏆 Features

• ✅ MCP SDK 1.25.1: Latest Model Context Protocol SDK

• ✅ Azure SQL Compatible: TLS encryption enabled by default

• ✅ Complete SQL Support: All database operations

• ✅ Parameterized Queries: SQL injection protection

• ✅ Connection Pooling: Efficient resource management

• ✅ Performance Monitoring: Execution time tracking

📋 Usage Examples

Connect to Database

Use the connect_database tool to establish a connection.

Execute a Query

SELECT TOP 10 * FROM Customers WHERE Country = @country
-- With parameters: { "country": "USA" }

Get Table Schema

Use describe_table with tableName: "Customers" to see column details.

🔍 Troubleshooting

❌ Connection failed

• Verify all required environment variables are set

• Check server accessibility and credentials

• Ensure network connectivity to SQL Server

❌ SSL/Certificate errors

• For Azure SQL: Set DB_ENCRYPT=true (default)

• For self-signed certs: Set DB_TRUST_SERVER_CERTIFICATE=true

• For local dev without encryption: Set DB_ENCRYPT=false

📋 Version History

v2.1.1 - Latest

• ✅ Added DB_ENCRYPT environment variable (Issue #1)

• ✅ Azure SQL Database compatibility improved

• ✅ Encryption enabled by default (DB_ENCRYPT=true)

• ✅ Fixed DB_TRUST_SERVER_CERTIFICATE default to false

v2.1.0

• ✅ Updated to MCP SDK 1.25.1

• ✅ Migrated to registerTool() / registerResource() API

• ✅ Added tool titles for better UI display

v2.0.3

• ✅ Documentation improvements

📄 License

MIT License

🆘 Support

• Issues: GitHub Issues

• Repository: BYMCS/mssql-mcp

🎉 v2.1.1: Azure SQL compatibility with DB_ENCRYPT support