Microsoft SQL Server
A Model Context Protocol (MCP) server for connecting to and querying Microsoft SQL Server databases.
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.
Related Servers
ERDDAP MCP Server
Access ERDDAP servers worldwide to search, discover, and retrieve oceanographic and environmental scientific datasets.
MotherDuck
Query and analyze data with MotherDuck and local DuckDB
FHIR MCP Server by CData
A read-only MCP server for FHIR, enabling LLMs to query live FHIR data. Requires the CData JDBC Driver for FHIR.
PostgreSQL MCP Server
Execute queries directly on a PostgreSQL database.
MySQL Server
A server for accessing and managing MySQL databases.
Powerdrill
An MCP server that provides tools to interact with Powerdrill datasets, enabling smart AI data analysis and insights.
Unofficial ChEMBL MCP Server
Access the ChEMBL chemical database for drug discovery, chemical informatics, and bioactivity research using specialized tools via its REST API.
Qixin API Service
Access comprehensive enterprise data from the Qixin Open Platform APIs.
FXMacroData
Real-time forex macroeconomic API for all major currency pairs sourced from central bank announcements.
Mina Archive Node API
Access Mina blockchain data, including events, actions, and network state, through the Mina Archive Node API.