Mssql
    Mssql

    Mssql

    A Model Context Protocol (MCP) server for Microsoft SQL Server that enables secure database interactions through a controlled interface. Allows AI assistants to safely list tables, read data, and execute SQL queries while maintaining security and structure.

    4.3

    GitHub Stats

    Stars

    173

    Forks

    51

    Release Date

    7/7/2025

    2 days ago

    Detailed Description

    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

    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

    Star History

    Star History

    Jan 15Mar 11Mar 23Apr 5Apr 15Apr 25May 8May 21Jun 3Jun 14Jul 104590135180
    Powered by MSeeP Analytics

    About the Project

    This app has not been claimed by its owner yet.

    Claim Ownership

    Receive Updates

    Security Updates

    Get notified about trust rating changes

    to receive email notifications.