SQL MCP Server

# SQL-MCP example env # Database (required) SQL_MCP_DB_TYPE=mysql SQL_MCP_DB_HOST=127.0.0.1 SQL_MCP_DB_PORT=3306 SQL_MCP_DB_USER=root SQL_MCP_DB_PASSWORD=changeme SQL_MCP_DB_NAME=mydb SQL_MCP_DB_TIMEOUT=10000 # Cache (optional) SQL_MCP_CACHE_ENABLED=true SQL_MCP_CACHE_TTL=3600 SQL_MCP_CACHE_STORAGE=memory # SQL_MCP_CACHE_FILE_PATH=./cache # Prewarm metadata cache on startup (fetch table list in background) SQL_MCP_CACHE_PREWARM_ON_START=true # Logging (optional) SQL_MCP_LOG_LEVEL=info SQL_MCP_LOG_DESTINATION=console # SQL_MCP_LOG_FILE_PATH=./logs/sql-mcp.log # MCP transport SQL_MCP_MCP_TRANSPORT=http SQL_MCP_MCP_HTTP_PORT=3000 # Output / Stdio presets # Safer stdio mode: compact output, stricter limits, suppress info/debug to stdout SQL_MCP_MCP_STDIO_SAFE=false # Compact markdown tables for stdio SQL_MCP_MCP_STDIO_COMPACT=false # Only emit JSON content (no markdown text) SQL_MCP_OUTPUT_JSON_ONLY=false # Query result max rows (pagination cap for executeQuery) SQL_MCP_SECURITY_QUERY_MAX_ROWS=200