MSSQL MCP Server by c0h1b4
c0h1b4LABSCO SUMMARY
Small, and it gets the encoding question right.
Most database servers assume UTF-8 and leave you stuck when an older SQL Server instance is not; exposing the character set as a setting is what makes this one work against legacy databases. Everything else is deliberately plain — six variables in a config file and it connects.
What it is
A Python server that connects an MCP client to Microsoft SQL Server. Connection details are passed as environment variables from the client config, and setup instructions are given for Cline.
What you get
- A connection to a Microsoft SQL Server instance from your MCP client
- Host, port, user, password and database all set in the client config
- An explicit character set setting, so legacy encodings such as CP936 work as well as UTF-8
- Runs from a checkout with
uv syncanduv run mssql-mcp-server
Requirements
uv and a checkout of the repository. Six environment variables in the client config: MSSQL_SERVER, MSSQL_PORT (1433 for a default instance), MSSQL_USER, MSSQL_PASSWORD, MSSQL_DATABASE and MSSQL_CHARSET. The charset value is case-sensitive — a wrong case there is the likely cause of a connection that will not open. Give it a database login scoped to what the assistant should see. Version 0.1.0.
Setup effort
Build from source — git clone https://github.com/leopeng1995/mssql-mcp-server.git
USE CASES
01
Asking questions of a SQL Server database in plain language
Point the client at the instance and query it from the conversation.
02
Working with a legacy database that is not UTF-8
Set the character set explicitly so text comes back readable instead of mangled.
03
Keeping the assistant to one database
Scope the login and name a single database in the config rather than handing over the whole server.
BEFORE YOU INSTALL
What to know first
Requires
- MSSQL_PASSWORD in your environment
- MSSQL_USER in your environment
Where it runs
The documented client runs the server on your machine.
INSTALLATION
Connect your client
This one is built from source rather than installed with a single command.
Server setup
TERMINAL
git clone https://github.com/leopeng1995/mssql-mcp-server.git
cd mssql-mcp-server
uv sync
uv run mssql-mcp-serverMCP Clients
Cline
CLINE · JSON
{
"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": "<YOUR_MSSQL_USER>",
"MSSQL_PASSWORD": "<YOUR_MSSQL_PASSWORD>",
"MSSQL_DATABASE": "<YOUR_MSSQL_DATABASE>",
"MSSQL_CHARSET": "UTF-8"
},
"disabled": false,
"autoApprove": []
}
}
}H:/workspaces/leopeng1995/mssql-mcp-server is the author's own folder; yours is the absolute path of your clone. The env values are your SQL Server host, port, login, password and database. MSSQL_CHARSET is case-sensitive: UTF-8, or CP936 for a legacy Chinese-encoded database.
