JexinSam/mssql_mcp_server

Controlled access to Microsoft SQL Server

Before you install: a copy-paste command is available · no license recorded · link reachable

View on GitHub ↗Link checked 2026-11-12 · HTTP 200 · opens the vendor's own site

Install & config

Copy the command above
Paste it as one entry under mcpServers in claude_desktop_config.json — local servers take command + args (example: clients)
Restart your client

Install command from the repository

pip install mssql-mcp-server

Parsed from the README we fetched on 2026-11-04; we have not executed it.

This is the install method the repository states, not an MCP client config, so no JSON is generated.

Key names differ by client: Clients & CLI

Source: collected from the abordage/awesome-mcp list · type: MCP server
Harvest history: first seen 2026-11-05 · last seen 2026-11-14 · seen 10× · listed by 10 sources
Score: score 1,003 · 10 sources · mcp
Install: pip install mssql-mcp-server

FAQ (answers come from our records)

How do I install it?

The repository provides this install command: pip install mssql-mcp-server. It comes from the repository itself; we cannot guarantee it runs as-is in your client.

Who is it for?

We filed it under these tags: MCP 服务. The tags come from the entry itself, not a taxonomy we imposed.

Who maintains it?

first catalogued 2026-11-05；last seen 2026-11-14。There is no official certification or quality rating here — we record sources and dates only.

# MSSQL MCP Server

以下摘录自该仓库的 README（片段） · 在 GitHub 读完整 README →

MSSQL MCP Server is a Model Context Protocol (MCP) server that enables secure and structured interaction with Microsoft SQL Server (MSSQL) databases. It allows AI assistants to:
List available tables
Read table contents
Execute SQL queries with controlled access
Built on MCP SDK v2 (2026-07-28 spec) with support for both stdio and Streamable HTTP transports.
## Features
Secure MSSQL Database Access through environment variables
SQL Injection Protection with identifier validation
Read-Only & Write Tools with appropriate MCP annotations
Windows Authentication support via Trusted Connection
Dual Transport — stdio (default) and HTTP
Docker Support with pre-configured ODBC drivers
Comprehensive Logging for monitoring queries and operations
## Installation
bash
pip install mssql-mcp-server
## Configuration
Set the following environment variables to configure database access:
bash
# Required
MSSQLDATABASE=yourdatabase
# Authentication (choose one):
# Option 1: SQL Server Authentication
MSSQLUSER=yourusername
MSSQLPASSWORD=yourpassword
# Option 2: Windows / Kerberos Authentication
TrustedConnection=yes
# Optional
MSSQLHOST=localhost # or use MSSQLSERVER
MSSQLDRIVER=SQL Server # default driver
TrustServerCertificate=no # default: no (set to yes for self-signed certs)
MCPTRANSPORT=stdio # or "streamable-http" for Streamable HTTP
## Available Tools
| Tool | Description | Annotations |
| listtables | List all tables in the database | Read-only, Idempotent |
| querysql | Execute read-only SELECT queries | Read-only, Idempotent |
| executesql | Execute any SQL statement (SELECT, INSERT, UPDATE, DELETE, DDL) | Destructive |
## Usage
### With Claude Desktop
Add this configuration to claudedesktopconfig.json:
json
"mcpServers": {
"mssql": {
"command": "uv",
"args": [
"--directory",
"path/to/mssqlmcpserver",
"run",
"mssqlmcpserver"
],
"env": {
"MSSQLHOST": "localhost",
"MSSQLUSER": "yourusername",
"MSSQLPASSWORD": "yourpassword",
"MSSQLDATABASE": "yourdatabase"
### With Cursor IDE
Add this to your .cursor/mcp.json:
json
"mcpServers": {
"mssql": {
"command": "uv",
"args": [
"--directory",
"path/to/mssqlmcpserver",
"run",
"mssqlmcpserver"
],
"env": {
"MSSQLHOST": "localhost",
"MSSQLUSER": "yourusername",
"MSSQLPASSWORD": "yourpassword",
"MSSQLDATABASE": "yourdatabase"
### With pip install (global)
json
"mcpServers": {
"mssql": {
"command": "mssqlmcpserver",
"env": {
"MSSQLHOST": "localhost",
"MSSQLUSER": "yourusername",
"MSSQLPASSWORD": "yourpassword",
"MSSQLDATABASE": "yourdatabase"
### With Docker
bash
docker build -t mssql-mcp-server .
docker run -e MSSQLHOST=host.docker.internal \
-e MSSQLUSER=yourusername \
-e MSSQLPASSWORD=yourpassword \
-e MSSQLDATABASE=yourdatabase \
mssql-mcp-server
### Running as a Standalone Server
bash
# Install dependencies
pip install -r requirements.txt
# Run the server (stdio)
python -m mssqlmcpserver
# Run with HTTP transport
MCPTRANSPORT=streamable-http python -m mssqlmcpserver
### Development & Testing
bash
# Clone the repository
git clone https://github.com/JexinSam/mssqlmcpserver.git
cd mssqlmcpserver
# Set up a virtual environment
python -m venv venv
source venv/bin/activate # On Windows: venv\Scripts\activate

Listed badge (optional)

Copy this line into the README if you want the listing mark. Optional, and it does not affect being listed.

[![Listed on Anclum](https://anclum.com/badge/listed.svg)](https://anclum.com/en/s/jexinsam-mssql-mcp-server/)

Source: awesome · https://github.com/JexinSam/mssql_mcp_server
Browse by field: MCP servers
Listed by: 10 independent sources
added: today

More like this

open-webui/open-webuiMCP server browsermcp/mcpMCP server hardik-id/azure-resource-graph-mcp-serverMCP server

All 6,229 →

Filed under

MCP servers6,229 entries MCP server6,545 Curated list pick6,618

Every tag opens the full list for that filter. Counts are the live catalogue figures.

Browse all fields →

← Back to index