Claude MarketplacesSubmit
richardhan avatar

Microsoft SQL Server

richardhan/mssql_mcp_server

The Mssql_mcp_server provides Claude Desktop with secure access to Microsoft SQL Server databases through tools for listing tables and executing SQL queries (SELECT, INSERT, UPDATE, DELETE). It supports multiple authentication methods including SQL authentication, Windows authentication, and Azure AD, while accommodating LocalDB, on-premises, and Azure SQL deployments with configurable ports and encryption options. This server solves the problem of enabling AI assistants to directly query and manipulate SQL Server databases in a controlled, secure manner.

GitHub stars
345
tools
2
last updated
Dec 15, 2025
View on GitHub

Tools

2 tools

Public tool metadata for what this MCP can expose to an agent.

queryRead-only tool that accepts a single SELECT / WITH / set-operation statement (default mode).

Read-only tool that accepts a single SELECT / WITH / set-operation statement (default mode).

No parameter schema in public metadata yet.

execute_sqlExposed when MSSQL_ALLOW_WRITES=1 is set, allowing INSERT/UPDATE/DELETE writes.

Exposed when MSSQL_ALLOW_WRITES=1 is set, allowing INSERT/UPDATE/DELETE writes.

No parameter schema in public metadata yet.

Sponsors

Promote your product hereReach 125k+ visitors monthlyPromote your product hereReach 125k+ visitors monthlyAgent CaffeineSponsoredClose your lid, come back to finished workSnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthlyWaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthlyknobsSponsoredSee your site on any phone, any day, in any language

Readme

Microsoft SQL Server MCP Server

PyPI License: MIT

Microsoft SQL Server MCP server

A Model Context Protocol (MCP) server for secure SQL Server database access through Claude Desktop.

Features

  • 🔍 List database tables
  • 📊 Execute SQL queries (read-only by default; optional write mode)
  • 🔐 Multiple authentication methods (SQL, Windows, Azure AD)
  • 🏢 LocalDB and Azure SQL support
  • 🔌 Custom port configuration

Quick Start

Install with Claude Desktop

Add to your claude_desktop_config.json:

View the full README on GitHub

Details

Repository
github.com/richardhan/mssql_mcp_server
Categories
Databases, Security & Pentesting

Related Databases MCP servers

View all
1cr7258 avatarElasticsearch Mcp Servercr7258/elasticsearch-mcp-serverMCP server for interacting with Elasticsearch289stars
2tocharianou avatarElasticsearchtocharianou/elasticsearch-mcpElasticsearch MCP Server for ES 5.x-9.x with a query harness, field validation and full API access8stars
3timescale avatarTiger Skillstimescale/tiger-skills-mcp-serverProvider agnostic skills implementation, with skills sourced from local paths or GitHub repositories7stars
4neverinfamous avatarMysql Mcpneverinfamous/mysql-mcpEnterprise-grade MySQL MCP Server with OAuth 2.0, 106 tools, and Docker deployment5stars
5marcelo-ochoa avatarMysqlmarcelo-ochoa/serversAn MCP server for MySQL databases.0stars
6yawlabs avatarRedis MCP Serveryawlabs/redis-mcpRead-first Redis MCP: SCAN key explorer, keyspace/TTL/memory/slowlog stats, DBA advisor2stars