Microsoft SQL Server MCP Server
A read-only-by-default Model Context Protocol (MCP) server for Microsoft SQL Server. Beyond schema discovery and parameterized SELECT queries, it exposes execution-plan analysis for cost, operators, cardinality estimates, warnings, and index suggestions, so an agent can work out why a query is slow instead of only running it. Profile-based configuration serves multiple databases and servers from one toolset…
People who work with mssql, read only and sql server and want it reachable from Claude, Cursor, VS Code, or another MCP client. The project is written in C#.
VERIFIED ACTIVE
LAST COMMIT 2026-09-17 · ★ 9 · #148 OF 168 MAINTAINED DATABASE · VERIFIED 2026-09-18
MIT · C# · how we verify → /methodology
01 · Evidence
Security posture
What to check before giving this server access to your agent - from the registry, GitHub, and our own probes. We don't score safety; we show what's verifiable.
license MIT - declared in the repository
registry namespace io.github.alyiox is GitHub-verified and matches the repo owner
02 · What Microsoft SQL Server can do
Prose above is summarized from the project's README and registry record - no invented capabilities.
What you can build
An agent gets 2 documented tools across kind, includes, including kind, includes.
The 2 tools it gives your agent
Extracted from the project's README - what Microsoft SQL Server lets an agent do.
- kind
- - relation or routine.
- includes
- - Array of detail sections: columns, indexes, constraints, relationships (relations only), definition (routines only). relationships returns foreign keys in both
03 · Who maintains Microsoft SQL Server
Microsoft SQL Server is maintained by alyiox. We track 7 MCP servers from alyiox - 5 actively maintained, 10 combined GitHub stars, oldest repo from Feb 2026.
04 · Facts
- repository
- github.com/alyiox/mcp-mssql
- category
- database - ranked #148 of 168 actively-maintained database servers as of 2026-09-18.
- registry
- io.github.alyiox/mcp-mssql (active, first published 2026-04-30 · 7 versions)
- packages
- nuget:Alyio.McpMssql
05 · Microsoft SQL Server FAQ
What is Microsoft SQL Server?
A read-only-by-default Model Context Protocol (MCP) server for Microsoft SQL Server. Beyond schema discovery and parameterized SELECT queries, it exposes execution-plan analysis for cost, operators, cardinality estimates, warnings, and index suggestions, so an agent can work out why a query is slow instead of only running it. Profile-based configuration serves multiple databases and servers from one toolset…
Is Microsoft SQL Server still maintained?
Yes - as of 2026-09-18, its last commit was 2026-09-17. We re-verify nightly.
06 · Alternatives to Microsoft SQL Server
Alternatives to Microsoft SQL Server
Maintained database servers if Microsoft SQL Server isn't the fit.
- Dbx Query databases from AI agents using connections configured in DBX. ★ 20,017 · 2026-09-18
- Toolbox for Databases MCP Toolbox for Databases enables your agent to connect to your database. ★ 16,449 · 2026-09-18
- Butterbase Ai MCP Server Butterbase MCP server - manage your backend: schemas, auth, functions, storage, RAG, deploys. ★ 3,562 · 2026-09-18
- Dbhub Minimal, token-efficient Database MCP Server for PostgreSQL, MySQL, SQL Server, SQLite, MariaDB ★ 3,534 · 2026-09-18
- LINQ to DB Inspect database schemas and execute SQL queries across multiple database providers with LINQ to DB. ★ 3,328 · 2026-09-17
- Supabase MCP server for interacting with the Supabase platform ★ 2,910 · 2026-09-17
Pairs well with
Servers that cover what Microsoft SQL Server doesn't - only shown when the pairing reason fits the companion.
- Server Chart → data & analytics companion data & analytics · ★ 4,367
- ClaudeR - RStudio MCP Server → data & analytics companion data & analytics · ★ 342
- Server Filesystem → filesystem companion filesystem · ★ 39,038
- Pdf MCP → filesystem companion filesystem · ★ 135
- Telnyx → API integration companion API integration · ★ 197
- Microsoft 365 MCP Server → API integration companion API integration · ★ 980
More database MCP servers · Interactive Terminal · Tableau Workbook Auditor · iMessage History · Garmin Local MCP · Fastbcp MCP