test_connection

MCP tool from Mssql MCP Server by ConnorBritain

Verify connectivity and latency.

How to use it

test_connection is exposed by the Mssql MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the test_connection tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install Mssql MCP Server

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

FULL MSSQL MCP SERVER LISTING

Other tools in Mssql MCP Server (19)

Create indexes on existing tables.

Create tables with column definitions.

Preview affected rows, require confirmation.

Column definitions, types, nullability, keys.

Drop tables (requires confirmation).

Execution plan analysis via SHOWPLAN.

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 on server-level environments.

list_environments

Show configured environments and their policies.

Show available pre-approved SQL scripts.

List all tables in a database with optional filtering.

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

Safe SELECT with automatic row limits.

Execute named scripts with parameters and governance controls.

Wildcard/fuzzy search across tables and columns with pagination.

Preview affected rows, require confirmation.

validate_environment_config

Check environment configuration for errors.