mssql mcp
StandardThe mssql MCP server enables AI agents to interact with Microsoft SQL Server databases. It provides tools for executing queries, managing tables, and handling transactions. The server connects directly to SQL Server instances via the TDS protocol. Developers use it to build AI-driven data analysis, reporting, and automation tools for SQL Server databases.
137170Updated 1 month ago
Overview
The mssql MCP server enables AI agents to interact with Microsoft SQL Server databases. It provides tools for executing queries, managing tables, and handling transactions. The server connects directly to SQL Server instances via the TDS protocol. Developers use it to build AI-driven data analysis, reporting, and automation tools for SQL Server databases.
Installation
1Install the package
2Add to Claude
Add this configuration to your claude_desktop_config.json:
claude_desktop_config.json
{
"mcpServers": {
"aaronontheweb-mssql-mcp-github": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-aaronontheweb-mssql-mcp-github"
]
}
}
}3Verify installation
Restart Claude Desktop, then ask:
"What tools do you have available from mssql mcp?"
Prerequisites
- Node.js 18 or higher
- npm or npx available
- Claude Desktop or Claude API access
- API key for mssql mcp
Configuration
API Key Required
This server requires an API key from mssql mcp. Add it to your environment or config.
| Variable | Required | Description |
|---|---|---|
| MSSQL_MCP_API_KEY | Yes | Your mssql mcp API key |
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.