Mssql MCP Server

🚀 MSSQL MCP Server for Microsoft SQL Server

The MSSQL MCP Server, based on the Model Context Protocol (MCP), enables secure and structured interactions with Microsoft SQL Server (MSSQL) databases. It allows AI assistants to perform operations such as listing available tables, reading table contents, and executing controlled SQL queries, ensuring safer database exploration, strict permission enforcement, and logging of database interactions.

🚀 Quick Start

The MSSQL MCP Server is designed to offer a secure and structured way to interact with Microsoft SQL Server databases. It empowers AI assistants to carry out specific operations while maintaining high - level security and control.

✨ Features

• Secure access to MSSQL databases via environment variables
• Controlled query execution with error handling
• Table catalog and data retrieval
• Comprehensive logging for monitoring queries and operations

📦 Installation

pip install mssql-mcp-server

📚 Documentation

Configuration

Set the following environment variables to configure database access:

MSSQL_DRIVER=mssql_driver
MSSQL_HOST=localhost
MSSQL_USER=your_username
MSSQL_PASSWORD=your_password
MSSQL_DATABASE=your_database
# Optional
TrustServerCertificate=yes
Trusted_Connection=no

Usage

Integration with Claude Desktop

To integrate with Claude Desktop, add the following configuration to claude_desktop_config.json:

{
  "mcpServers": {
    "mssql": {
      "command": "uv",
      "args": [
        "--directory",
        "path/to/mssql_mcp_server",
        "run",
        "mssql_mcp_server"
      ],
      "env": {
        "MSSQL_DRIVER": "mssql_driver",
        "MSSQL_HOST": "localhost",
        "MSSQL_USER": "your_username",
        "MSSQL_PASSWORD": "your_password",
        "MSSQL_DATABASE": "your_database"
      }
    }
  }
}

Run as an independent server

# Install dependencies
pip install -r requirements.txt

# Start the server
python -m mssql_mcp_server

Development

# Clone the repository
git clone https://github.com/yourusername/mssql_mcp_server.git
cd mssql_mcp_server

# Set up a virtual environment
python -m venv venv
source venv/bin/activate  # On Windows: venv\Scripts\activate

# Install development dependencies
pip install -r requirements-dev.txt

# Run tests
pytest

Security Considerations

• Use a dedicated MSSQL user with minimal privileges.
• Never use root credentials or full - administrative accounts.
• Limit database access to only necessary operations.
• Enable logging and monitoring for security audits.
• Regularly review permissions to ensure least - privilege access.

Security Best Practices

To achieve a secure configuration:

1. Create a dedicated MSSQL user with restricted permissions.
2. Avoid hard - coding credentials; use environment variables instead.
3. Grant access only to necessary tables and operations.
4. Enable SQL Server logging and monitoring for auditing.
5. Regularly review database access permissions to prevent unauthorized access.

For detailed instructions, refer to the MSSQL Security Configuration Guide.

⚠️ Important Note

Always follow the principle of least privilege when configuring database access.

📄 License

This project is released under the MIT License. For more details, refer to the LICENSE file.

💪 Contribution

We welcome contributions! To contribute:

1. Fork the repository.
2. Create a feature branch: git checkout -b feature/amazing - feature
3. Commit your changes: git commit -m 'Add amazing feature'
4. Push to the branch: git push origin feature/amazing - feature
5. Open a Pull Request.

Need Help?

For any questions or issues, feel free to open an Issue on GitHub or contact the maintainers.