# mcp-mssql

> mcp-mssql — alyiox-mcp-mssql. Use this tool when you need to interact with Microsoft SQL Server databases for metadata discovery, query analysis, and execution of parameterized queries. It provides a read-only interface for exploring database structures and analyzing query performance. Ideal for use cases requiring database inspection, query optimization, and data exploration without modifying the underlying data.

Canonical page: https://skillsregistry.net/skills/alyiox-mcp-mssql  
JSON: https://api.skillsregistry.net/v1/skills/alyiox-mcp-mssql

## Description

Read-only-by-default MCP server for Microsoft SQL Server: metadata discovery, parser-enforced SELECT-only queries, and execution-plan analysis for diagnosing slow queries. Profile-based multi-connection config; the write tool stays unregistered until a profile opts in. Ships as a .NET tool on NuGet.

## Trust

- **Trust score (0–1):** 0.55
- **Verification tier:** scanned
- **Last scanned:** 2026-09-02

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** container
- **Runtime environment:** vm
- **Category:** database
- **Updated:** 2026-09-23

## Source

- **Source listing:** [GitHub](https://github.com/alyiox/mcp-mssql)

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "alyiox-mcp-mssql"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/alyiox-mcp-mssql` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/alyiox-mcp-mssql/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt