Mssql MCP Server

Shared core library for MSSQL MCP servers - tools, config, routing, and server harness

Local serverstdioTypeScript

What is the Mssql MCP server?

Shared core library for MSSQL MCP servers - tools, config, routing, and server harness. That is what the mssql mcp server brings to an AI assistant: the same capability, reachable through the Model Context Protocol rather than a separate app or dashboard.

The short version

Shared core library for the MSSQL MCP tiered package family. This package provides every tool class, the MCP server harness, environment management, audit logging, secret resolution, intent routing, and policy enforcement middleware. Consumer packages (reader, writer, server) depend on this library and call startMcpServer() with a tier to get a fully configured MCP server.

The tools it exposes

The server publishes 1 tool. What each one is for:

  • Types — The Types tool exposed by this server

Getting it running

The server ships on npm as npm, so your MCP client can launch it on demand — there is no separate build step. Add the server block to your client's configuration, restart it, and the tools register themselves.

What it needs from you

Configuration is passed through the environment: AUDIT_LOG_PATH. Treat anything key-shaped as a real credential — scope it to the minimum the server needs, and rotate it if it ever lands in a shared config.

How it compares

Among the developer tooling options, the useful question is rarely "what can it do" but "what does it cost you to run" — permissions, credentials, and how much of your context its toolset consumes. Mssql's toolset — Types — is a fair guide to whether it matches your workflow. It is maintained by connorbritain; worth a glance at recent repository activity before you build anything load-bearing on it.

This entry was verified against Mssql's own documentation before publication; SyncDev keeps the directory reviewed rather than auto-generated.

Things to watch

  • It runs with your machine's permissions. That is convenient and also the reason to think about what you point it at before you approve a tool call.
  • Keep per-call confirmation enabled while you learn its behaviour; it is the cheapest safeguard you have.

Available tools

ToolWhat it does
TypesThe Types tool exposed by this server.

How to install the Mssql MCP server

{
  "mcpServers": {
    "mssql-1": {
      "command": "npx",
      "args": ["-y", "npm"],
      "env": {
        "AUDIT_LOG_PATH": "your-value"
      }
    }
  }
}

Add to claude_desktop_config.json, then restart Claude Desktop.

Configuration

VariableDescriptionRequired
AUDIT_LOG_PATHFilesystem location the server is allowed to use.Optional

Example prompts to try

  • Use Mssql to Types.

Frequently asked questions

It connects Mssql to MCP-compatible AI assistants such as Claude and Cursor, exposing 1 tool (Types) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with Mssql directly.