SERVER

Microsoft SQL Server

Rank #35,812

io.github.alyiox/mcp-mssql

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

8 versions

9 GitHub stars

by alyiox (11 servers)View repository ↗

First listed

Feb 4, 2026

Last publish date

Oct 10, 2026

PURPOSE

What you can do with Microsoft SQL Server

Microsoft SQL Server is a Model Context Protocol (MCP) server published by alyiox. It ranks #35,812 of 144,396 active servers on MCP Toplist, and its repository has 9 GitHub stars. Microsoft SQL Server is listed across 3 registries — Official MCP, PulseMCP and Glama, with 8 tracked versions. It was first listed on Feb 4, 2026 and most recently updated on Oct 10, 2026.

Not verifiedMCP Toplist has not yet written a checked profile for this server, so the paragraph above is assembled from registry data only. The repository README is the authority on what it does.

CAPABILITIES AND LIMITATIONS

What Microsoft SQL Server can and cannot do

Not verifiedMCP Toplist has not catalogued this server's tools or limitations. The repository README lists them.

REQUIREMENTS

What you need before using Microsoft SQL Server

DeclaredNo credentialsNo credentials declared

The registry listing declares no required environment variables or authentication. This is declared metadata, not a verified install — the repository README is the authority.

Declared by the Official MCP Registry, last synced Oct 16, 2026. Not independently verified by MCP Toplist.

Declared in the registry install config

MCPMSSQL_CONNECTION_STRING · optional
MCPMSSQL_DESCRIPTION · optional
MCPMSSQL_QUERY_MAX_ROWS · optional
MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS · optional
MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS · optional
MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS · optional
MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS · optional
MCPMSSQL_ALLOW_WRITE · optional
MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS · optional
DOTNET_ENVIRONMENT · optional

INSTALLATION AND FIRST TASK

Connect Microsoft SQL Server and confirm it works

NuGet package

claude mcp add mcp-mssql -e "MCPMSSQL_CONNECTION_STRING=<your MCPMSSQL_CONNECTION_STRING>" -e "MCPMSSQL_DESCRIPTION=<your MCPMSSQL_DESCRIPTION>" -e "MCPMSSQL_QUERY_MAX_ROWS=<your MCPMSSQL_QUERY_MAX_ROWS>" -e "MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS=<your MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS>" -e "MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS=<your MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS>" -e "MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS=<your MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS>" -e "MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS=<your MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS>" -e "MCPMSSQL_ALLOW_WRITE=<your MCPMSSQL_ALLOW_WRITE>" -e "MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS=<your MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS>" -e "DOTNET_ENVIRONMENT=<your DOTNET_ENVIRONMENT>" -- dnx Alyio.McpMssql

Replace each placeholder with your own value before saving.

NuGet package

[mcp_servers.mcp-mssql]
command = "dnx"
args = ["Alyio.McpMssql"]

[mcp_servers.mcp-mssql.env]
MCPMSSQL_CONNECTION_STRING = "<your MCPMSSQL_CONNECTION_STRING>"
MCPMSSQL_DESCRIPTION = "<your MCPMSSQL_DESCRIPTION>"
MCPMSSQL_QUERY_MAX_ROWS = "<your MCPMSSQL_QUERY_MAX_ROWS>"
MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS = "<your MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS>"
MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS = "<your MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS>"
MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS = "<your MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS>"
MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS = "<your MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS>"
MCPMSSQL_ALLOW_WRITE = "<your MCPMSSQL_ALLOW_WRITE>"
MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS = "<your MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS>"
DOTNET_ENVIRONMENT = "<your DOTNET_ENVIRONMENT>"

Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.

NuGet package

{
  "mcpServers": {
    "mcp-mssql": {
      "command": "dnx",
      "args": [
        "Alyio.McpMssql"
      ],
      "env": {
        "MCPMSSQL_CONNECTION_STRING": "<your MCPMSSQL_CONNECTION_STRING>",
        "MCPMSSQL_DESCRIPTION": "<your MCPMSSQL_DESCRIPTION>",
        "MCPMSSQL_QUERY_MAX_ROWS": "<your MCPMSSQL_QUERY_MAX_ROWS>",
        "MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS": "<your MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS>",
        "MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_ALLOW_WRITE": "<your MCPMSSQL_ALLOW_WRITE>",
        "MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS>",
        "DOTNET_ENVIRONMENT": "<your DOTNET_ENVIRONMENT>"
      }
    }
  }
}

Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.

NuGet package

