InnerVault

Microsoft SQL Server

Stale Official MCP Registry, io.github.alyiox

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_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; 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

  1. tabularis

    MCP servers

    Open-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.

    Stale GitHub, TabularisDB 5,432 ★Apache-2.0Updated 6 days ago

    git clone https://github.com/TabularisDB/tabularis.git
  2. dbhub

    MCP servers

    Token conscious database MCP server for Postgres, MySQL, SQL Server, Oracle, MariaDB, SQLite.

    Indexed GitHub, bytebase 3,858 ★MITUpdated today

    git clone https://github.com/bytebase/dbhub.git
  3. PerformanceMonitor

    MCP servers

    Free, 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.

    Indexed GitHub, erikdarlingdata 536 ★MITUpdated yesterday

    git clone https://github.com/erikdarlingdata/PerformanceMonitor.git
  4. mnemiq

    MCP servers

    Open-source text-to-SQL engine you tune and measure on your own database

    Indexed GitHub, agenticfabriq 81 ★Apache-2.0Updated today

    git clone https://github.com/agenticfabriq/mnemiq.git
  5. dbine

    MCP servers

    DBine 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.

    Indexed GitHub, addlayer-io 38 ★Apache-2.0Updated 3 days ago

    git clone https://github.com/addlayer-io/dbine.git
  6. whodb

    MCP servers

    Where data access meets operational intelligence

    Indexed GitHub, clidey 5,058 ★Apache-2.0Updated today

    git clone https://github.com/clidey/whodb.git