Microsoft SQL Server MCP

MCPOpen SourceMIT71.0

by RichardHan • Data & Databases

An MCP server that enables Claude Desktop agents to securely list tables and execute SQL queries against Microsoft SQL Server (including LocalDB and Azure SQL).

Example Use Cases

1
Query and retrieve table data from a Microsoft SQL Server database for analysis or report generation.
2
List database tables and schema to understand database structure before composing queries.
3
Perform authenticated, programmatic data modifications (INSERT/UPDATE/DELETE) against SQL Server using SQL, Windows, or Azure AD credentials.

Description

This MCP server provides a bridge between Claude Desktop and Microsoft SQL Server databases, allowing agents to list tables and run SELECT/INSERT/UPDATE/DELETE statements. It supports multiple authentication methods (SQL, Windows, Azure AD), LocalDB and Azure SQL, and configurable options like custom ports and enforced encryption. The project is distributed under an MIT license and can be installed via pip or run directly for local development.

Quick Actions

View on GitHub

Security

Scanned 3 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

D44/100

4/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

OwnerRichardHan

CategoryData & Databases

DependenciesStandalone