mcp-sql-server
Verified Safeby shaharwiener
Overview
Provides AI assistants with safe, read-optimized access to SQL Server databases.
Installation
docker run -d --name mcp-sql-server -p 9303:9303 --env-file .env.local -e MCP_TRANSPORT=sse -e MCP_HOST=0.0.0.0 -e DB_CONN_MASTER='Driver={ODBC Driver 18 for SQL Server};Server=host.docker.internal;Database=master;Uid=sa;Pwd=YourStrong!Passw0rd;TrustServerCertificate=yes;LoginTimeout=30;' -e DB_CONN_LOCALDB='Driver={ODBC Driver 18 for SQL Server};Server=host.docker.internal;Database=LocalDB;Uid=sa;Pwd=YourStrong!Passw0rd;TrustServerCertificate=yes;LoginTimeout=30;' mcp-sql-server:latestEnvironment Variables
- DB_CONN_<NAME>
- DB_NAME
- DB_CONNECTION_STRING
Security Notes
The server has a strong security posture for its intended use case (internal VPN deployment). It strictly enforces read-only access, includes comprehensive input validation to prevent SQL injection and dangerous commands (xp_cmdshell, OPENROWSET), and uses robust audit logging with PII sanitization. Dangerous write operations (e.g., `execute_stored_procedure`) are explicitly disabled by default. Credentials for production are managed via AWS SSM. Known limitations like no application-level authentication, rate limiting, or fine-grained access control are clearly documented and deemed acceptable for internal VPN use, but make it unsuitable for external exposure without significant modification.
Similar Servers
dbhub
A universal database abstraction layer exposing databases as tools for AI/ML agents via the Model Context Protocol (MCP), and providing an admin console for monitoring requests.
teradata-mcp-server
This server provides a Model Context Protocol (MCP) interface for interacting with Teradata databases, offering tools for database administration, data quality, SQL optimization, feature store management, RAG (Retrieval Augmented Generation) workflows, vector store operations, plotting, and backup/restore, often used to enable AI agents or LLMs to perform database-related tasks.
mcp_ohmy_sql-project
A Model Context Protocol (MCP) server that connects AI assistants to various SQL databases, providing intelligent query optimization, schema introspection, and secure, token-efficient data interaction.
method-crm-mcp
Enables LLMs to interact with Method CRM data for comprehensive management of tables, files, user information, event-driven automations, and API keys.