← Index

Microsoft SQL Server

io.github.alyiox/mcp-mssql·v1.0.0·Other
Quality Score
95
/100

Read-only MCP for Microsoft SQL Server: metadata discovery, parameterized SELECT, plans.

§01  Install

No runnable package or remote endpoint listed in the registry. Check the repo for manual install instructions.

§02  Environment variables
MCPMSSQL_CONNECTION_STRING
secret

Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings.

MCPMSSQL_DESCRIPTION

Optional human-readable description for the default profile.

MCPMSSQL_QUERY_MAX_ROWS

Max rows per interactive query (default 500; ceiling 1000).

MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS

Interactive query command timeout in seconds (default 30).

MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS

Max rows for snapshot queries (default 10000; ceiling 50000).

MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS

Snapshot query timeout in seconds (default 120).

MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS

Execution plan analysis timeout in seconds (default 300).

DOTNET_ENVIRONMENT

Set to Development to load dotnet user-secrets (local dev).

§03  MCP Quality Score  ·  methodology
freshness
25
completeness
20
installability
25
documentation
15
stability
10
§04  Alternatives in Other