MsSqlMCP
Verified Safeby jdlemes
Overview
Provides an MCP Server for SQL Server database schema inspection and safe, read-only query execution to AI clients.
Installation
dotnet runSecurity Notes
The project places a strong emphasis on security by implementing a ReadOnlySqlQueryValidator that blocks 27 common keywords associated with DML, DDL, DCL, and execution commands (e.g., INSERT, UPDATE, DELETE, DROP, EXEC). This validation is backed by 42 dedicated security tests. Connection strings are externalized in 'appsettings.json', preventing hardcoded secrets directly in the codebase. As long as the 'appsettings.json' is securely managed on the host, the application itself is designed to prevent malicious SQL operations.
Similar Servers
jewei-mssql-mcp-server
Provides a Micro-Agent Protocol (MCP) server for querying Microsoft SQL Server databases and retrieving table structures.
mssql-read-only-mcp
This server provides a lightweight, read-only interface for interacting with an MSSQL database, allowing users to list tables, describe their structure, and execute SELECT queries.
mssql-mcp-server
Provides an enterprise-grade Model Context Protocol server for Microsoft SQL Server, enabling schema discovery, data operations, profiling, and administration with strong governance controls.
mssql-mcp-server
Provides a Model Context Protocol (MCP) server for interacting with Microsoft SQL Server databases, supporting various SQL operations and connection methods.