Skip to main content
Glama

MSSQL MCP Server

by Nirmal123K
npmGitHub
TypeScript
54
  • Apple
  • Linux
OverviewInspectNewEndpointsSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

MSSQL MCP Server

License: MIT TypeScript Node.js

A Model Context Protocol (MCP) server that enables AI assistants to interact with both local SQL Server and Azure SQL Database through natural language.

🚀 What Makes This Special?

This MCP server solves a critical limitation of existing solutions by supporting both local SQL Server and Azure SQL Database connections. While the original Azure-Samples implementation only works with Azure SQL Database, this enhanced version enables:

  • 🏠 Local Development: Connect to local SQL Server instances using username/password authentication

  • ☁️ Azure Cloud: Full Azure SQL Database support with Azure AD authentication

  • 🔄 Seamless Switching: Use the same tools for both environments

Quick Example:

You: "Show me all customers from New York" AI: *securely queries your database and returns results in plain English* You: "Create a table for storing product reviews" AI: *generates and executes the appropriate CREATE TABLE statement*

📦 Quick Start

Prerequisites

  • Node.js 18+

  • SQL Server (local) or Azure SQL Database

  • AI Assistant: Claude Desktop or VS Code Agent

Installation

git clone https://github.com/Nirmal123K/mssql-mcp.git cd mssql-mcp-server npm install && npm run build

Configuration

Local SQL Server:

export SERVER_NAME="localhost" export DATABASE_NAME="your_database" export SQL_USER="your_username" export SQL_PASSWORD="your_password" export TRUST_SERVER_CERTIFICATE="true"

Azure SQL Database:

export SERVER_NAME="your-server.database.windows.net" export DATABASE_NAME="your_database" # Uses Azure AD authentication (run 'az login' first)

⚙️ AI Assistant Setup

Claude Desktop

Add to claude_desktop_config.json:

Local SQL Server:

{ "mcpServers": { "mssql": { "command": "node", "args": ["/path/to/mssql-mcp-server/dist/index.js"], "env": { "SERVER_NAME": "localhost", "DATABASE_NAME": "your_database", "SQL_USER": "your_username", "SQL_PASSWORD": "your_password", "TRUST_SERVER_CERTIFICATE": "true" } } } }

Azure SQL Database:

{ "mcpServers": { "mssql": { "command": "node", "args": ["/path/to/mssql-mcp-server/dist/index.js"], "env": { "SERVER_NAME": "your-server.database.windows.net", "DATABASE_NAME": "your_database", "READONLY": "true" } } } }

VS Code Agent

Create .vscode/mcp.json with similar configuration using "type": "stdio".

Config Locations:

  • macOS: ~/Library/Application Support/Claude/claude_desktop_config.json

  • Windows: %APPDATA%\Claude\claude_desktop_config.json

📋 Environment Variables

Variable

Required

Description

Example

SERVER_NAME

✅

SQL Server hostname

localhost

or

server.database.windows.net

DATABASE_NAME

✅

Target database name

MyDatabase

SQL_USER

🔄

Username (local SQL Server only)

sa

or

myuser

SQL_PASSWORD

🔄

Password (local SQL Server only)

MyPassword123!

READONLY

❌

Restrict to read-only operations

true

or

false

(default)

TRUST_SERVER_CERTIFICATE

❌

Trust self-signed certificates

true

or

false

(default)

🔄 = Required for local SQL Server, not needed for Azure SQL Database

✅ Verification

# Test the MCP server echo '{"jsonrpc": "2.0", "id": 1, "method": "tools/list"}' | node dist/index.js

🛠️ Available Tools

Tool

Purpose

Example

read_data

Query data with SELECT

"Show customers from New York"

insert_data

Add new records

"Insert new product with price $99"

update_data

Modify existing data

"Update order status to shipped"

create_table

Create new tables

"Create table for reviews"

create_index

Add database indexes

"Create index on customer email"

drop_table

Remove tables

"Drop temporary table"

list_tables

Show all tables

"What tables exist?"

describe_table

Show table structure

"Describe customers table"

Security Features:

  • ✅ SQL injection prevention

  • ✅ Query validation and sanitization

  • ✅ Required WHERE clauses for updates

  • ✅ Read-only mode support

📚 Documentation

For detailed information, see our comprehensive guides:

� Credits and Attribution

Original Work

This project is a fork of the Azure-Samples/SQL-AI-samples repository, specifically building upon the MssqlMcp implementation created by Microsoft and the Azure team.

  • Original Repository: Azure-Samples/SQL-AI-samples

  • Original Authors: Microsoft Corporation and the Azure team

  • Original License: MIT License

  • Original Focus: Azure SQL Database with Azure AD authentication

Key Enhancement

This fork extends the original Azure-only MCP server to support local SQL Server databases with username/password authentication, making it accessible for:

  • 🏠 Local Development: Connect to local SQL Server instances

  • 🏢 On-Premises Deployments: Support enterprise SQL Server installations

  • 🔄 Hybrid Environments: Seamlessly switch between local and Azure databases

  • 🚀 Broader Accessibility: Remove Azure dependency for local development

What We Added

Feature

Original Repository

This Fork

Azure SQL Database

✅ Azure AD only

✅ Azure AD support

Local SQL Server

❌ Not supported

✅ Username/password auth

Authentication Methods

1 (Azure AD)

3 (Azure AD, SQL Server, Windows)

Target Audience

Azure users only

Local + Azure + On-premises

Development Setup

Requires Azure account

Works with local SQL Server

Acknowledgments

We are deeply grateful to Microsoft and the Azure team for creating the foundational architecture, security implementation, and tool design that made this enhanced version possible.

This enhanced version would not exist without their excellent foundational work.

License: MIT License - see LICENSE file for details.

Deploy Server
-
security - not tested
F
license - not found
-
quality - not tested

How are these scores calculated?

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

Tools

Enables AI assistants to interact with both local SQL Server and Azure SQL Database through natural language, supporting queries, data manipulation, and schema operations with built-in security features.

  1. 🚀 What Makes This Special?
    1. 📦 Quick Start
      1. Prerequisites
      2. Installation
      3. Configuration
    2. ⚙️ AI Assistant Setup
      1. Claude Desktop
      2. VS Code Agent
    3. 📋 Environment Variables
      1. ✅ Verification
        1. 🛠️ Available Tools
          1. 📚 Documentation
            1. � Credits and Attribution
              1. Original Work
              2. Key Enhancement
              3. What We Added
              4. Acknowledgments

            New MCP Servers

            MCP directory API

            We provide all the information about MCP servers via our MCP API.

            curl -X GET 'https://glama.ai/api/mcp/v1/servers/Nirmal123K/mssql-mcp'

            If you have feedback or need assistance with the MCP directory API, please join our Discord server