mssql_mcp_server
pipStandardA 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.
295840Updated 4 months ago
Overview
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.
Installation
1Install the package
pip
pip install mssql_mcp_server2Add to Claude
Add this configuration to your claude_desktop_config.json:
claude_desktop_config.json
{
"mcpServers": {
"richardhan-mssqlmcpserver-github": {
"command": "uvx",
"args": [
"pip install mssql_mcp_server"
]
}
}
}3Verify installation
Restart Claude Desktop, then ask:
"What tools do you have available from mssql_mcp_server?"
Prerequisites
- Python 3.10 or higher
- pip or uv package manager
- Claude Desktop or Claude API access
- API key for mssql_mcp_server
Configuration
API Key Required
This server requires an API key from mssql_mcp_server. Add it to your environment or config.
| Variable | Required | Description |
|---|---|---|
| MSSQL_MCP_SERVER_API_KEY | Yes | Your mssql_mcp_server API key |
Usage Examples
List Resources
"What resources are available in mssql_mcp_server?"
Claude will query available resources and return a list of what you can access.
Get Details
"Show me details about [specific item] in mssql_mcp_server"
Claude will fetch and display detailed information about the requested item.
Create New
"Create a new [item] in mssql_mcp_server with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
Works with mssql_mcp_server
Related skills
Browse all skillsNeed help with MCP integration?
We build custom MCP integrations for B2B companies. From simple connections to complex multi-tool setups.