create_index

MCP tool from Mssql MCP Server by ConnorBritain

Create indexes on existing tables.

How to use it

create_index is exposed by the Mssql MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the create_index 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 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.

test_connection

Verify connectivity and latency.

Preview affected rows, require confirmation.

validate_environment_config

Check environment configuration for errors.