mssql-mcp

An MCP (Model Context Protocol) server for Microsoft SQL Server databases. Enables AI assistants like Claude to interact with SQL Server through a standardized protocol.

Features

Query Execution: Run SELECT queries with safety limits
Schema Discovery: List tables, views, and column information
CRUD Operations: Read, insert, update, and delete rows
Stored Procedures: Execute stored procedures with parameters
Export: Export query results to JSON or CSV
Safety Controls: Command blocklist, read-only mode, row limits, query timeouts

Installation

pip install mssql-mcp

Or install from source:

git clone https://github.com/yourusername/mssql-mcp.git cd mssql-mcp pip install -e ".[dev]"

Configuration

Copy .env.sample to .env and configure your settings:

cp .env.sample .env

Required environment variables:

Variable	Description
`MSSQL_HOST`	SQL Server hostname
`MSSQL_USER`	Database username
`MSSQL_PASSWORD`	Database password
`MSSQL_DATABASE`	Database name

Optional settings:

Variable	Default	Description
`MSSQL_PORT`	`1433`	Server port
`MSSQL_READ_ONLY`	`false`	Block write operations
`MSSQL_MAX_ROWS`	`1000`	Query row limit
`MSSQL_QUERY_TIMEOUT`	`60`	Query timeout (seconds)

Usage

With Claude Code

Add to your Claude Code MCP configuration:

{ "mcpServers": { "mssql": { "command": "mssql-mcp", "env": { "MSSQL_HOST": "localhost", "MSSQL_USER": "sa", "MSSQL_PASSWORD": "your_password", "MSSQL_DATABASE": "your_database" } } } }

Standalone

# Run with stdio transport (default) mssql-mcp # Run with HTTP transport mssql-mcp --http

Available Tools

Tool	Description
`execute_query`	Run a SELECT query
`validate_query`	Check if a query is safe to execute
`list_tables`	List tables and views
`describe_table`	Get column information for a table
`read_rows`	Read rows by ID or filter
`insert_row`	Insert a new row
`update_row`	Update an existing row
`delete_row`	Delete a row
`call_stored_proc`	Execute a stored procedure
`export_to_json`	Export query results to JSON
`export_to_csv`	Export query results to CSV