mssql_mcp_server MCP Server
RichardHan/mssql_mcp_server
[](https://agentrank-ai.com/tool/RichardHan--mssql_mcp_server/?utm_source=badge&utm_medium=readme&utm_campaign=agentrank_badge) 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.
claude mcp add agentrank -- npx -y agentrank-mcp-server 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 #8535 out of 24846 indexed tools.
Ecosystem
Score Breakdown
395 stars → growing community
Last commit 1y ago → stale
13/35 issues closed → many open issues
8 contributors → small team
No dependents → no downstream usage
527 weekly installs → early adoption
Weights: Freshness 20% · Issue Health 20% · Dependents 22% · Stars 10% · Contributors 8% · How we score →
How to Improve
Badge all embed codes →
[](https://agentrank-ai.com/tool/RichardHan--mssql_mcp_server/?utm_source=badge&utm_medium=readme&utm_campaign=agentrank_badge) <a href="https://agentrank-ai.com/tool/RichardHan--mssql_mcp_server/?utm_source=badge&utm_medium=readme&utm_campaign=agentrank_badge"><img src="https://agentrank-ai.com/api/v1/badge/RichardHan--mssql_mcp_server" alt="AgentRank"></a> Matched Queries
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 → Get the weekly AgentRank digest
Top movers, new tools, ecosystem insights — straight to your inbox.