MSSQL On-Premises MCP Server

What it does

Enables AI models to interact with on-premises SQL Server instances. It removes cloud-specific dependencies (Azure AD), allowing direct connectivity to local databases using SQL Server authentication.

Tools

• ReadData: Execute SELECT queries to retrieve data
• InsertData: Add new records to tables
• UpdateData: Modify existing database records
• CreateTable: Define new table schemas
• CreateIndexTool: Optimize query performance with indexes
• DescribeTable: Get schema information for a specific table
• ListTable: List all tables in the current database

Installation

Add the following to your claude_desktop_config.json:

{
  "mcpServers": {
    "mssql-onpremises": {
      "command": "node",
      "args": ["C:/path/to/your/project/dist/index.js"],
      "env": {
        "SERVER_NAME": "localhost",
        "DATABASE_NAME": "your-database-name",
        "DB_USER": "your-sql-username",
        "DB_PASSWORD": "your-sql-password",
        "READONLY": "false",
        "TRUST_SERVER_CERTIFICATE": "true"
      }
    }
  }
}

Supported hosts

• Claude Desktop
• VS Code Copilot