MSSQL MCP Server

MCPOpen SourceMIT27.3

by mihai-dulgheru • Data & Databases

A Node.js MCP server that exposes Microsoft SQL Server databases as resources, allowing agents to execute safe SQL queries and retrieve schema information.

Example Use Cases

1
Query Microsoft SQL Server databases programmatically and receive tabular results or JSON-formatted recordsets.
2
Discover database schemas and table column metadata to build safe, validated queries or generate data mappings.
3
An MCP-compatible adapter (STDIO) or a local HTTP endpoint to integrate SQL Server data into larger agent workflows (e.g., Claude Desktop or VS Code integrations).

Description

This project implements the Model Context Protocol (MCP) server for Microsoft SQL Server using Node.js. It auto-detects single- or multi-database configurations, exposes tables as resources, and provides tools to execute parameterized SQL queries and fetch schema metadata. The server can run in MCP (STDIO) mode for agent integrations or as an Express HTTP server for local testing, and includes Zod-based validation and safety checks to reduce SQL injection risk.

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

C55/100

10/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities0 Tools / 0 Prompts / 0 Resources

Ownermihai-dulgheru

CategoryData & Databases

DependenciesStandalone