mssql-local-mcp

alorenco/mssql-local-mcp

3.1

If you are the rightful owner of mssql-local-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The MSSQL Local Database MCP Server is a specialized server designed to facilitate communication and operations with a local Microsoft SQL Server database using the Model Context Protocol (MCP).

MSSQL Local Database MCP Server

Prerequisites

  • Node.js 14 or higher

Set up project

  1. Install Dependencies
    Run the following command in the root folder to install all necessary dependencies:

    pnpm install
    
  2. Build the Project
    Compile the project by running:

    pnpm run build
    

Configuration Setup

{
   "mcpServers": {
      "mssql": {
      "command": "node",
      "args": [ "/home/[user]/mssql-local-mcp/dist/index.js" ],
      "env": {
         "SERVER_NAME": "127.0.0.1",
         "DATABASE_NAME": "master",
         "SQL_USERNAME": "user",
         "SQL_PASSWORD": "",
         "READONLY": "true"
      }
      }
   }
}