Nirmal123K/mssql-mcp

MSSQL MCP Server

A Model Context Protocol (MCP) server that enables AI assistants to interact with both local SQL Server and Azure SQL Database through natural language.

🚀 What Makes This Special?

This MCP server solves a critical limitation of existing solutions by supporting both local SQL Server and Azure SQL Database connections. While the original Azure-Samples implementation only works with Azure SQL Database, this enhanced version enables:

• 🏠 Local Development: Connect to local SQL Server instances using username/password authentication
• ☁️ Azure Cloud: Full Azure SQL Database support with Azure AD authentication
• 🔄 Seamless Switching: Use the same tools for both environments

Quick Example:

You: "Show me all customers from New York"
AI: *securely queries your database and returns results in plain English*

You: "Create a table for storing product reviews"
AI: *generates and executes the appropriate CREATE TABLE statement*

📦 Quick Start

Prerequisites

• Node.js 18+
• SQL Server (local) or Azure SQL Database
• AI Assistant: Claude Desktop or VS Code Agent

Installation

git clone https://github.com/Nirmal123K/mssql-mcp.git
cd mssql-mcp-server
npm install && npm run build

Configuration

Local SQL Server:

export SERVER_NAME="localhost"
export DATABASE_NAME="your_database"
export SQL_USER="your_username"
export SQL_PASSWORD="your_password"
export TRUST_SERVER_CERTIFICATE="true"

Azure SQL Database:

export SERVER_NAME="your-server.database.windows.net"
export DATABASE_NAME="your_database"
# Uses Azure AD authentication (run 'az login' first)

⚙️ AI Assistant Setup

Claude Desktop

Add to claude_desktop_config.json:

Local SQL Server:

{
  "mcpServers": {
    "mssql": {
      "command": "node",
      "args": ["/path/to/mssql-mcp-server/dist/index.js"],
      "env": {
        "SERVER_NAME": "localhost",
        "DATABASE_NAME": "your_database",
        "SQL_USER": "your_username",
        "SQL_PASSWORD": "your_password",
        "TRUST_SERVER_CERTIFICATE": "true"
      }
    }
  }
}

Azure SQL Database:

{
  "mcpServers": {
    "mssql": {
      "command": "node",
      "args": ["/path/to/mssql-mcp-server/dist/index.js"],
      "env": {
        "SERVER_NAME": "your-server.database.windows.net",
        "DATABASE_NAME": "your_database",
        "READONLY": "true"
      }
    }
  }
}

VS Code Agent

Create .vscode/mcp.json with similar configuration using "type": "stdio".

Config Locations:

• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
• Windows: %APPDATA%\Claude\claude_desktop_config.json

📋 Environment Variables

🔄 = Required for local SQL Server, not needed for Azure SQL Database

✅ Verification

# Test the MCP server
echo '{"jsonrpc": "2.0", "id": 1, "method": "tools/list"}' | node dist/index.js

🛠️ Available Tools

Security Features:

• ✅ SQL injection prevention
• ✅ Query validation and sanitization
• ✅ Required WHERE clauses for updates
• ✅ Read-only mode support

📚 Documentation

For detailed information, see our comprehensive guides:

• - Practical examples and real-world scenarios
• - Complex setups and enterprise deployment
• - Performance optimization and security guidance
• - Common issues and solutions
• - Windows, macOS, Linux, and Docker specifics

� Credits and Attribution

Original Work

This project is a fork of the Azure-Samples/SQL-AI-samples repository, specifically building upon the MssqlMcp implementation created by Microsoft and the Azure team.

• Original Repository: Azure-Samples/SQL-AI-samples
• Original Authors: Microsoft Corporation and the Azure team
• Original License: MIT License
• Original Focus: Azure SQL Database with Azure AD authentication

Key Enhancement

This fork extends the original Azure-only MCP server to support local SQL Server databases with username/password authentication, making it accessible for:

• 🏠 Local Development: Connect to local SQL Server instances
• 🏢 On-Premises Deployments: Support enterprise SQL Server installations
• 🔄 Hybrid Environments: Seamlessly switch between local and Azure databases
• 🚀 Broader Accessibility: Remove Azure dependency for local development

What We Added

Acknowledgments

We are deeply grateful to Microsoft and the Azure team for creating the foundational architecture, security implementation, and tool design that made this enhanced version possible.

This enhanced version would not exist without their excellent foundational work.

License: MIT License - see file for details.