mssql-mcp-server
About
mssql-mcp-server is a Model Context Protocol (MCP) server for connecting to Microsoft SQL Server. It allows AI assistants to interact with SQL Server databases through the MCP interface.
Details
- Author
- MCP-Mirror
- Downloads
- 289
- Categories
- Database
Jump to
- Model Context Protocol server for Microsoft SQL Server
- Supports custom charset configuration (e.g., UTF-8, CP936)
- Easy setup with uv package manager
- Connects to local or remote SQL Server instances
Clone the repository, run uv sync and uv run mssql-mcp-server from the project directory. Then configure the server in Cline (or another MCP client) using environment variables: MSSQL_SERVER, MSSQL_PORT, MSSQL_USER, MSSQL_PASSWORD, MSSQL_DATABASE, and optionally MSSQL_CHARSET.
mssql-mcp-server
mssql-mcp-server is a Model Context Protocol (MCP) server for connecting to Microsoft SQL Server.
Installation
git clone https://github.com/leopeng1995/mssql-mcp-server.git
cd mssql-mcp-server
uv sync
uv run mssql-mcp-server
Configuration in Cline
{
"mcpServers": {
"mssql-mcp-server": {
"command": "uv",
"args": [
"--directory",
"H:/workspaces/leopeng1995/mssql-mcp-server",
"run",
"mssql-mcp-server"
],
"env": {
"MSSQL_SERVER": "localhost",
"MSSQL_PORT": "1433",
"MSSQL_USER": "username",
"MSSQL_PASSWORD": "password",
"MSSQL_DATABASE": "database",
"MSSQL_CHARSET": "UTF-8" # or CP936 ...
},
"disabled": false,
"autoApprove": []
}
}
}
Note: The MSSQL_CHARSET value is case-sensitive.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
