Skip to main content
Glama

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MAX_ROWSNoMaximum rows returned per query1000
ALLOWED_TABLESNoOptional table-level allowlist (empty = all tables in allowed schemas)
MCP_STDIO_MODENoSet to ndjson for ndjson stdio mode
SNOWFLAKE_ROLEYesQuery execution role
SNOWFLAKE_USERYesService account username
ALLOWED_DOMAINSNoComma-separated CDM domains to exposeCDM_LMS,CDM_TLM,CDM_ALY
ALLOWED_SCHEMASNoComma-separated schemas for policy enforcement (should match domains)
SNOWFLAKE_ACCOUNTYesAccount identifier (URL prefix is stripped automatically)
SNOWFLAKE_DATABASEYesTarget database
SNOWFLAKE_PASSWORDYesService account password
DEFAULT_OUTPUT_MODENoauto, text, table, or vizauto
ENABLE_LEARN_SCHEMANoInclude LEARN schema (Premium only)false
SNOWFLAKE_WAREHOUSEYesCompute warehouse
ENABLE_PLANNER_PROBESNoPreflight SQL candidates for non-empty resultsfalse
MONTHLY_CREDIT_BUDGETNoMonthly Snowflake credit limit100
ENABLE_QUERY_EXECUTIONNoAllow SQL execution against Snowflakefalse
MAX_TEXT_SUMMARY_LENGTHNoMaximum summary text length1200
BUDGET_WARNING_THRESHOLDSNoWarning percentages70,85,100
STATEMENT_TIMEOUT_SECONDSNoSnowflake statement timeout120
ENABLE_PERSISTENT_FEEDBACKNoPersist planner feedback to diskfalse
REQUIRE_QUERY_CONFIRMATIONNoRequire approved=true per queryfalse
WAREHOUSE_CREDITS_PER_HOURNoFallback credit estimate rate0
DEFAULT_SESSION_APPROVAL_MODENoper-query or approve-allper-query
ENABLE_METADATA_INTROSPECTIONNoLoad schema from Snowflake instead of builtin catalogfalse

Capabilities

Server capabilities have not been inspected yet.

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/shurrey/illuminate-mcp-opensource'

If you have feedback or need assistance with the MCP directory API, please join our Discord server