Connect

8 clients · secrets stay placeholders

JSON (mcpServers)Claude CodeCodexOpenCodeCursorVS CodeGemini CLIGoose

{
  "mcpServers": {
    "mcp-mssql": {
      "command": "dnx",
      "args": [
        "[email protected]",
        "--yes"
      ],
      "env": {
        "MCPMSSQL_CONNECTION_STRING": "${MCPMSSQL_CONNECTION_STRING}"
      }
    }
  }
}

claude mcp add mcp-mssql -e "MCPMSSQL_CONNECTION_STRING=${MCPMSSQL_CONNECTION_STRING}" -- dnx [email protected] --yes

[mcp_servers.mcp-mssql]
command = "dnx"
args = ["[email protected]", "--yes"]
env = { "MCPMSSQL_CONNECTION_STRING" = "${MCPMSSQL_CONNECTION_STRING}" }

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "mcp-mssql": {
      "type": "local",
      "command": [
        "dnx",
        "[email protected]",
        "--yes"
      ],
      "enabled": true,
      "environment": {
        "MCPMSSQL_CONNECTION_STRING": "{env:MCPMSSQL_CONNECTION_STRING}"
      }
    }
  }
}

{
  "mcpServers": {
    "mcp-mssql": {
      "command": "dnx",
      "args": [
        "[email protected]",
        "--yes"
      ],
      "env": {
        "MCPMSSQL_CONNECTION_STRING": "${MCPMSSQL_CONNECTION_STRING}"
      }
    }
  },
  "deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=mcp-mssql&config=eyJjb21tYW5kIjoiZG54IiwiYXJncyI6WyJBbHlpby5NY3BNc3NxbEAxLjcuMCIsIi0teWVzIl0sImVudiI6eyJNQ1BNU1NRTF9DT05ORUNUSU9OX1NUUklORyI6IiR7TUNQTVNTUUxfQ09OTkVDVElPTl9TVFJJTkd9In19"
}

{
  "servers": {
    "mcp-mssql": {
      "type": "stdio",
      "command": "dnx",
      "args": [
        "[email protected]",
        "--yes"
      ],
      "env": {
        "MCPMSSQL_CONNECTION_STRING": "${MCPMSSQL_CONNECTION_STRING}"
      }
    }
  }
}

{
  "mcpServers": {
    "mcp-mssql": {
      "command": "dnx",
      "args": [
        "[email protected]",
        "--yes"
      ],
      "env": {
        "MCPMSSQL_CONNECTION_STRING": "${MCPMSSQL_CONNECTION_STRING}"
      }
    }
  }
}

extensions:
  "mcp-mssql":
    enabled: true
    name: "mcp-mssql"
    type: stdio
    cmd: "dnx"
    args:
      - "[email protected]"
      - "--yes"
    envs:
      "MCPMSSQL_CONNECTION_STRING": "${MCPMSSQL_CONNECTION_STRING}"
    timeout: 300

Placeholders to fill from your own secret store: ${MCPMSSQL_CONNECTION_STRING}. The registry never accepts secret values.

This is a local package: the command runs on your machine.

Quality – / 100not scored

Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.

protocoln/a · weight 25

n/a
protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)

authorizationn/a · weight 15

n/a
auth.prm, auth.as_metadata, auth.cimdno remote uses OAuth
n/a
auth.secret_in_urlno templated URL

tool hygienen/a · weight 30

n/a
tools.descriptions, tools.description_length, tools.schemas, tools.annotations, tools.directory_hints, tools.token_cost, tools.api_dumptool list unknown (behind auth, not probed, or empty)

stabilityn/a · weight 15

n/a
stability.changes, stability.rug_pulltool list unknown

dependenciesn/a · weight 15

n/a
deps.known_vulns, deps.mcp_sdk_version, deps.resolvableno npm or PyPI package

Tool list unknown · checked 2026-10-20 12:45 UTC

Tool changes

No tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.

Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.

Trust 96 / 100

provenance90

livenessn/a

freshness100

hygiene100

+repository +namespace-matches-repo +website ~liveness-unmeasured +updated-10d-ago

Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.

Endpoints

package	registry	version	runtime	secrets
`Alyio.McpMssql`	nuget	1.7.0	dnx	`MCPMSSQL_CONNECTION_STRING`

Tools (0)

No tools observed. Local packages are never executed by the registry.

Schemas: list_tools.

Similar MCP servers

More from io.github.alyiox

And 1 more from this publisher.

Official server.json

{
  "name": "io.github.alyiox/mcp-mssql",
  "title": "Microsoft SQL Server",
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "version": "1.7.0",
  "packages": [
    {
      "version": "1.7.0",
      "transport": {
        "type": "stdio"
      },
      "identifier": "Alyio.McpMssql",
      "runtimeHint": "dnx",
      "registryType": "nuget",
      "registryBaseUrl": "https://api.nuget.org/v3/index.json",
      "environmentVariables": [
        {
          "name": "MCPMSSQL_CONNECTION_STRING",
          "format": "string",
          "isSecret": true,
          "description": "Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings."
        },
        {
          "name": "MCPMSSQL_DESCRIPTION",
          "format": "string",
          "description": "Optional human-readable description for the default profile."
        },
        {
          "name": "MCPMSSQL_QUERY_MAX_ROWS",
          "format": "number",
          "description": "Max rows per interactive query (default 500; ceiling 1000)."
        },
        {
          "name": "MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS",
          "format": "number",
          "description": "Interactive query command timeout in seconds (default 30)."
        },
        {
          "name": "MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS",
          "format": "number",
          "description": "Max rows for snapshot queries (default 10000; ceiling 50000)."
        },
        {
          "name": "MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS",
          "format": "number",
          "description": "Snapshot query timeout in seconds (default 120)."
        },
        {
          "name": "MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS",
          "format": "number",
          "description": "Execution plan analysis timeout in seconds (default 300; ceiling 600)."
        },
        {
          "name": "MCPMSSQL_ALLOW_WRITE",
          "format": "boolean",
          "description": "Enable write commands (DDL/DML) via run_command on the default profile (default false). With no write-enabled profile the tool is not advertised at all. Soft guard only — prefer a db_datareader login for a hard read-only guarantee."
        },
        {
          "name": "MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS",
          "format": "number",
          "description": "Write command timeout in seconds (default 60; ceiling 600)."
        },
        {
          "name": "DOTNET_ENVIRONMENT",
          "format": "string",
          "description": "Set to Development to load dotnet user-secrets (local dev)."
        }
      ]
    }
  ],
  "repository": {
    "url": "https://github.com/alyiox/mcp-mssql",
    "source": "github",
    "subfolder": "src/Alyio.McpMssql"
  },
  "websiteUrl": "https://github.com/alyiox/mcp-mssql",
  "description": "MCP server for SQL Server metadata, parameterized queries, plan analysis, and writes opt-in."
}