mssql_mcp

# Microsoft SQL Server MCP Server A Model Context Protocol (MCP) server that enables secure interaction with Microsoft SQL Server databases. This server allows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured. ## Features - List available SQL Server tables as resources - Read table contents - Execute SQL queries with proper error handling - Secure database access through environment variables - Comprehensive logging - Automatic system dependency installation ## Installation The package will automatically install required system dependencies (like FreeTDS) when installed through MCP: ```bash pip install mssql-mcp ``` ## Configuration Set the following environment variables: ```bash MSSQL_SERVER=localhost MSSQL_USER=your_username MSSQL_PASSWORD=your_password MSSQL_DATABASE=your_database ``` ## Usage ### With Claude Desktop Add this to your `claude_desktop_config.json`: ```json { "mcpServers": { "mssql": { "command": "uv", "args": [ "--directory", "path/to/mssql_mcp", "run", "mssql_mcp" ], "env": { "MSSQL_SERVER": "localhost", "MSSQL_USER": "your_username", "MSSQL_PASSWORD": "your_password", "MSSQL_DATABASE": "your_database" } } } } ``` ### As a standalone server ```bash # Install dependencies pip install -r requirements.txt # Run the server python -m mssql_mcp ``` ## Development ```bash # Clone the repository git clone https://github.com/RichardHan/mssql_mcp.git cd mssql_mcp # Create virtual environment python -m venv venv source venv/bin/activate # or `venv\Scripts\activate` on Windows # Install development dependencies pip install -r requirements-dev.txt # Run tests pytest ``` ## Security Considerations - Never commit environment variables or credentials - Use a database user with minimal required permissions - Consider imp…