Skip to main content
Glama

Simple Snowflake MCP

by YannBrrd

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MCP_READ_ONLYNoOptional: true/false to force read-only mode
SNOWFLAKE_USERYesSnowflake username
SNOWFLAKE_SCHEMANoOptional: default schema name
SNOWFLAKE_ACCOUNTYesSnowflake account identifier
SNOWFLAKE_DATABASENoOptional: default database name
SNOWFLAKE_PASSWORDYesSnowflake password
SNOWFLAKE_WAREHOUSENoOptional: Snowflake warehouse name

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