warp-sql-server-mcp
Verified Safeby egarcia74
Overview
Enables AI assistants (like Warp Terminal or GitHub Copilot) to interact with Microsoft SQL Server databases using natural language queries, with a focus on enterprise-grade security, performance, and advanced database operations.
Installation
warp-sql-server-mcp 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
- SQL_SERVER_LOG_LEVEL
- ENABLE_SECURITY_AUDIT
- LOG_FILE
- SECURITY_LOG_FILE
- SQL_SERVER_DEBUG
- NODE_ENV
- VSCODE_MCP
Security Notes
The project demonstrates a strong commitment to security, featuring AST-based SQL query validation, explicit blocking of dangerous functions (e.g., xp_cmdshell), multi-provider secret management (env, AWS, Azure), streaming data security (prototype pollution, size limits), and a three-tier safety system (read-only, DML, DDL controls). It includes security audit logging and robust configuration validation with context-aware SSL certificate trust. The fallback regex validation is a minor residual risk, but overall, the implementation is top-tier for preventing common SQL vulnerabilities and ensuring secure operation.
Similar Servers
nlp2sql
Converts natural language queries to optimized SQL for enterprise-scale databases, supporting multiple AI providers and robust schema management.
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.
DatabaseMcpServer
Provides a robust and secure database access layer for AI assistants, supporting 19 types of databases with single-instance multi-database dynamic switching and over 50 tools for data and schema management.
Dynamic-Smart-MCP
An intelligent FastMCP 2 server that converts natural language questions into SQL queries or API requests for any SQL database or OpenAPI-defined API using AI.