SQL-Server-MCP

harrisonfishco/SQL-Server-MCP
★ 0 stars C# 🗄️ Database Updated 1d ago
A Model Context Protocol server that gives Claude deep visibility into SQL Server. Query your databases, diagnose performance problems, inspect locks and transactions, and explore schema — all through natural language.
View on GitHub →

Quick Install

Copy the config for your editor. Some servers may need additional setup — check the README.

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "sql-server-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "harrisonfishco/SQL-Server-MCP"
      ]
    }
  }
}

README Excerpt

A [Model Context Protocol](https://modelcontextprotocol.io) server that gives Claude deep visibility into SQL Server. Query your databases, diagnose performance problems, inspect locks and transactions, and explore schema — all through natural language. Built with **.NET 8** and **Microsoft.Data.SqlClient**. Communicates over stdio so it works with Claude Desktop, Claude Code, and any MCP-compatible client.

Tools (20)

execute_queryget_actual_planget_blocking_chainsget_estimated_planget_index_fragmentationget_index_usage_statsget_locksget_missing_indexesget_object_definitionget_open_transactionsget_query_store_top_queriesget_running_queriesget_session_detailget_table_schemaget_transaction_locksget_wait_statisticskill_sessionlist_databaseslist_indexeslist_stored_procs

Topics

aiai-toolsmcpperformance-analysissql-server