Skip to main content
Glama
sfc-gh-tjia

Snowflake MCP Server

by sfc-gh-tjia
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Hybrid

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)

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{
  "listChanged": false
}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
execute_snowflake_sql_queryA
Execute any SQL query on Snowflake.

⚠️  SECURITY WARNING: This tool executes raw SQL queries on your Snowflake instance.
Ensure proper user permissions and network security. Consider query restrictions
for production environments.

Args:
    query: The SQL query to execute (required)
    database: Override the default database (optional)
    schema: Override the default schema (optional)
    warehouse: Override the default warehouse (optional)

Returns:
    Formatted string containing query results or error message

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Deploy Server
One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

TDQS

A3.7/5.0

Scored across 1 tool

Disambiguation5/5

With only one tool, there is no possibility of ambiguity or overlap between tools. The single tool has a clear and distinct purpose: executing SQL queries on Snowflake.

Naming Consistency5/5

The single tool name 'execute_snowflake_sql_query' follows a clear verb_noun pattern. Since there is only one tool, consistency is inherently perfect with no deviations or mixed conventions.

Tool Count2/5

A single tool for a Snowflake server feels too thin for the apparent scope, as it only provides raw SQL execution without any higher-level operations like listing tables, managing schemas, or handling data workflows. This is a borderline case leaning toward under-scoped.

Completeness2/5

The tool surface is severely incomplete for a Snowflake domain, lacking CRUD/lifecycle coverage. There are significant gaps such as no tools for browsing databases, tables, or schemas, and no support for common operations like data loading or user management, which will likely cause agent failures.

Resources