MCP Server MCP

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

By github 👁 1 views ▲ 0 votes

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

Homepage Verified source GitHub

Install

npx -y [email protected]

Configuration Example

{
  "remotes": [],
  "packages": [
    {
      "registryType": "npm",
      "identifier": "sql-server-analyst-mcp",
      "version": "0.1.1",
      "transport": {
        "type": "stdio"
      },
      "environmentVariables": [
        {
          "description": "SQL Server hostname or FQDN (e.g. <name>.database.windows.net for Azure SQL).",
          "isRequired": true,
          "format": "string",
          "name": "MSSQL_SERVER"
        },
        {
          "description": "TCP port (default 1433; set 0 for named instance with dynamic port).",
          "format": "string",
          "name": "MSSQL_PORT"
        },
        {
          "description": "Default database to connect to. Most tools also accept an override argument.",
          "format": "string",
          "name": "MSSQL_DATABASE"
        },
        {
          "description": "SQL authentication login name.",
          "isRequired": true,
          "format": "string",
          "name": "MSSQL_USER"
        },
        {
          "description": "SQL authentication password. Quote values containing '#' in .env files.",
          "isRequired": true,
          "format": "string",
          "isSecret": true,
          "name": "MSSQL_PASSWORD"
        },
        {
          "description": "Encrypt the connection (true|false). Required true for Azure SQL.",
          "format": "string",
          "name": "MSSQL_ENCRYPT"
        },
        {
          "description": "Trust self-signed certificates (true|false). Use true only for local dev.",
          "format": "string",
          "name": "MSSQL_TRUST_SERVER_CERT"
        },
        {
          "description": "Comma-separated allowlist of databases the server may access. Empty = unrestricted.",
          "format": "string",
          "name": "ALLOWED_DATABASES"
        },
        {
          "description": "Comma-separated allowlist of schemas for schema tools. Empty = unrestricted.",
          "format": "string",
          "name": "ALLOWED_SCHEMAS"
        },
        {
          "description": "Default row limit per safe query (default 100).",
          "format": "string",
          "name": "MAX_ROWS"
        },
        {
          "description": "Hard cap on query rows (default 1000).",
          "format": "string",
          "name": "MAX_ROWS_LIMIT"
        },
        {
          "description": "Query execution timeout in milliseconds (default 30000).",
          "format": "string",
          "name": "QUERY_TIMEOUT_MS"
        },
        {
          "description": "error | warn | info | debug (default info).",
          "format": "string",
          "name": "LOG_LEVEL"
        }
      ]
    }
  ]
}

mcp model-context-protocol npm