Skip to main content
Glama

Snowflake MCP Server

by tushar3006

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
SNOWFLAKE_ROLENoYour Snowflake role
SNOWFLAKE_USERNoYour Snowflake username/email
SNOWFLAKE_SCHEMANoYour Snowflake schema name
SNOWFLAKE_ACCOUNTNoYour Snowflake account identifier
SNOWFLAKE_DATABASENoYour Snowflake database name
SNOWFLAKE_PASSWORDNoYour Snowflake password
SNOWFLAKE_WAREHOUSENoYour Snowflake warehouse name
SNOWFLAKE_AUTHENTICATORNoAuthentication method (e.g., 'externalbrowser' for external browser authentication)

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription
Data Insights MemoA living document of discovered data insights

Tools

Functions exposed to the LLM to take actions

NameDescription
list_databases

List all available databases in Snowflake

list_schemas

List all schemas in a database

list_tables

List all tables in a specific database and schema

describe_table

Get the schema information for a specific table

read_query

Execute a SELECT query.

append_insight

Add a data insight to the memo

fetch_violation_videos

Fetch video media for specific violation events. Returns simple list with DEVICE_EVENT_UUID and Region.

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/tushar3006/MCP'

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