ENV.example

# 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