MSSQL

🚀 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.

Version Note: This project has been upgraded to use Model Context Protocol SDK 1.9.0. For more details, please refer to UPGRADE.md.

🚀 Quick Start

📦 Installation

Install via Smithery

Automatically install the MSSQL MCP Server for Claude Desktop using Smithery:

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

Manual Installation

npm install mssql-mcp-server

💻 Usage Examples

Basic 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 separate 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 SQL queries on the MSSQL database.

Parameters

• connectionString (string, optional): Full connection string (mutually exclusive with separate 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 the server certificate (default: true).

Either provide connectionString or (host + username + password).

Example

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

🚀 Running the Server

Local Development

# Install dependencies
npm install

# Run in development mode
npm run dev

# Build
npm run build

# Run the built server
npm start

Using Docker

# Build and start the service (SQL Server + MCP Server)
docker-compose up

# Or just build the Docker image
docker build -t mssql-mcp-server .

🧪 Testing

# Run tests
npm test

# Tests with coverage
npm run test:coverage

🔒 Security

The server includes security measures to prevent dangerous SQL operations:

• Block potentially harmful operations such as DROP, TRUNCATE, ALTER, CREATE, EXEC, etc.
• Validate the validity of all input parameters and database names.
• Set reasonable query length and timeout limits.
• Use a connection pool to improve performance and security.

📄 License

MIT