mcp-mssql
mcp-mssql is an MCP server, listed under databases. Its repository has 9 GitHub stars and is licensed under MIT; we last read it on 2026-10-25.
This tool provides read-only access to Microsoft SQL Server, offering metadata discovery, SELECT-only query enforcement, and execution plan analysis. It supports profile-based multi-connection configuration and is available as a .NET tool on NuGet.
Install
Read from mcp-mssql’s own README, close to verbatim -- not written by us, and not guessed.
export MCPMSSQL_CONNECTION_STRING="Server=127.0.0.1;User ID=sa;Password=<YourStrong@Passw0rd>;Encrypt=True;TrustServerCertificate=True;" && npx -y @modelcontextprotocol/inspector@latest dotnet dnx Alyio.McpMssql --prerelease
What it reaches, and what it needs
Reaches
○ not recognised
Credential
○ none found
Maintenance
Stars
9
State
listed
Licence
MIT
From the repository
Read-only-by-default MCP server for one or many SQL Servers: schema discovery, SELECT-only queries, execution-plan analysis, opt-in writes.
mcp-mssql compared with similar servers
| Server | Reaches | Needs | Stars | Last update | Licence |
|---|---|---|---|---|---|
| mcp-mssql (this page) | — | None listed | 9 | 2026-10-10 | MIT |
| CodeGraphContext | neo4j | NEO4J_PASSWORD | 4,360 | 2026-10-22 | MIT |
| dbhub | mysql, postgres, sqlite | None listed | 3,702 | 2026-10-21 | MIT |
| mcp-server-mysql | mysql | None listed | 2,173 | 2026-07-27 | MIT |
| mysql_mcp_server | mysql | MYSQL_PASSWORD | 1,402 | 2026-08-02 | MIT |
| server | mysql | MYSQL_ROOT_PASSWORD | 874 | 2025-08-09 | MIT |
Ranked by services in common with mcp-mssql, then by stars. Figures are from each repository when we last read it.
Common questions about mcp-mssql
- What does mcp-mssql do?
- This tool provides read-only access to Microsoft SQL Server, offering metadata discovery, SELECT-only query enforcement, and execution plan analysis. It supports profile-based multi-connection configuration and is available as a .NET tool on NuGet.
- How do I install mcp-mssql?
- Its own README gives this command: export MCPMSSQL_CONNECTION_STRING="Server=127.0.0.1;User ID=sa;Password=<YourStrong@Passw0rd>;Encrypt=True;TrustServerCertificate=True;" && npx -y @modelcontextprotocol/inspector@latest dotnet dnx Alyio.McpMssql --prerelease. Run it where your MCP client can launch the server, and check the README for any settings it asks for.
- Is mcp-mssql official and is it maintained?
- We found nothing naming it as a vendor’s official server. Its repository has 9 GitHub stars and its state in our directory is listed. Its last commit we recorded was on 2026-10-10.
- What licence does mcp-mssql use?
- The repository declares the MIT licence.
More MCP servers for databases
- CodeGraphContext4,360 stars
- dbhub3,702 stars
- mcp-server-mysql2,173 stars
- mysql_mcp_server1,402 stars
- server874 stars
- supabase-mcp-server833 stars