Skip to main content
Glama

Snowflake MCP Server

by sfc-gh-tjia

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
SNOWFLAKE_ROLENoYour Snowflake role
SNOWFLAKE_SCHEMANoYour Snowflake schema
SNOWFLAKE_ACCOUNTNoYour Snowflake account identifier (e.g., abc12345.us-east-1.snowflakecomputing.com)
SNOWFLAKE_DATABASENoYour Snowflake database
SNOWFLAKE_MAX_ROWSNoMaximum number of rows to return from queries
SNOWFLAKE_PASSWORDNoYour Snowflake password
SNOWFLAKE_USERNAMENoYour Snowflake username
SNOWFLAKE_WAREHOUSENoYour Snowflake warehouse
SNOWFLAKE_AUTHENTICATORNoAuthentication method (e.g., externalbrowser for SSO)
SNOWFLAKE_PRIVATE_KEY_PATHNoPath to your RSA private key file (e.g., /path/to/rsa_key.p8)
SNOWFLAKE_PRIVATE_KEY_PASSPHRASENoPassphrase for the private key (optional)

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools

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/sfc-gh-tjia/snowflake-generic-mcp'

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