mcp-snowflake-server

[](https://mseep.ai/app/isaacwasserman-mcp-snowflake-server)

---

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.

---

• `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.

---

The server exposes the following 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

• `list_databases`

List all databases in the Snowflake instance. Returns: Array of database names

• `list_schemas`

List all schemas within a specific database. Input:

• database (string): Name of the database

Returns: Array of schema names

• `list_tables`

List all tables within a specific database and schema. Input:

• database (string): Name of the database
• schema (string): Nam