Microsoft SQL Server MCP Server
A read-only-by-default Model Context Protocol (MCP) server for Microsoft SQL Server that supports metadata discovery, parameterized queries, and query analysis, with profile-based configuration. The query tools enforce SELECT-only (no DML/DDL); an optional run_command tool can execute arbitrary write T-SQL, but only on profiles that explicitly opt in via AllowWrite (locked off by default).
People who need database tools inside Claude, Cursor, VS Code, or another MCP client. The project is written in C#.
VERIFIED ACTIVE
LAST COMMIT 2026-08-18 · ★ 7 · #134 OF 151 MAINTAINED DATABASE · VERIFIED 2026-08-25
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
- - catalog, schema, relation, or routine. For get_object, only relation or routine.
- includes
- - Array of detail sections: columns, indexes, constraints (relations only), definition (routines only).
03 · Who maintains Microsoft SQL Server
Microsoft SQL Server is maintained by alyiox. We track 7 MCP servers from alyiox - 7 actively maintained, 8 combined GitHub stars, oldest repo from Feb 2026.
04 · Facts
- repository
- github.com/alyiox/mcp-mssql
- category
- database - ranked #134 of 151 actively-maintained database servers as of 2026-08-25.
- registry
- io.github.alyiox/mcp-mssql (active, first published 2026-04-30 · 3 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 that supports metadata discovery, parameterized queries, and query analysis, with profile-based configuration. The query tools enforce SELECT-only (no DML/DDL); an optional run_command tool can execute arbitrary write T-SQL, but only on profiles that explicitly opt in via AllowWrite (locked off by default).
Is Microsoft SQL Server still maintained?
Yes - as of 2026-08-25, its last commit was 2026-08-18. 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. ★ 16,462 · 2026-08-25
- Toolbox for Databases MCP Toolbox for Databases enables your agent to connect to your database. ★ 16,249 · 2026-08-25
- Dbhub Minimal, token-efficient Database MCP Server for PostgreSQL, MySQL, SQL Server, SQLite, MariaDB ★ 3,395 · 2026-08-21
- Butterbase Ai MCP Server Butterbase MCP server - manage your backend: schemas, auth, functions, storage, RAG, deploys. ★ 3,225 · 2026-08-24
- Supabase MCP server for interacting with the Supabase platform ★ 2,871 · 2026-08-22
- MongoDB MCP Server MongoDB Model Context Protocol Server ★ 1,106 · 2026-08-24
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,337
- Keboola MCP Server → data & analytics companion data & analytics · ★ 86
- Server Filesystem → filesystem companion filesystem · ★ 38,704
- X402 List MCP → filesystem companion filesystem · ★ 58
- Telnyx → API integration companion API integration · ★ 197
- Microsoft 365 MCP Server → API integration companion API integration · ★ 932
More database MCP servers · Interactive Terminal · Tableau Workbook Auditor · Garmin Local MCP · Fastbcp MCP · Schema Brain