Back to Home
egarcia74 icon

warp-sql-server-mcp

Verified Safe

by 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

Run Command
npm start

Environment 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

Stats

Interest Score33
Security Score9
Cost ClassMedium
Avg Tokens2000
Stars3
Forks2
Last Update2026-01-19

Tags

MCPSQL ServerAI IntegrationDatabase ToolsSecurityPerformance Monitoring