| ILOSTAT_CATALOG_REFRESH_HOURS | No | Hours between checks of the ILOSTAT tables of contents (1–168). |
| ILOSTAT_MAX_ROWS | No | Ceiling on the rows one query may return or stage (1,000–1,000,000). |
| ILOSTAT_PREVIEW_CHARS | No | Inline preview budget in serialized characters; a larger query or comparison result is staged as a dataframe, and a dataframe SQL result returns only the leading rows that fit. |
| ILOSTAT_CACHE_TTL_SECONDS | No | Seconds a small upstream data response stays cached (0 disables the cache). |
| ILOSTAT_DATASET_TTL_SECONDS | No | Per-table TTL for staged dataframes, in seconds (at least 60). |
| ILOSTAT_DATAFRAME_DROP_ENABLED | No | Set to true to expose ilostat_dataframe_drop; staged dataframes otherwise expire on their TTL. |
| CANVAS_PROVIDER_TYPE | No | DataCanvas engine for staged dataframes: duckdb (default) or none to turn dataframes off. |
| MCP_LOG_LEVEL | No | Sets the minimum log level for output (e.g., 'debug', 'info', 'warn'). |
| MCP_TRANSPORT_TYPE | No | Selects the HTTP transport. |
| ILOSTAT_CATALOG_REFRESH_HOURS | No | Hours between checks of the ILOSTAT tables of contents (1–168). |
| ILOSTAT_MAX_ROWS | No | Ceiling on the rows one query may return or stage (1,000–1,000,000). |
| ILOSTAT_PREVIEW_CHARS | No | Inline preview budget in serialized characters; a larger query or comparison result is staged as a dataframe, and a dataframe SQL result returns only the leading rows that fit. |
| ILOSTAT_CACHE_TTL_SECONDS | No | Seconds a small upstream data response stays cached (0 disables the cache). |
| ILOSTAT_DATASET_TTL_SECONDS | No | Per-table TTL for staged dataframes, in seconds (at least 60). |
| ILOSTAT_DATAFRAME_DROP_ENABLED | No | Set to true to expose ilostat_dataframe_drop; staged dataframes otherwise expire on their TTL. |
| CANVAS_PROVIDER_TYPE | No | DataCanvas engine for staged dataframes: duckdb (default) or none to turn dataframes off. |
| MCP_HTTP_HOST | No | The hostname for the HTTP server. |
| MCP_HTTP_PORT | No | The port to run the HTTP server on. |
| MCP_HTTP_ENDPOINT_PATH | No | The endpoint path for the MCP server. |
| MCP_AUTH_MODE | No | Authentication mode to use: 'none', 'jwt', or 'oauth'. |
| MCP_LOG_LEVEL | No | Sets the minimum log level for output (e.g., 'debug', 'info', 'warn'). |