mssql_mcp_server
pipStandardThe mssql_mcp_server allows AI agents to securely query, update, and manage Microsoft SQL Server databases. It provides tools for executing SQL commands, handling transactions, and managing connections. The server connects directly to MSSQL databases via the Microsoft SQL Server API. Developers use it to integrate SQL Server data operations into AI workflows, enabling automated database management and analytics.
57250Updated 10 months ago
Overview
The mssql_mcp_server allows AI agents to securely query, update, and manage Microsoft SQL Server databases. It provides tools for executing SQL commands, handling transactions, and managing connections. The server connects directly to MSSQL databases via the Microsoft SQL Server API. Developers use it to integrate SQL Server data operations into AI workflows, enabling automated database management and analytics.
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": {
"jexinsam-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
Read
Auto-transcribe meetings and generate action items
NetBox
Open-source network infrastructure documentation and automation
Baserow
The data collaboration platform for teams
GitHub
Let’s build from here, together
Snipe-IT
Open-source IT asset management made simple
Redouble AI
Human-in-the-loop AI workflows
Model ML
AI workspace for financial analysis and risk
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.