Happy slice of mcp pizzaMCP.pizza

mcp-snowflake-server

MCP.Pizza Chef: isaacwasserman

Six tools arrive switched on: list the databases and tables you can see, describe a table's columns, run a look-up query, and save a finding to a running notes memo. Two more that insert, update, delete or create tables only appear if you start it with the write flag, and the reading tool refuses anything that would change data. Snowflake is a paid platform, so every question burns credits, and your account username and password sit in plain text inside your assistant's settings file. The last code change was October 2025.

Data

Use This MCP server To

Ask which tables hold our customer records Pull last quarter's sales figures without writing SQL myself Have a table's columns explained before I use it Collect findings from a data review into one running memo Check how many rows a table actually contains

README

MseeP.ai Security Assessment Badge

Snowflake MCP Server

Overview

A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake. This server enables running SQL queries via tools and exposes data insights and schema context as resources.

Components

Resources

  • memo://insights
    A continuously updated memo aggregating discovered data insights.
    Updated automatically when new insights are appended via the append_insight tool.

  • context://table/{table_name}
    (If prefetch enabled) Per-table schema summaries, including columns and comments, exposed as individual resources.

Tools

The server exposes the following tools:

Query Tools

  • read_query
    Execute SELECT queries to read data from the database.
    Input:

    • query (string): The SELECT SQL query to execute
      Returns: Query results as array of objects

  • write_query (enabled only with --allow-write)
    Execute INSERT, UPDATE, or DELETE queries.
    Input:

    • query (string): The SQL modification query
      Returns: Number of affected rows or confirmation

  • create_table (enabled only with --allow-write)
    Create new tables in the database.
    Input:

    • query (string): CREATE TABLE SQL statement
      Returns: Confirmation of table creation

mcp-snowflake-server FAQ

Do I need an API key?
No, but you do need real Snowflake account credentials: your username plus either your account password or a private key file. A browser sign-in option exists too. Whichever you pick lives in your assistant's settings file.
Can it change or delete my data?
Not unless you turn that on. Out of the box only the reading tools appear, and the reading tool rejects any query that would insert, update, delete or drop anything. Start it with the write flag and two editing tools appear.
Does it cost money to run?
Yes, indirectly. Snowflake charges for compute, so every question your assistant asks wakes up your warehouse and spends credits. An over-enthusiastic assistant can run up a real bill.
Can I use this to answer a question about last quarter's sales?
Yes. Ask in plain language and it will find the right tables, check the columns, and run the look-up for you without you writing any SQL.
How do I switch writing on?
Add --allow_write to the launch arguments, spelled with an underscore. One line of the readme writes it with a hyphen instead, and that version will not be recognised.
Can I hide sensitive tables from it?
Yes. A separate settings file lets you exclude whole databases or individual tables by pattern, so it never sees them at all.
Which apps does it work in?
Claude Desktop is the documented one, and anything else that can launch a local command will work the same way.
Is it still maintained?
Only quietly. The last code change was October 2025, about ten months ago. Nothing has been marked abandoned and no replacement is named.