mssql-mcp-server

@MCP-Mirror

Repository

About mssql-mcp-server

Mirror of

#mssql #mcp-server #database-connector

Config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is mssql-mcp-server?

mssql-mcp-server is a Model Context Protocol (MCP) server for connecting to Microsoft SQL Server. It allows AI assistants to interact with SQL Server databases through the MCP interface.

How to use mssql-mcp-server?

Clone the repository, run uv sync and uv run mssql-mcp-server from the project directory. Then configure the server in Cline (or another MCP client) using environment variables: MSSQL_SERVER, MSSQL_PORT, MSSQL_USER, MSSQL_PASSWORD, MSSQL_DATABASE, and optionally MSSQL_CHARSET.

Key features of mssql-mcp-server

Model Context Protocol server for Microsoft SQL Server
Supports custom charset configuration (e.g., UTF-8, CP936)
Easy setup with uv package manager
Connects to local or remote SQL Server instances

Use cases of mssql-mcp-server

Enabling AI assistants to query and interact with SQL Server databases
Automating database operations through natural language interfaces
Integrating SQL Server data into MCP‑based workflows

FAQ from mssql-mcp-server

What is MCP?

The README does not explain MCP; it only states that mssql-mcp-server is an MCP server.

What are the runtime dependencies?

The server requires Python and the uv package manager. After cloning the repo, run uv sync to install dependencies.

How do I configure the connection to SQL Server?

Set the environment variables MSSQL_SERVER, MSSQL_PORT, MSSQL_USER, MSSQL_PASSWORD, MSSQL_DATABASE, and optionally MSSQL_CHARSET in your MCP client configuration (e.g., in Cline’s mcpServers block).

Can I change the character set used by the connection?

Yes, set the MSSQL_CHARSET environment variable (e.g., "UTF-8" or "CP936").

Does it support authentication other than username/password?

The README only shows username/password authentication via environment variables. No other methods are mentioned.

Frequently asked questions

What is MCP?

The README does not explain MCP; it only states that mssql-mcp-server is an MCP server.

What are the runtime dependencies?

The server requires Python and the `uv` package manager. After cloning the repo, run `uv sync` to install dependencies.

How do I configure the connection to SQL Server?

Set the environment variables `MSSQL_SERVER`, `MSSQL_PORT`, `MSSQL_USER`, `MSSQL_PASSWORD`, `MSSQL_DATABASE`, and optionally `MSSQL_CHARSET` in your MCP client configuration (e.g., in Cline’s `mcpServers` block).