Happy slice of mcp pizzaMCP.pizza

mssql-mcp-server

MCP.Pizza Chef: c0h1b4

The mssql-mcp-server is a Model Context Protocol server designed to connect with Microsoft SQL Server databases. It enables executing SQL queries and managing database connections within MCP-enabled environments, facilitating real-time database interactions for LLMs. This server supports seamless integration with MCP clients and is installable via Smithery or npm, providing a robust interface for database-driven AI workflows.

Unmaintained · No commits in 15 months.

Use This MCP server To

Execute SQL queries on Microsoft SQL Server databases Manage database connections within MCP workflows Integrate SQL Server data into LLM-powered applications Enable real-time database querying for AI agents Automate data retrieval and updates via natural language Support multi-step reasoning involving database state Facilitate secure and scoped database access for models

README

MSSQL MCP Server

smithery badge

A Model Context Protocol (MCP) server for connecting to Microsoft SQL Server databases. This server provides tools for executing SQL queries and managing database connections.

Version Notice: This project has been upgraded to use Model Context Protocol SDK 1.9.0. See UPGRADE.md for details.

Installation

Installing via Smithery

To install MSSQL MCP Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install @c0h1b4/mssql-mcp-server --client claude

Manual Installation

npm install mssql-mcp-server

Usage

Add the server to your MCP settings configuration file:

mssql-mcp-server FAQ

How do I install the mssql-mcp-server?
You can install it automatically via Smithery CLI or manually using npm install mssql-mcp-server.
How do I configure the mssql-mcp-server?
Add the server to your MCP settings configuration file with the appropriate MSSQL_CONNECTION_STRING environment variable.
Can the mssql-mcp-server handle multiple database connections?
Yes, it supports managing multiple connections through configuration.
Is the mssql-mcp-server compatible with different MCP clients?
Yes, it is designed to work with any MCP client supporting the protocol, including Claude Desktop.
Does the mssql-mcp-server support secure database access?
Yes, it supports scoped and secure access to databases as per MCP principles.
What version of the MCP SDK does mssql-mcp-server use?
It uses Model Context Protocol SDK version 1.9.0.
Can I use mssql-mcp-server with LLM providers like OpenAI, Claude, or Gemini?
Yes, it integrates with MCP clients that can connect to these LLM providers for enhanced database querying.