MSSQL MCP Server
BasicMSSQL MCP Server is designed for connecting to Microsoft SQL Server databases, providing tools for executing SQL queries and managing database connections. It supports both full connection strings and individual connection parameters for flexible usage.
000
Overview
MSSQL MCP Server is designed for connecting to Microsoft SQL Server databases, providing tools for executing SQL queries and managing database connections. It supports both full connection strings and individual connection parameters for flexible usage.
Installation
1Install the package
npx
npm install mssql-mcp-server2Add to Claude
Add this configuration to your claude_desktop_config.json:
claude_desktop_config.json
{
"mcpServers": {
"mssql-mcp-server": {
"command": "npx",
"args": [
"-y",
"npm install mssql-mcp-server"
]
}
}
}3Verify installation
Restart Claude Desktop, then ask:
"What tools do you have available from MSSQL MCP Server?"
Prerequisites
- Node.js 18 or higher
- npm or npx available
- 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 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
Microsoft Power Automate
Low-code workflow automation across Microsoft and 1,000+ apps
Microsoft Teams
Get more done every day with Microsoft Teams – powered by AI
Microsoft 365
Cloud-based productivity suite for businesses
Microsoft Dynamics 365
Enterprise CRM and ERP by Microsoft
Microsoft Bookings
Streamlined scheduling within Microsoft 365 ecosystem
Microsoft Fabric
SaaS platform for data and analytics use-cases.
Microsoft 365 Copilot
Inteligencia artificial para optimizar Microsoft 365
Microsoft Power Platform
Advanced technology for the benefit of people.
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.