# ClickHouse connection CLICKHOUSE_URL=http://localhost:8123 CLICKHOUSE_USER=default CLICKHOUSE_PASSWORD= CLICKHOUSE_DATABASE=default # Query cache TTL in milliseconds (default: 60000) CACHE_TTL_MS=60000 # Structured logging level: debug | info | warn | error (default: info) LOG_LEVEL=info # HTTP transport port (only used with --http flag) MCP_HTTP_PORT=3001 # Auth scoping (optional) — JSON mapping API keys to permission scopes # MCP_API_KEY=your-api-key # MCP_AUTH_SCOPES={"your-api-key":{"allowedTables":["events"],"maxRowLimit":500}}