mssql-mcp

Run read-only SQL Server queries and inspect query performance statistics.

License

MIT License

Source

third_party_registry

Updated

2026-09-03

// securityCaution

Runs locally
Open source
Licensed· MIT License

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

No copy-paste install info for "mssql-mcp" yet — see the docs or source repo.

// examples

Query business data

Prompt

Connect to the company's Microsoft SQL Server and run this read-only query: SELECT TOP 20 order_id, customer_name, total_amount, created_at FROM orders ORDER BY created_at DESC; Return the results in a table.

Expected

A structured table showing the 20 most recent order records.

Analyze slow query performance

Prompt

Read-only analyze the performance of this query on Microsoft SQL Server: SELECT customer_id, COUNT(*) AS order_count FROM orders WHERE created_at >= '2024-01-01' GROUP BY customer_id; Provide execution statistics and identify possible performance bottlenecks.

Expected

Execution statistics, detected performance issues, and optimization guidance.

Inspect data distribution

Prompt

Connect to SQL Server and read-only summarize counts and average prices by category in the products table: SELECT category, COUNT(*) AS product_count, AVG(price) AS avg_price FROM products GROUP BY category ORDER BY product_count DESC; Then summarize the key findings.

Expected

Category-level statistics plus a brief summary of key data insights.