How do I connect Mssql MCP Server to Claude?

Run `claude mcp add connorbritain-mssql-mcp-server -- npx -y @connorbritain/mssql-mcp-server@latest` in Claude Code, or add the same command and arguments under mcpServers in Cursor's mcp.json or Claude Desktop's claude_desktop_config.json, then restart the client. The blocks above are ready to paste.

Is Mssql MCP Server free?

The listed licence is MIT. Check the upstream terms for permitted use and commercial requirements; a public repository does not by itself mean the software is free or open source. Connected APIs and hosted services may have separate charges.

What can Mssql MCP Server do?

Mssql MCP Server documents 20 tools to the agent, including create_index, create_table, delete_data. The descriptions above come from project documentation. A live handshake does not test individual tool behavior.

Mssql MCP Server

Unclaimed

by ConnorBritain

Enterprise MCP server for SQL Server with 20 tools for schema discovery, data operations, and administration.

Set up this server

Compare servers My Stack

01 / Choose your client

02 / Before you connect

Authentication is not specified. Check the project instructions before connecting.

Install the runtime required by the project and make it available to your client.

Project instructionsEnvironment variable names (optional)

Use names from the project instructions, separated by commas. Enter names only, never secret values.

03 / Add the configuration

Source: generated from public install instructions

claude mcp add --transport stdio 'connorbritain-mssql-mcp-server' -- 'npx' '-y' '@connorbritain/mssql-mcp-server@latest'

Run in your terminal after replacing any placeholders.

04 / Check it in your client

Open your client’s MCP settings and confirm the server connects and lists its tools. A copied configuration does not confirm a working connection.

aiclaudedatabasedatabase-admindbaddlenterprisellmmcpmodel-context-protocolmssqlnodejssql-servertypescript

Is this your MCP server?

This listing was auto-indexed from the public record. Claim it to edit the page, set compatibility and unlock growth tools. Takes under two minutes.

Claim this server

Security profile

Claimed and verified servers get a weekly static scan that shows what the code can reach: external services, environment variables, shell commands, agent configuration folders, plus any dependencies with known advisories. Claim this listing to get one. How the security profile works

20 of 20 tools

Documented tools (20)

From project documentation. A server handshake does not verify each tool’s description or behavior.

create_index

Create indexes on existing tables.

create_table

Create tables with column definitions.

delete_data

Preview affected rows, require confirmation.

describe_table

Column definitions, types, nullability, keys.

drop_table

Drop tables (requires confirmation).

explain_query

Execution plan analysis via SHOWPLAN.

insert_data

Parameterized inserts (single or batch).

inspect_dependencies

Full dependency analysis (views, procs, functions, triggers referencing an object).

inspect_relationships

FK mappings in both directions.

list_databases

List databases on server-level environments.

list_environments

Show configured environments and their policies.

list_scripts

Show available pre-approved SQL scripts.

list_table

List all tables in a database with optional filtering.

profile_table

Column stats (null %, cardinality, min/max/avg/median/p90) with optional sample rows.

read_data

Safe SELECT with automatic row limits.

run_script

Execute named scripts with parameters and governance controls.

search_schema

Wildcard/fuzzy search across tables and columns with pagination.

test_connection

Verify connectivity and latency.

update_data

Preview affected rows, require confirmation.

validate_environment_config

Check environment configuration for errors.

Tool change history

Compared across complete checks of the same configuration. Tools were listed, not invoked. Input-schema changes are not measured here.

No complete tool checks yet.

FAQ

Questions about Mssql MCP Server

How do I connect Mssql MCP Server to Claude?: Run `claude mcp add connorbritain-mssql-mcp-server -- npx -y @connorbritain/mssql-mcp-server@latest` in Claude Code, or add the same command and arguments under mcpServers in Cursor's mcp.json or Claude Desktop's claude_desktop_config.json, then restart the client. The blocks above are ready to paste.
Is Mssql MCP Server free?: The listed licence is MIT. Check the upstream terms for permitted use and commercial requirements; a public repository does not by itself mean the software is free or open source. Connected APIs and hosted services may have separate charges.
What can Mssql MCP Server do?: Mssql MCP Server documents 20 tools to the agent, including create_index, create_table, delete_data. The descriptions above come from project documentation. A live handshake does not test individual tool behavior.