Microsoft SQL Server

io.github.alyiox/mcp-mssql

4/4 checks passed
Runs locally
1 secret
★ 9 GitHub stars
Updated 2026-10-26
Health score 52

About Microsoft SQL Server

Microsoft SQL Server is an MCP server published by the GitHub account alyiox. MCP server for SQL Server metadata, parameterized queries, plan analysis, and writes opt-in.

It runs on your own machine: your AI client starts it from the NuGet package Alyio.McpMssql at version 1.8.0.

It asks for one secret: MCPMSSQL_CONNECTION_STRING. Give it a key with the least access that still works.

Version 1.8.0 was published on 26 October 2026, and the source code is public, so you can read it before installing.

Written from the registry entry. 7 automated checks on registry metadata: 4 pass, 0 warn, 0 fail, 3 info. How we check.

What it asks for

Variable	Required	Secret	Description
`MCPMSSQL_CONNECTION_STRING`	No	Yes	Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings.
`MCPMSSQL_DESCRIPTION`	No	No	Optional human-readable description for the default profile.
`MCPMSSQL_QUERY_MAX_ROWS`	No	No	Max rows per interactive query (default 500; ceiling 1000).
`MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS`	No	No	Interactive query command timeout in seconds (default 30).
`MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS`	No	No	Max rows for snapshot queries (default 10000; ceiling 50000).
`MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS`	No	No	Snapshot query timeout in seconds (default 120).
`MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS`	No	No	Execution plan analysis timeout in seconds (default 300; ceiling 600).
`MCPMSSQL_ALLOW_WRITE`	No	No	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.
`MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS`	No	No	Write command timeout in seconds (default 60; ceiling 600).
`DOTNET_ENVIRONMENT`	No	No	Set to Development to load dotnet user-secrets (local dev).

Checks

Check	Result	Detail
Source repository linked	Pass	https://github.com/alyiox/mcp-mssql
Version pinned	Pass	Every package has an explicit version
Secrets requested	Info	Asks for 1 secret: MCPMSSQL_CONNECTION_STRING
Known package registry	Pass	All packages come from npm, PyPI, OCI, NuGet or MCPB
Namespace ownership	Info	Name verified via GitHub account alyiox
Registry text aimed at the AI	Pass	Description and settings contain no hidden characters or instructions to the AI
Code red flags	Info	nuget packages are not read yet

Popularity & health: 52 / 100

Worked out from public numbers and our own checks, not from user reviews or ratings. It says how used and how looked-after a server is, not whether it is safe.

Popularity9 / 40

9 GitHub stars, no download count, no Hacker News posts found. Best two of the three, each on a log scale.

Activity15 / 25

Last push 2026-10-26, no GitHub release, 0 commits in 90 days.

Issue health8 / 15

1 closed of 1 issues, too few to judge. No data, so half marks.

Our checks20 / 20

0 warnings, each costing a fifth.

1 forks, 3 merged pull requests. Sources: GitHub, npm, PyPI (pypistats.org) and Hacker News (Algolia), fetched 2026-10-31.

What people say

No Hacker News threads link to its source code.

Look further: search Reddit, search Hacker News, read its GitHub issues. These are not reviews we checked.

Facts

Registry name	`io.github.alyiox/mcp-mssql`
Publisher	GitHub account alyiox
How the name is verified	Name verified via GitHub account alyiox. The registry ties the name prefix to that account or domain; it does not check the code.
Type	Local: runs on your machine from a package
Packages	nuget `Alyio.McpMssql` 1.8.0 (stdio)
Version	1.8.0
Published	2026-10-26
Last updated	2026-10-26
Source repository	https://github.com/alyiox/mcp-mssql
Website	https://github.com/alyiox/mcp-mssql
Category	Databases & data (assigned by keyword rule, not by hand)