mssql_mcp_server

MCP.Pizza Chef: RichardHan

Questions about company data get answered from the source instead of from a stale export: it shows which tables exist, runs the query, and reports back. Reading is not the limit — it can also insert, update, and delete rows, so give it a restricted database login if you only want it looking. Local SQL Server, LocalDB, and Azure SQL all work, with SQL, Windows, or Azure sign-in. No paid key. Last updated November 2025, about nine months ago.

Data

Spreadsheets

Use This MCP server To

Ask which customers ordered twice last month See what tables exist before I start a report Pull a quick count without opening a database tool Correct a handful of rows I know are wrong Query an Azure SQL database from my chat window

README

Microsoft SQL Server MCP Server

A Model Context Protocol (MCP) server for secure SQL Server database access through Claude Desktop.

Features

🔍 List database tables
📊 Execute SQL queries (SELECT, INSERT, UPDATE, DELETE)
🔐 Multiple authentication methods (SQL, Windows, Azure AD)
🏢 LocalDB and Azure SQL support
🔌 Custom port configuration

Quick Start

Install with Claude Desktop

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "mssql": {
      "command": "uvx",
      "args": ["microsoft_sql_server_mcp"],
      "env": {
        "MSSQL_SERVER": "localhost",
        "MSSQL_DATABASE": "your_database",
        "MSSQL_USER": "your_username",
        "MSSQL_PASSWORD": "your_password"
      }
    }
  }
}

mssql_mcp_server FAQ

Is this project still maintained?

Mostly idle. It is not archived and no replacement is named, but the last change was November 2025, roughly nine months ago, and recent work came from outside contributors rather than the author.

Do I need a paid key?

No. You supply the database sign-in details you already have — server name, database name, and either a username and password or your Windows account.

Can it change my data, or only read it?

It can add, change, and delete rows as well as read them. Create a dedicated login with read-only permission if you want it to look but not touch.

Does it work with Azure SQL?

Yes, alongside a SQL Server on your own machine or network, and LocalDB. Encryption is applied automatically for Azure.

Can I use this to answer a question about last quarter's sales?

Yes — you describe the question, it finds the relevant tables and runs the query, then explains the result in plain language.

How hard is setup?

Easy if you have the database details to hand. You paste a short block into Claude Desktop's settings with the server, database, username, and password.