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
Astro MCP
A modular server providing unified access to multiple astronomical datasets, including astroquery services and DESI data sources.
MySQL
Interact with and manage MySQL databases. Requires connection details configured via environment variables.
Uniswap Pools MCP
Query Uniswap pools and pairs by token address for structured data.
CData MySQL MCP Server
A read-only MCP server for MySQL, enabling LLMs to query live data using the CData JDBC Driver.
Gremlin
Interact with any Gremlin-compatible graph database using natural language, with support for schema discovery, complex queries, and data import/export.
AIND Metadata
Access and interact with Allen Institute for Neural Dynamics (AIND) metadata directly within your IDE.
STRING-MCP
Interact with the STRING protein-protein interaction database API.
Redis
A server for interacting with Redis databases.
MySQL MCP Server
Enables secure interaction with MySQL databases, allowing AI assistants to list tables, read data, and execute SQL queries through a controlled interface.
Database Tools for Claude AI
Allows Claude AI to interact directly with MySQL databases.