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.
관련 서버
KuzuMem-MCP
A distributed memory bank MCP tool that stores memories in a KùzuDB graph database, with repository and branch filtering capabilities.
DROMA MCP Server
Interact with DROMA drug-omics association analysis databases using natural language.
MongoDB Atlas MCP Server
Manage MongoDB Atlas projects, including cluster creation, user management, and network access configuration.
MCP Firebird
An MCP server for Firebird SQL databases, enabling LLMs to securely access, analyze, and manipulate database content.
Odoo Accounting MCP Server
Integrates with Odoo Accounting via XML-RPC, allowing AI tools to query and analyze account journal entries for auditing purposes.
Snowflake Cortex
An experimental MCP server to access Snowflake Cortex insights from your development environment.
Directus MCP Server
An MCP server for Directus CMS, enabling AI clients to interact with the Directus API.
Materials Project MCP
Query the Materials Project database using the mp_api client. Requires an MP_API_KEY environment variable.
Singapore LTA MCP Server
Access real-time transportation data from Singapore's LTA DataMall API, including bus arrivals and traffic conditions.
Database MCP
A single-binary MCP server for MySQL, MariaDB, PostgreSQL, and SQLite