Description

This MCP server implementation, developed by Dana K. Williams, provides secure interaction with Microsoft SQL Server databases. Built with Python and leveraging libraries like mcp and pymssql, it offers a bridge between AI assistants and SQL Server data. The implementation focuses on security, with detailed guidance on creating restricted SQL logins, implementing row-level security, and following best practices for monitoring and auditing. It's particularly useful for organizations needing to integrate SQL Server data into AI workflows while maintaining strict security controls, enabling tasks like data analysis, reporting, and database management through AI interfaces while ensuring data protection and compliance.

🔬 Playground

Try Microsoft SQL Server (MSSQL) live in the browser with security context.
⚪
Unverified
No automated security scan has been run on this server yet.

Installation 

git clone https://github.com/richardhan/mssql_mcp_server

Claude Desktop Configuration

Add this configuration to your Claude Desktop config file to enable this MCP server:

Config file location: ~/Library/Application Support/Claude/claude_desktop_config.json

Config file location: %APPDATA%\Claude\claude_desktop_config.json

Config file location: ~/.config/Claude/claude_desktop_config.json

claude_desktop_config.json 
{
  "mcpServers": {
    "microsoft-sql-server-mssql": {
      "command": "node",
      "args": [
        "path/to/server.js"
      ]
    }
  }
}

Community Reviews

Authenticated reviews from GitHub users. No anonymous submissions. Your experience helps others choose wisely.

—
★★★★★
0 reviews
5★
0
4★
0
3★
0
2★
0
1★
0

No reviews yet. Be the first to share your experience.