SQL Server MCP

A read-only MCP (Model Context Protocol) server for SQL Server database introspection. Use with Claude Desktop to let Claude explore and query your SQL Server databases.

Features

List databases, tables, views, stored procedures, and functions
Get object definitions (DDL/source code)
Execute read-only SELECT queries
Search for objects across databases
Read-only by design - all mutation queries are blocked

Installation

# Clone the repo
git clone https://github.com/millelog/sql-server-mcp.git
cd sql-server-mcp

# Install in a virtual environment
python -m venv .venv
source .venv/bin/activate  # On Windows: .venv\Scripts\activate
pip install -e .

Claude Desktop Configuration

Add to your Claude Desktop config file:

Windows: %APPDATA%\Claude\claude_desktop_config.json
macOS: ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "sql-server": {
      "command": "python",
      "args": ["-m", "sql_server_mcp"],
      "cwd": "C:\\path\\to\\sql-server-mcp",
      "env": {
        "MSSQL_HOST": "your-server",
        "MSSQL_USER": "your-username",
        "MSSQL_PASSWORD": "your-password",
        "MSSQL_DATABASE": "master"
      }
    }
  }
}

Restart Claude Desktop after updating the config.

Configuration Options

Variable	Description	Default
`MSSQL_HOST`	SQL Server hostname	`localhost`
`MSSQL_PORT`	SQL Server port	`1433`
`MSSQL_USER`	Username	-
`MSSQL_PASSWORD`	Password	-
`MSSQL_DATABASE`	Default database	`master`
`MSSQL_CONNECTION_STRING`	Full connection string (overrides above)	-
`MAX_ROWS`	Maximum rows returned	`100`
`QUERY_TIMEOUT`	Query timeout (seconds)	`30`
`ALLOWED_DATABASES`	Comma-separated allowlist	-
`BLOCKED_DATABASES`	Comma-separated blocklist	-

Available Tools

Tool	Description
`list_databases`	List all accessible databases
`list_tables`	List tables in a database
`get_table_definition`	Get CREATE TABLE DDL
`get_table_columns`	Get column metadata
`get_table_indexes`	Get index information
`get_table_relationships`	Get foreign key relationships
`list_views`	List views in a database
`get_view_definition`	Get CREATE VIEW DDL
`list_procedures`	List stored procedures
`get_procedure_definition`	Get CREATE PROCEDURE DDL
`get_procedure_parameters`	Get procedure parameters
`list_functions`	List user-defined functions
`get_function_definition`	Get CREATE FUNCTION DDL
`execute_query`	Run read-only SELECT queries
`get_sample_data`	Get sample rows from a table
`search_objects`	Search for objects by name
`search_definitions`	Search within object definitions
`get_schema_overview`	Get database schema summary (object counts, size)

Development

# Run tests
pytest tests/ -v

# Run with coverage
pytest tests/ --cov=src/sql_server_mcp

License

MIT

SQL Server MCP

SQL Server MCP

Features

Installation

Claude Desktop Configuration

Configuration Options

Available Tools

Development

License

Latest Blog Posts

MCP directory API