io.github.Nithish1206/SqlServerMcp

Inspect SQL Server schemas, run safe read-only queries, and analyze query plans.

Source

Official Registry

Updated

2026-06-25

// securityCaution

Runs locally
Official / curated
Open source
Community-trusted

Running security audit…

Credentials
Network egress
Code execution
Data access
Supply chain

// install

Copy the install command and let the AI configure it · recommended for beginners

Please install the "io.github.Nithish1206/SqlServerMcp" MCP server from askskill:
Run: claude mcp add 'io-github-nithish1206-sqlservermcp' -- npx -y SqlServerMcp

// examples

Inspect database schema

Prompt

Connect to SQL Server and list all tables, column types, primary keys, and indexes in the current database, grouped by schema.

Expected

A structured inventory of database metadata to understand table structures and index design.

Run a safe read-only query

Prompt

Run a read-only query on sales.orders to calculate daily order counts and total sales for the last 30 days, sorted by date ascending, without performing any write operations.

Expected

A result table with the last 30 days of order statistics, ready for analysis or reporting.

Analyze a query execution plan

Prompt

Analyze the execution plan for the following SQL query, identify possible performance bottlenecks, and suggest practical indexing or query rewrite improvements: SELECT * FROM orders WHERE customer_id = 1001 AND order_date >= '2024-01-01';

Expected

An execution plan interpretation, bottleneck diagnosis, and concrete performance optimization recommendations.