warp-sql-server-mcp
Verified Safeby egarcia74
Overview
An MCP server for SQL Server, enabling AI assistants to securely interact with databases for schema discovery, data retrieval, query execution, performance monitoring, and optimization.
Installation
npm startEnvironment Variables
- SQL_SERVER_HOST
- SQL_SERVER_PORT
- SQL_SERVER_DATABASE
- SQL_SERVER_USER
- SQL_SERVER_PASSWORD
- SQL_SERVER_DOMAIN
- SQL_SERVER_ENCRYPT
- SQL_SERVER_TRUST_CERT
- SQL_SERVER_READ_ONLY
- SQL_SERVER_ALLOW_DESTRUCTIVE_OPERATIONS
- SQL_SERVER_ALLOW_SCHEMA_CHANGES
- SQL_SERVER_CONNECT_TIMEOUT_MS
- SQL_SERVER_REQUEST_TIMEOUT_MS
- SQL_SERVER_MAX_RETRIES
- SQL_SERVER_RETRY_DELAY_MS
- SQL_SERVER_POOL_MAX
- SQL_SERVER_POOL_MIN
- SQL_SERVER_POOL_IDLE_TIMEOUT_MS
- SECRET_MANAGER_TYPE
- AWS_REGION
- AZURE_KEY_VAULT_URL
- SQL_SERVER_RESPONSE_FORMAT
- ENABLE_STREAMING
- STREAMING_BATCH_SIZE
- STREAMING_MAX_MEMORY_MB
- STREAMING_MAX_RESPONSE_SIZE
- ENABLE_PERFORMANCE_MONITORING
- SLOW_QUERY_THRESHOLD
- PERFORMANCE_SAMPLING_RATE
- MAX_METRICS_HISTORY
- TRACK_POOL_METRICS
- SQL_SERVER_LOG_LEVEL
- ENABLE_SECURITY_AUDIT
- LOG_FILE
- SECURITY_LOG_FILE
- SQL_SERVER_DEBUG
Security Notes
The server features a robust three-tier safety system with AST-based SQL query validation (using node-sql-parser) to detect dangerous functions (e.g., xp_cmdshell, openrowset) and potential SQL injection patterns. It supports cloud secret managers (AWS Secrets Manager, Azure Key Vault) for credential management, and provides context-aware SSL certificate handling that defaults to secure settings in production. Streaming functions include prototype pollution and size limit protection for JSON chunk processing. Comprehensive security audit logging and secure configuration defaults are also in place. The system errs on the side of security, requiring strong indicators for development environments to trust certificates.
Similar Servers
DBchat
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.
nlp2sql
Converting natural language queries to optimized SQL for enterprise databases using multiple AI providers.
mcp-server-db2i
Enables AI assistants to query and inspect IBM DB2 for i databases using the Model Context Protocol (MCP) via stdio or HTTP.
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.