sql server analyst mcp for Grok

io.github.coregentdevspace/sql-server-analyst-mcp

Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.

client:Grok transport:stdio runtime:npm

Install sql server analyst mcp in Grok

.mcp.json (in your project root)

MSSQL_SERVER

MSSQL_PORT

MSSQL_DATABASE

MSSQL_USER

MSSQL_PASSWORD

MSSQL_ENCRYPT

MSSQL_TRUST_SERVER_CERT

ALLOWED_DATABASES

ALLOWED_SCHEMAS

MAX_ROWS

MAX_ROWS_LIMIT

QUERY_TIMEOUT_MS

LOG_LEVEL

Held in this page only — never stored, logged, or sent anywhere but back to your screen.

{
  "mcpServers": {
    "sql-server-analyst-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "sql-server-analyst-mcp"
      ],
      "env": {
        "MSSQL_SERVER": "<MSSQL_SERVER>",
        "MSSQL_PORT": "<MSSQL_PORT>",
        "MSSQL_DATABASE": "<MSSQL_DATABASE>",
        "MSSQL_USER": "<MSSQL_USER>",
        "MSSQL_PASSWORD": "<MSSQL_PASSWORD>",
        "MSSQL_ENCRYPT": "<MSSQL_ENCRYPT>",
        "MSSQL_TRUST_SERVER_CERT": "<MSSQL_TRUST_SERVER_CERT>",
        "ALLOWED_DATABASES": "<ALLOWED_DATABASES>",
        "ALLOWED_SCHEMAS": "<ALLOWED_SCHEMAS>",
        "MAX_ROWS": "<MAX_ROWS>",
        "MAX_ROWS_LIMIT": "<MAX_ROWS_LIMIT>",
        "QUERY_TIMEOUT_MS": "<QUERY_TIMEOUT_MS>",
        "LOG_LEVEL": "<LOG_LEVEL>"
      }
    }
  }
}

Grok Build reads Claude Code's .mcp.json and Claude Desktop's config unchanged, so a server you have already set up there needs nothing new. The Grok web app and X integration do not take custom servers. Grok docs

sql server analyst mcp in other clients

sql server analyst mcp MCP server