C0h1b4 Mssql MCP Server

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

🚀 Quick Start

This section provides a brief overview of how to get started with the MSSQL MCP Server.

✨ Features

• Connect to Microsoft SQL Server databases.
• Execute SQL queries and manage database connections.
• Provide flexible configuration options for database connections.

📦 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"
      }
    }
  }
}

Advanced Usage

Tools - Query

Execute SQL queries on an MSSQL database.

Parameters

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',
  },
});

📚 Documentation

Development

# Install dependencies
npm install

# Run in development mode
npm run dev

# Build
npm run build

# Run tests
npm test

# Run code checks
npm run lint

# Format code
npm run format

📄 License

This project is licensed under the MIT License.