dataopslive/mcp-snowflake-server
If you are the rightful owner of mcp-snowflake-server 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.
The Snowflake MCP Server is a Model Context Protocol server implementation that facilitates database interaction with Snowflake, enabling SQL query execution and data insights exposure.
Tools
Functions exposed to the LLM to take actions
read_query
Execute SELECT queries to read data from the database.
write_query
Execute INSERT, UPDATE, or DELETE queries.
create_table
Create new tables in the database.
list_databases
List all databases in the Snowflake instance.
list_schemas
List all schemas within a specific database.
list_tables
List all tables within a specific database and schema.
describe_table
View column information for a specific table.
append_insight
Add new data insights to the memo resource.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client