JexinSam/mssql_mcp_server

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