Microsoft SQL Server

MCP server for SQL Server metadata, parameterized queries, plan analysis, and writes opt-in.

What does this entry provide?

Microsoft SQL Server is an MCP server entry in ChatHome Skills, sourced from Official MCP Registry and scored 78/100. As a Model Context Protocol server, it exposes tools that MCP-compatible LLM clients such as Claude, Cursor, and Copilot can call directly, extending an agent's reach beyond its built-in capabilities. ChatHome Skills discovered this entry through its daily ingest of official registries and GitHub discovery queries, and re-verifies repository facts, freshness signals, and install metadata on every run. The quality score weighs official-registry presence, a working install command, license clarity, GitHub star trajectory, and repository freshness — the full formula is on the Sources page. The install command above is ready to copy. Review the last-pushed date and repository status before adding Microsoft SQL Server to a production agent workflow; the snapshot facts below are point-in-time values from the most recent ingest.

Snapshot facts

Source: Official MCP Registry
Quality: 78/100
Install method: nuget
Repo: alyiox/mcp-mssql
Repo updated: Oct 26, 2026

Install command

dnx Alyio.McpMssql@1.8.0 --yes

Install method: nuget

Review the upstream source before running this command.

GitHub project

Quality

Repo stars

Repo updated

Oct 26, 2026

How is this score calculated?

Weighted across six dimensions, scored 0-100.
Provenance (25): listed in an official or curated registry.
Installability (25): a runnable install command beats a declared transport, which beats a source checkout.
Maintenance (20): recency of the last push; archived entries score zero here.
Adoption (20): repository stars on a log curve.

MCP manifest

{
  "_meta": {
    "io.modelcontextprotocol.registry/official": {
      "status": "active",
      "isLatest": true,
      "updatedAt": "2026-10-26T03:41:49.974364Z",
      "publishedAt": "2026-10-26T03:41:49.974364Z",
      "statusChangedAt": "2026-10-26T03:41:49.974364Z"
    }
  },
  "server": {
    "name": "io.github.alyiox/mcp-mssql",
    "title": "Microsoft SQL Server",
    "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
    "version": "1.8.0",
    "packages": [
      {
        "version": "1.8.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."
  }
}

Report an issue with this listing