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
mssqlMCP
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.
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
Enterprise-grade Model Context Protocol server for Microsoft SQL Server, enabling AI tooling for schema discovery, data profiling, data operations, and administration in enterprise database workflows.
pg-mcp
Serves as a Model Context Protocol (MCP) server providing read-only PostgreSQL database access and introspection tools.