mssql-mcp-server

GarfieldHuang/mssql-mcp-server
★ 0 stars Unknown language 🗄️ Database Updated 1d ago
Read-only MCP server for MS SQL Server — supports stdio and HTTP+JWT modes
View on GitHub → Try with Claude — $10 free →

Quick Install

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

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "mssql-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "GarfieldHuang/mssql-mcp-server"
      ]
    }
  }
}

README Excerpt

A read-only MCP (Model Context Protocol) server for MS SQL Server. Lets AI agents query your database safely — no writes, no stored procedures, no shell access. - **Read-only** — only `SELECT` queries allowed - **Two modes** — stdio (local) or HTTP + JWT (remote) - **No third-party auth libraries** — JWT verified with Node.js built-in `crypto`

Tools (12)

API_KEYDB_DATABASEDB_PASSWORDDB_PORTDB_SERVERDB_USERHTTP_PORTJWT_SECRETcryptodescribe_tablelist_tablesquery