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
Tesouro Direto MCP Server
Provides natural language access to Brazilian treasury bond data from the Tesouro Direto API, allowing users to query market data and bond details.
Tiger MCP
Control Postgres database services running on Tiger Cloud with TimescaleDB and other PostgreSQL extensions.
Loki MCP Server
An MCP server for querying logs from Grafana Loki.
TON BLOCKCHAIN MCP
Interact with the TON blockchain using natural language.
Memento MCP
A scalable knowledge graph memory system for LLMs with semantic retrieval and temporal awareness, using Neo4j as a backend.
Legifrance
Query French legal databases using the Legifrance API.
1C Metadata
Obtain 1C configuration metadata via an external 1C HTTP service.
CData Tableau CRM Analytics Server
A read-only MCP server for querying live Tableau CRM Analytics data using the CData JDBC Driver.
Azure Data Explorer
An MCP server for integrating with Azure Data Explorer, allowing for data querying and management.
PostgreSQL
Provides read-only access to PostgreSQL databases, allowing LLMs to inspect schemas and execute queries.