mssql-mcp-server

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.