MSSQL Database Manager

🚀 MSSQL MCP Server

The MSSQL MCP Server is a server based on the Model Context Protocol (MCP), designed to enable secure and structured interactions with Microsoft SQL Server (MSSQL) databases. It allows AI assistants to perform the following operations:

• List available tables
• View table contents
• Execute SQL queries with controlled access

This ensures safer database exploration, strict permission control, and logging of database interactions.

✨ Features

• Secure access to the MSSQL database through environment variables.
• Controlled query execution with error handling.
• Table catalog and data retrieval capabilities.
• Comprehensive logging for monitoring queries and operations.

📦 Installation

pip install mssql-mcp-server

📚 Configuration

Configure database access by setting the following environment variables:

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 Examples

Basic Usage

Integration with Claude Desktop

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

{
  "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"
      }
    }
  }
}

Advanced Usage

Running as an Independent Server

# Install dependencies
pip install -r requirements.txt

# Run 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

# Create 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 an MSSQL user with minimal privileges.
• Never use root credentials or an account with full administrative privileges.
• Restrict database access to only necessary operations.
• Enable logging and monitoring for security auditing.
• Regularly review permissions to ensure compliance with the principle of least privilege.

🔐 Security Best Practices

To achieve a secure configuration:

1. Create an MSSQL user with restricted permissions.
2. Avoid hard - coding credentials—use environment variables for management.
3. Restrict access, granting only necessary table and operation permissions.
4. Enable SQL Server logging and monitoring.
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 licensed under the MIT License. For more details, see 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 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 concerns, contact here.