mssql mcp
pipStandardThe mssql MCP server allows AI agents to query, insert, update, and delete data in Microsoft SQL Server databases. It provides tools for executing SQL commands, managing connections, and handling transactions. It connects directly to MSSQL instances via the pyodbc library. Developers use it to build AI agents that automate database management tasks, generate reports, and perform data analysis.
39100Updated 9 months ago
Overview
The mssql MCP server allows AI agents to query, insert, update, and delete data in Microsoft SQL Server databases. It provides tools for executing SQL commands, managing connections, and handling transactions. It connects directly to MSSQL instances via the pyodbc library. Developers use it to build AI agents that automate database management tasks, generate reports, and perform data analysis.
Installation
1Install the package
pip
pip install mssql-mcp2Add to Claude
Add this configuration to your claude_desktop_config.json:
claude_desktop_config.json
{
"mcpServers": {
"daobataotie-mssql-mcp-github": {
"command": "uvx",
"args": [
"pip install mssql-mcp"
]
}
}
}3Verify installation
Restart Claude Desktop, then ask:
"What tools do you have available from mssql mcp?"
Prerequisites
- Python 3.10 or higher
- pip or uv package manager
- Claude Desktop or Claude API access
Configuration
No configuration required. This server works out of the box.
Usage Examples
List Resources
"What resources are available in mssql mcp?"
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"
Claude will fetch and display detailed information about the requested item.
Create New
"Create a new [item] in mssql mcp with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
Works with mssql mcp
See what tools in your stack can connect to AI.
Run free scan
Need help with MCP integration?
We build custom MCP integrations for B2B companies. From simple connections to complex multi-tool setups.