{
  "mcpServers": {
    "mcp-mssql": {
      "command": "dnx",
      "args": [
        "Alyio.McpMssql"
      ],
      "env": {
        "MCPMSSQL_CONNECTION_STRING": "<your MCPMSSQL_CONNECTION_STRING>",
        "MCPMSSQL_DESCRIPTION": "<your MCPMSSQL_DESCRIPTION>",
        "MCPMSSQL_QUERY_MAX_ROWS": "<your MCPMSSQL_QUERY_MAX_ROWS>",
        "MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS": "<your MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS>",
        "MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_ALLOW_WRITE": "<your MCPMSSQL_ALLOW_WRITE>",
        "MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS>",
        "DOTNET_ENVIRONMENT": "<your DOTNET_ENVIRONMENT>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.

NuGet package

{
  "servers": {
    "mcp-mssql": {
      "type": "stdio",
      "command": "dnx",
      "args": [
        "Alyio.McpMssql"
      ],
      "env": {
        "MCPMSSQL_CONNECTION_STRING": "<your MCPMSSQL_CONNECTION_STRING>",
        "MCPMSSQL_DESCRIPTION": "<your MCPMSSQL_DESCRIPTION>",
        "MCPMSSQL_QUERY_MAX_ROWS": "<your MCPMSSQL_QUERY_MAX_ROWS>",
        "MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS": "<your MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS>",
        "MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_ALLOW_WRITE": "<your MCPMSSQL_ALLOW_WRITE>",
        "MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS>",
        "DOTNET_ENVIRONMENT": "<your DOTNET_ENVIRONMENT>"
      }
    }
  }
}

Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.

NuGet package

{
  "mcpServers": {
    "mcp-mssql": {
      "command": "dnx",
      "args": [
        "Alyio.McpMssql"
      ],
      "env": {
        "MCPMSSQL_CONNECTION_STRING": "<your MCPMSSQL_CONNECTION_STRING>",
        "MCPMSSQL_DESCRIPTION": "<your MCPMSSQL_DESCRIPTION>",
        "MCPMSSQL_QUERY_MAX_ROWS": "<your MCPMSSQL_QUERY_MAX_ROWS>",
        "MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS": "<your MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS>",
        "MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_ALLOW_WRITE": "<your MCPMSSQL_ALLOW_WRITE>",
        "MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS>",
        "DOTNET_ENVIRONMENT": "<your DOTNET_ENVIRONMENT>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.

NuGet package

{
  "mcpServers": {
    "mcp-mssql": {
      "command": "dnx",
      "args": [
        "Alyio.McpMssql"
      ],
      "env": {
        "MCPMSSQL_CONNECTION_STRING": "<your MCPMSSQL_CONNECTION_STRING>",
        "MCPMSSQL_DESCRIPTION": "<your MCPMSSQL_DESCRIPTION>",
        "MCPMSSQL_QUERY_MAX_ROWS": "<your MCPMSSQL_QUERY_MAX_ROWS>",
        "MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS": "<your MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS>",
        "MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS>",
        "MCPMSSQL_ALLOW_WRITE": "<your MCPMSSQL_ALLOW_WRITE>",
        "MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS": "<your MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS>",
        "DOTNET_ENVIRONMENT": "<your DOTNET_ENVIRONMENT>"
      }
    }
  }
}

Replace each placeholder with your own value before saving.

First successful task

After adding the config, ask your client to list this server's tools. A tool list confirms the connection; an empty list or an error means the server did not start or needs credentials.

ALTERNATIVES

When to choose another server

Other servers by alyiox

View all alyiox servers →

No task-specific alternatives are catalogued for Microsoft SQL Serveryet; the list above is its publisher's other servers.

MAINTENANCE AND EVIDENCE

What changed, and when this was checked

First listed: Feb 4, 2026
Latest version published: Oct 10, 2026
Version history: 8 versions tracked (below)
Requirements evidence: Declared by the Official MCP Registry, last synced Oct 16, 2026. Not independently verified by MCP Toplist.
Profile checked: Not yet — purpose, capabilities and requirements above come from registry data only
Ranking data as of: Oct 16, 2026

Registry sightings

Official MCP ↗listed since Apr 30, 2026 · still listed
PulseMCP ↗listed since May 22, 2026 · still listed
Glama ↗listed since Jul 29, 2026 · still listed

Do you maintain Microsoft SQL Server? to correct or enrich this profile.

VERSIONS

Available versions (8)

Version	Published
1.7.0	Oct 10, 2026
1.6.1	Sep 15, 2026
1.5.0	Sep 14, 2026
1.4.0	Sep 14, 2026
1.3.0	Sep 1, 2026
1.2.0	Jul 24, 2026
1.1.0	Jun 22, 2026
1.0.0	Apr 30, 2026

STANDING

#35,812of 144,396 active serversTop 25%

Ranks ahead of 108,584 of 144,396 servers on MCP Toplist.

BADGE

Show your rank

Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.

Markdown

[![MCP Toplist](https://mcptoplist.com/badge/io.github.alyiox%2Fmcp-mssql.svg)](https://mcptoplist.com/server/io.github.alyiox%2Fmcp-mssql)

HTML

<a href="https://mcptoplist.com/server/io.github.alyiox%2Fmcp-mssql"><img src="https://mcptoplist.com/badge/io.github.alyiox%2Fmcp-mssql.svg" alt="MCP Toplist: Top 25% of 144,396" /></a>

Variants: append ?metric=score or ?metric=stars to the image URL.

FAQ

Frequently asked questions

Who maintains Microsoft SQL Server?: Microsoft SQL Server is maintained by alyiox, which publishes 11 MCP servers (50 total versions) tracked on MCP Toplist.
Is Microsoft SQL Server listed on the Official MCP Registry?: Yes — Microsoft SQL Server is listed on the Official MCP Registry, alongside PulseMCP and Glama.
How many versions does Microsoft SQL Server have?: MCP Toplist tracks 8 versions of Microsoft SQL Server, most recently published on Oct 10, 2026.
Where can I find the source code for Microsoft SQL Server?: The source code for Microsoft SQL Server is hosted at github.com/alyiox/mcp-mssql/tree/HEAD/src/Alyio.McpMssql.

Used in projects

Do you run this server?

Community projects list the MCP servers behind real agents and apps. Publish yours and this page will link to it.

EXPLORE

All MCP Servers Official MCP Servers GitHub MCP Servers Best MCP Servers Most Active MCP Servers New MCP Servers Best New MCP Servers