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

The full server descriptor as registered with IndusMCP.

{
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "name": "io.github.coregentdevspace/sql-server-analyst-mcp",
  "description": "Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.",
  "repository": {
    "url": "https://github.com/coregentdevspace/sql-server-analyst-mcp",
    "source": "github"
  },
  "version": "0.1.1",
  "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"
        }
      ]
    }
  ],
  "_meta": {
    "dev.indusmcp/source": "official-registry-mirror",
    "dev.indusmcp/synced": "2026-05-12"
  }
}