mcp-snowflake

yuly3/mcp-snowflake

3.3

If you are the rightful owner of mcp-snowflake and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A Model Context Protocol (MCP) server that connects to Snowflake databases and executes SQL queries.

Tools

Functions exposed to the LLM to take actions

list_schemas

Retrieve a list of schemas from a specified database.

list_tables

Retrieve a list of tables from a specified database and schema.

list_views

Retrieve a list of views from a specified database and schema.

describe_table

Retrieve detailed structure information for a specified table.

execute_query

Execute read-only SQL queries and return results.

sample_table_data

Retrieve sample data from a specified table using Snowflake's SAMPLE ROW clause.

analyze_table_statistics

Analyze table statistics using Snowflake's high-performance approximation functions.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources