fde_sql_mcp
Verified Safeby mmcdermott-ashleyne
Overview
Provides an MCP server for programmatically interacting with on-prem SQL Server instances using Windows authentication, offering tools to enumerate database objects.
Installation
python -m fde_sql_mcp.serverEnvironment Variables
- SQL_SERVER_HOST
Security Notes
The server relies on Windows authentication (Trusted_Connection=yes) and explicitly externalizes SQL Server connection details to 'fde_sql_mcp.config.json' or environment variables, avoiding hardcoded secrets. All SQL queries used by the tools are fixed strings targeting system views ('sys.databases', 'sys.tables', etc.), which inherently mitigates SQL injection risks. The 'pyodbc' library is a standard and secure choice for database connectivity. 'TrustServerCertificate' is configurable. No 'eval' or obfuscation found.
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.
MsSqlMCP
Provides an MCP Server for SQL Server database schema inspection and safe, read-only query execution to AI clients.
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-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.