Mssql MCP Server

Unclaimed

by ConnorBritain

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

Install

$npm install -g @connorbritain/mssql-mcp-server@latest

Unclaimed listing

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

Tools (20)

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.