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

SQL Analyzer

Analyze, lint, and convert SQL dialects using SQLGlot.

Redis MCP Server

An MCP server for interacting with Redis databases, enabling LLMs to access key-value stores.

MemoryMesh

A knowledge graph server for AI models, focusing on text-based RPGs and interactive storytelling.

Unofficial Open Targets

Unofficial server for accessing Open Targets platform data for gene-drug-disease associations research.

DuckDB Knowledge Graph Memory

An MCP memory server that uses a DuckDB backend for persistent knowledge graph storage.

MCP Snowflake Reader

Read-only access to Snowflake databases. Requires Snowflake connection information provided via MCP client configuration.

MCP MariaDB Server

Manage and query MariaDB databases using the Model Context Protocol (MCP), with support for SQL and vector search.

MySQL MCP Server

Provides AI agents with direct access to query, search, and analyze MySQL databases.

Mongo-MCP

An MCP server for interacting with a MongoDB database.

FOCUS DATA MCP Server

Convert natural language into SQL statements with a two-step generation solution to reduce hallucinations and improve trust.