R
RichardHan/mssql_mcp_server
Query SQL Server through a limited interface
View on GitHub ↗Link checked 2026-11-12 · HTTP 200 · opens the vendor's own site
Install & config
Client config (built from the install command this repo gives)
{
"mcpServers": {
"richardhan-mssql-mcp-server": {
"command": "uvx",
"args": ["microsoftsqlservermcp"]
}
}
}Parsed from the README we fetched on 2026-11-04; we have not executed it.
command/args come from the install command the repository states. When it is ambiguous, the project README wins.
VS Code (.vscode/mcp.json - the key is servers)
{
"servers": {
"richardhan-mssql-mcp-server": {
"command": "uvx",
"args": ["microsoftsqlservermcp"]
}
}
}Same server, but VS Code keeps it under <code>servers</code>.
Claude Code (command line)
claude mcp add --transport stdio richardhan-mssql-mcp-server -- uvx microsoftsqlservermcp
Claude Code does not read a config file; add the server with this command.
Key names differ by client: Clients & CLI
- Source
- collected from the abordage/awesome-mcp list · type: MCP server
- Harvest history
- first seen 2026-11-05 · last seen 2026-11-14 · seen 10× · listed by 10 sources
- Score
- score 1,003 · 10 sources · mcp
- Install
uvx microsoftsqlservermcp
FAQ (answers come from our records)
How do I install it?
The repository provides this install command:
uvx microsoftsqlservermcp. It comes from the repository itself; we cannot guarantee it runs as-is in your client.Who is it for?
We filed it under these tags: MCP 服务. The tags come from the entry itself, not a taxonomy we imposed.
Who maintains it?
first catalogued 2026-11-05；last seen 2026-11-14。There is no official certification or quality rating here — we record sources and dates only.
# Microsoft SQL Server MCP Server
以下摘录自该仓库的 README（片段） · 在 GitHub 读完整 README →
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 claudedesktopconfig.json:
json
"mcpServers": {
"mssql": {
"command": "uvx",
"args": ["microsoftsqlservermcp"],
"env": {
"MSSQLSERVER": "localhost",
"MSSQLDATABASE": "yourdatabase",
"MSSQLUSER": "yourusername",
"MSSQLPASSWORD": "yourpassword"
## Configuration
### Basic SQL Authentication
bash
MSSQLSERVER=localhost # Required
MSSQLDATABASE=yourdatabase # Required
MSSQLUSER=yourusername # Required for SQL auth
MSSQLPASSWORD=yourpassword # Required for SQL auth
### Windows Authentication
bash
MSSQLSERVER=localhost
MSSQLDATABASE=yourdatabase
MSSQLWINDOWSAUTH=true # Use Windows credentials
### Azure SQL Database
bash
MSSQLSERVER=your-server.database.windows.net
MSSQLDATABASE=yourdatabase
MSSQLUSER=yourusername
MSSQLPASSWORD=yourpassword
# Encryption is automatic for Azure
### Optional Settings
bash
MSSQLPORT=1433 # Custom port (default: 1433)
MSSQLENCRYPT=true # Force encryption
## Alternative Installation Methods
### Using pip
bash
pip install microsoftsqlservermcp
Then in claudedesktopconfig.json:
json
"mcpServers": {
"mssql": {
"command": "python",
"args": ["-m", "mssqlmcpserver"],
"env": { ... }
### Development
bash
git clone https://github.com/RichardHan/mssqlmcpserver.git
cd mssqlmcpserver
pip install -e .
## Security
Create a dedicated SQL user with minimal permissions
Never use admin/sa accounts
Use Windows Authentication when possible
Enable encryption for sensitive data
## License
MIT
## 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 claudedesktopconfig.json:
json
"mcpServers": {
"mssql": {
"command": "uvx",
"args": ["microsoftsqlservermcp"],
"env": {
"MSSQLSERVER": "localhost",
"MSSQLDATABASE": "yourdatabase",
"MSSQLUSER": "yourusername",
"MSSQLPASSWORD": "yourpassword"
## Configuration
### Basic SQL Authentication
bash
MSSQLSERVER=localhost # Required
MSSQLDATABASE=yourdatabase # Required
MSSQLUSER=yourusername # Required for SQL auth
MSSQLPASSWORD=yourpassword # Required for SQL auth
### Windows Authentication
bash
MSSQLSERVER=localhost
MSSQLDATABASE=yourdatabase
MSSQLWINDOWSAUTH=true # Use Windows credentials
### Azure SQL Database
bash
MSSQLSERVER=your-server.database.windows.net
MSSQLDATABASE=yourdatabase
MSSQLUSER=yourusername
MSSQLPASSWORD=yourpassword
# Encryption is automatic for Azure
### Optional Settings
bash
MSSQLPORT=1433 # Custom port (default: 1433)
MSSQLENCRYPT=true # Force encryption
## Alternative Installation Methods
### Using pip
bash
pip install microsoftsqlservermcp
Then in claudedesktopconfig.json:
json
"mcpServers": {
"mssql": {
"command": "python",
"args": ["-m", "mssqlmcpserver"],
"env": { ... }
### Development
bash
git clone https://github.com/RichardHan/mssqlmcpserver.git
cd mssqlmcpserver
pip install -e .
## Security
Create a dedicated SQL user with minimal permissions
Never use admin/sa accounts
Use Windows Authentication when possible
Enable encryption for sensitive data
## License
MIT
Listed badge (optional)
Copy this line into the README if you want the listing mark. Optional, and it does not affect being listed.
[](https://anclum.com/en/s/richardhan-mssql-mcp-server/)
- Source
- awesome · https://github.com/RichardHan/mssql_mcp_server
- Browse by field
- MCP servers
- Listed by
- 10 independent sources
- added
- today
More like this
Filed under
Every tag opens the full list for that filter. Counts are the live catalogue figures.