MSSQL

About

The MSSQL tool functions as a Model Context Protocol (MCP) server specifically designed to interact with Microsoft SQL Server databases. It empowers applications to execute SQL queries, run stored procedures, and retrieve database connection details. With support for both Windows and SQL Server Authentication, and adaptable configuration via environment variables, it offers versatile deployment. It features two primary transport modes: a default Stdio transport for desktop clients and a streamable HTTP transport tailored for web-based applications and remote connections, complete with session management, Server-Sent Events, and advanced API key-based multi-database support utilizing Azure Table Storage.

Key Features

• Streamable HTTP transport with session management for web applications and remote connections
• Flexible configuration through environment variables and connection strings
• API Key-Based Connection Mapping for multi-database support via Azure Table Storage
• Support for Windows Authentication and SQL Server Authentication
• 0 GitHub stars
• Execute SQL queries and stored procedures against SQL Server databases

Use Cases

• Integrating SQL Server database operations with MCP clients like Claude Desktop
• Providing a robust HTTP API for web applications to interact with SQL Server
• Managing secure, multi-client access to different SQL Server databases using API keys