Skip to main content
Glama

Simple Snowflake MCP

by YannBrrd

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
LOG_LEVELNoOverride logging level (DEBUG, INFO, WARNING, ERROR, CRITICAL)
CONFIG_FILENoPath to custom configuration file (default: config.yaml)config.yaml
MCP_READ_ONLYNoSet to 'TRUE' for read-only mode (default: TRUE)TRUE
SNOWFLAKE_USERYesYour Snowflake username
SNOWFLAKE_SCHEMANoDefault schema (optional)
SNOWFLAKE_ACCOUNTYesYour Snowflake account identifier
SNOWFLAKE_DATABASENoDefault database (optional)
SNOWFLAKE_PASSWORDYesYour Snowflake password
SNOWFLAKE_WAREHOUSENoWarehouse name (optional)

Schema

Prompts

Interactive templates invoked by user choice

NameDescription
summarize-notesCreates a summary of all notes

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
execute-snowflake-sql

Execute a SQL query on Snowflake and return the result.

list-snowflake-warehouses

List available Data Warehouses (DWH) on Snowflake.

list-databases

List all accessible Snowflake databases.

list-views

List all views in a database and schema.

describe-view

Get details of a view (columns, SQL).

query-view

Query a view with an optional row limit (markdown result).

execute-query

Execute a SQL query in read-only mode (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH) or not (if 'read_only' is false), result in markdown format.

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/YannBrrd/simple_snowflake_mcp'

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