Microsoft SQL Server
MCP server for SQL Server metadata, parameterized queries, plan analysis, and writes opt-in.
Open the source (opens github.com) https://github.com/alyiox/mcp-mssql
Before you use it
- Runs on your computer with your permissions. Read what it can do before connecting it to an agent.
- Needs credentials: MCPMSSQL_CONNECTION_STRING. Use a key with the least access you can.
What it is
MCP servers from io.github.alyiox.
The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.
How to get it
nuget package (stdio)
Alyio.McpMssql@1.8.0
From the server's entry in the official MCP Registry
Settings it asks for
MCPMSSQL_CONNECTION_STRINGsecret · 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; ceiling 600).MCPMSSQL_ALLOW_WRITE· 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…MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS· Write command timeout in seconds (default 60; ceiling 600).DOTNET_ENVIRONMENT· Set to Development to load dotnet user-secrets (local dev).
Related
-
tabularis
MCP serversOpen-source desktop SQL workspace with 3 built-in database drivers and 29 shipped driver plugins, including SQL Server, DuckDB, ClickHouse and Redis. Built-in MCP server for Claude, Cursor and Devin, SQL notebooks and visual EXPLAIN.
git clone https://github.com/TabularisDB/tabularis.git -
dbhub
MCP serversToken conscious database MCP server for Postgres, MySQL, SQL Server, Oracle, MariaDB, SQLite.
git clone https://github.com/bytebase/dbhub.git -
PerformanceMonitor
MCP serversFree, open-source SQL Server and Postgres performance monitoring. Collectors, real-time alerts, graphical plan viewer, MCP server for AI analysis. Supports SQL 2016-2025, Azure SQL, AWS RDS, Postgres, Aurora Postgres.
git clone https://github.com/erikdarlingdata/PerformanceMonitor.git -
mnemiq
MCP serversOpen-source text-to-SQL engine you tune and measure on your own database
git clone https://github.com/agenticfabriq/mnemiq.git -
dbine
MCP serversDBine database manager: a free desktop app for 130+ SQL and NoSQL databases and cloud services, with notebooks, schema & data compare, cross-engine migration, a local AI assistant, an MCP server and encrypted cloud sync. Rust + Tauri.
git clone https://github.com/addlayer-io/dbine.git -
whodb
MCP serversWhere data access meets operational intelligence
git clone https://github.com/clidey/whodb.git