SERVER
Microsoft SQL Server
Rank #43,269io.github.alyiox/mcp-mssql
Read-only MCP for Microsoft SQL Server: metadata discovery, parameterized SELECT, plans.
First listed
Feb 4, 2026
Last publish date
Jul 24, 2026
OVERVIEW
Microsoft SQL Server is a Model Context Protocol (MCP) server published by alyiox. It ranks #43,269 of 115,591 servers tracked on MCP Toplist, and its repository has 7 GitHub stars. Microsoft SQL Server is listed across 3 registries — Official MCP, PulseMCP and Glama, with 2 tracked versions. It was first listed on Feb 4, 2026 and most recently updated on Jul 24, 2026.
STANDING
#43,269of 115,591 tracked serversTop 50%
Ranks ahead of 72,322 of 115,591 servers on MCP Toplist.
CONNECT
Use Microsoft SQL Server
No setupRuns out of the box
No credentials or required configuration declared — add it to your MCP client and go.
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.McpMssqlReplace 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.
BADGE
Show your rank
Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.
Markdown
[](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 50% of 115,591" /></a>Variants: append ?metric=score or ?metric=stars to the image URL.
REGISTRIES
Listed on 3 registries
ORGANIZATION
alyiox
MORE FROM THIS PUBLISHER
Other servers by alyiox
- Atlassian Attachments#14,228 · 5 vers
- Walmart Connect Advertising APIs#18,429 · 4 vers
- Sam's Club Sponsored Ads APIs#20,028 · 4 vers
- Docs Ask (local docs RAG)#21,506 · 1 ver
- ClickHouse#24,463 · 3 vers
- Walmart Marketplace APIs#26,681 · 1 ver
VERSIONS
Available versions (2)
| Version | Published |
|---|---|
| 1.2.0 | Jul 24, 2026 |
| 1.0.0 | Apr 30, 2026 |
FAQ
Frequently asked questions
- Who maintains Microsoft SQL Server?
- Microsoft SQL Server is maintained by alyiox, which publishes 7 MCP servers (20 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 2 versions of Microsoft SQL Server, most recently published on Jul 24, 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.
EXPLORE