Developer · Local MCP server
Microsoft SQL Server
Read-only-by-default SQL Server: schema, parameterized SELECT, execution plans; writes opt-in.
What the MCP Registry states
The entry as published to the official MCP Registry (read 2026-10-04), latest version.
- Registry name
io.github.alyiox/mcp-mssql- Version
- 1.6.1
- Status
- Active
- Category
- developer
- Transport
- stdio (local process)
- Package
- NuGet
- Published
- 2026-09-15
- Updated
- 2026-09-15
- Publisher
- alyiox (GitHub) · 5 servers with pages here
- Listed under
- SQL Server MCP servers
- Website
- github.com/alyiox/mcp-mssql
- Repository
- github.com/alyiox/mcp-mssql (folder src/Alyio.McpMssql)
- Source
- Registry API entry
Packages
| Registry | Package | Version | Transport |
|---|---|---|---|
| NuGetruntime: dnx | Alyio.McpMssql | 1.6.1 | stdio |
How to connect Microsoft SQL Server
Microsoft SQL Server runs locally from a .NET package published to NuGet: Alyio.McpMssql version 1.6.1. It speaks MCP over stdio, so the client starts it as a program and talks to it through standard input and output. It needs the .NET SDK; run as a .NET tool; the entry names dnx as the runtime. It reads these environment variables: MCPMSSQL_CONNECTION_STRING (secret), MCPMSSQL_DESCRIPTION, MCPMSSQL_QUERY_MAX_ROWS, MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS, MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS, MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS, MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS, MCPMSSQL_ALLOW_WRITE, MCPMSSQL_WRITE_COMMAND_TIMEOUT_SECONDS and DOTNET_ENVIRONMENT; set them in the client's configuration for this server.
Derived from the registry entry, not tested here. What the server does, and on what terms, is set by its publisher; check its repository or website before giving it access to your accounts or files. How to add an MCP server to an assistant · Before you connect
More from alyiox (GitHub)
| Server | Runs |
|---|---|
| Atlassian AttachmentsMCP server for downloading, uploading, and deleting Jira Cloud attachments by ID. | Local · stdio |
| ClickHouseRead-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis. | Local · stdio |
| Docs Ask (local docs RAG)Local RAG MCP for markdown documentation. Retrieval only; host synthesizes answers. | Local · stdio |
| OpenAPI ServicesMCP server that fronts any OpenAPI service: discover operations from its spec and call them. | Local · stdio |
More developer servers
| Server | Runs |
|---|---|
| Microsoft Access DatabaseRead and edit Microsoft Access databases (.accdb/.mdb) - forms, VBA, tables, queries. Windows. | Local · stdio |
| Microsoft Advertising MCP ServerMicrosoft Ads management — CRUD, Google Ads import, ad extensions, and async reports. | Remote & Local · HTTP, stdio |
| Microsoft Learn MCPOfficial Microsoft Learn MCP Server – real-time, trusted docs & code samples for AI and LLMs. | Remote · HTTP |
| Microsoft MCP Server for EnterpriseOfficial Microsoft MCP Server to query Microsoft Entra data using natural language. | Remote · HTTP |
| Microsoft Windows Security Updates (MSRC CVRF) — buy per-query in-session (msrcwatch)MSRC Windows updates: CVE rollups, Patch Tuesday. Register in-session — free testnet funds. | Remote · HTTP |
| MidasLocal-first, source-traceable agent memory — no LLM at ingest, fully offline. | Local · stdio |
| middleBrick MCP-SERVERScan APIs for OWASP Top 10, LLM, and GraphQL security vulnerabilities. | Local · stdio |
| MidplaneSafe-by-default SQL guardrails for AI agents: AST-checked queries, per-table policy, audit log. | Local · stdio, HTTP |