mssqlMCP

Name: mssqlMCP
Author: MCPRUNNER

Verified Safe

by MCPRUNNER

View Source

Overview

The SQL Server MCP (Model Context Protocol) Server enables AI assistants like GitHub Copilot within Visual Studio Code to interact with SQL Server databases, allowing for SQL query execution, detailed database metadata retrieval, and management of connections and security.

Installation

Run Command

docker run -d --name mssqlmcp -p 3001:3001 -e MSSQL_MCP_KEY="StrongEncryptionKeyForEncryptionOfYourConnectionStrings" -e MSSQL_MCP_API_KEY="StrongApiKeyYourConnections" -v "$(pwd)/data:/app/Data" -v "$(pwd)/logs:/app/Logs" mcprunner/mssqlmcp;

Environment Variables

MSSQL_MCP_KEY
MSSQL_MCP_API_KEY
MSSQL_MCP_DATA
ASPNETCORE_ENVIRONMENT
ASPNETCORE_URLS
MSSQL_MCP_TRANSPORT

Security Notes

The project implements robust security features, including AES-256 encryption for connection strings, multi-tier API key authentication with role-based access control and connection-level restrictions, and comprehensive input validation to prevent SQL injection and dangerous commands. Encryption keys and API keys are managed via environment variables and scripts to avoid hardcoding. While the server defaults to HTTP, the documentation explicitly recommends HTTPS for production environments, which would require an external reverse proxy. Regular key rotation and monitoring are also advised for optimal security.

Similar Servers

mcp

155

Enables AI models (LLMs) to interact with a Neo4j graph database by providing a structured set of tools via the Model Context Protocol (MCP).

Other

$Medium

dbt-core-mcp

A Model Context Protocol (MCP) server that empowers AI assistants (like Copilot) to interact with and manage dbt projects. It enables natural language control over dbt operations, providing project metadata, lineage, impact analysis, SQL query execution, and intelligent build/test workflows, all while respecting the user's local dbt environment.

Other

$Medium