MSSQL MCP Server

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.

Installation

Installing via Smithery

To install MSSQL Database Connector for Claude Desktop automatically via Smithery:

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

Manual Installation

npm install mssql-mcp-server

Usage

Add the server to your MCP settings configuration file:

{
  "mcpServers": {
    "mssql": {
      "command": "mssql-mcp-server",
      "env": {
        "MSSQL_CONNECTION_STRING": "Server=localhost;Database=master;User Id=sa;Password=yourpassword;",
        // Or individual connection parameters:
        "MSSQL_HOST": "localhost",
        "MSSQL_PORT": "1433",
        "MSSQL_DATABASE": "master",
        "MSSQL_USER": "sa",
        "MSSQL_PASSWORD": "yourpassword",
        "MSSQL_ENCRYPT": "false",
        "MSSQL_TRUST_SERVER_CERTIFICATE": "true"
      }
    }
  }
}

Tools

query

Execute a SQL query on a MSSQL database.

Parameters

connectionString (string, optional): Full connection string (alternative to individual parameters)
host (string, optional): Database server hostname
port (number, optional): Database server port (default: 1433)
database (string, optional): Database name (default: master)
username (string, optional): Database username
password (string, optional): Database password
query (string, required): SQL query to execute
encrypt (boolean, optional): Enable encryption (default: false)
trustServerCertificate (boolean, optional): Trust server certificate (default: true)

Either connectionString OR (host + username + password) must be provided.

Example

const result = await use_mcp_tool({
  server_name: 'mssql',
  tool_name: 'query',
  arguments: {
    host: 'localhost',
    username: 'sa',
    password: 'yourpassword',
    query: 'SELECT * FROM Users',
  },
});

Development

# Install dependencies
npm install

# Run in development mode
npm run dev

# Build
npm run build

# Run tests
npm test

# Run linter
npm run lint

# Format code
npm run format

License

MIT

Install Server

HTTP connection URL

security – no known vulnerabilities

license - permissive license

quality - confirmed to work

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

query

A Model Context Protocol server that enables executing SQL queries and managing connections with Microsoft SQL Server databases.

Related MCP Servers

MSSQL MCP Server
c0h1b4
A
security
A
license
A
quality
Enables execution of SQL queries and management of Microsoft SQL Server database connections through the Model Context Protocol.
Last updated -
29
121
14
TypeScript
MIT License
MSSQL MCP Server
JexinSam
-
security
A
license
-
quality
A Model Context Protocol server that enables secure and structured interaction with Microsoft SQL Server databases, allowing AI assistants to list tables, read data, and execute SQL queries with controlled access.
Last updated -
39
Python
MIT License
MySQL-MCP
zajTools
-
security
F
license
-
quality
A Model Context Protocol server that enables SQL query execution, database management, and business intelligence capabilities through MySQL connections.
Last updated -
JavaScript
MSSQL MCP Server
jensenloke
-
security
F
license
-
quality
A Model Context Protocol server that provides comprehensive access to Microsoft SQL Server databases, enabling Language Models to inspect schemas, execute queries, manage database objects, and perform advanced database operations.
Last updated -
6
Python

View all related MCP servers

MSSQL MCP Server

MSSQL MCP Server

Installation

Installing via Smithery

Manual Installation

Usage

Tools

query

Parameters

Example

Development

License

Tools

Related MCP Servers

MSSQL MCP Server

MSSQL MCP Server

MySQL-MCP

MSSQL MCP Server

Appeared in Searches

New MCP Servers

MCP directory API