RichardHan/mssql_mcp_server

Score: 36.2 Rank #3798

A Model Context Protocol (MCP) server for Microsoft SQL Server that enables secure database interactions through a controlled interface. Allows AI assistants to safely list tables, read data, and execute SQL queries while maintaining security and structure.

Overview

RichardHan/mssql_mcp_server is a Python MCP server licensed under MIT. A Model Context Protocol (MCP) server for Microsoft SQL Server that enables secure database interactions through a controlled interface. Allows AI assistants to safely list tables, read data, and execute SQL queries while maintaining security and structure.

Ranked #3798 out of 25632 indexed tools.

Ecosystem

Python MIT

Signal Breakdown

Stars 321

Freshness 4mo ago

Issue Health 52%

Contributors 8

Dependents 0

Forks 89

Description Detailed

License MIT

How to Improve

Freshness high impact

Last commit was 134 days ago — a recent commit would boost your freshness score

Dependents medium impact

No downstream dependents detected yet — adoption by other projects is the strongest trust signal

Badge

Markdown

[![AgentRank](https://agentrank-ai.com/api/badge/tool/RichardHan--mssql_mcp_server)](https://agentrank-ai.com/tool/RichardHan--mssql_mcp_server)

HTML

<a href="https://agentrank-ai.com/tool/RichardHan--mssql_mcp_server"><img src="https://agentrank-ai.com/api/badge/tool/RichardHan--mssql_mcp_server" alt="AgentRank"></a>

Details

Stars: 321
Forks: 89
Open Issues: 12
Closed Issues: 13
Contributors: 8
Dependents: —
Language: Python
License: MIT
Last Commit: 4mo ago

Matched Queries

"mcp server""mcp-server""model context protocol""model-context-protocol"

From the README

# Microsoft SQL Server MCP Server

<a href="https://glama.ai/mcp/servers/29cpe19k30">
  
</a>

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

## Features

- 🔍 List database tables
- 📊 Execute SQL queries (SELECT, INSERT, UPDATE, DELETE)
- 🔐 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`:

```json
{
  "mcpServers": {
    "mssql": {
      "command": "uvx",
      "args": ["microsoft_sql_server_mcp"],
      "env": {
        "MSSQL_SERVER": "localhost",
        "MSSQL_DATABASE": "your_database",
        "MSSQL_USER": "your_username",
        "MSSQL_PASSWORD": "your_password"
      }
    }
  }
}
```

## Configuration

### Basic SQL Authentication
```bash
MSSQL_SERVER=localhost          # Required
MSSQL_DATABASE=your_database    # Required
MSSQL_USER=your_username        #

Read full README on GitHub →

View on GitHub →

Are you the maintainer? Claim this listing