Snowflake

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:\n\n#### 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\n\n#### Schema Tools
• 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): Name of the schema Returns: Array of table metadata
• describe_table View column information for a specific table. Input: - table_name (string): Fully qualified table name (database.schema.table) Returns: Array of column definitions with names, types, nullability, defaults, and comments\n\n#### Analysis Tools
• append_insight Add new data insights to the memo resource. Input: - insight (string): Data insight discovered from analysis Returns: Confirmation of insight addition Effect: Triggers update of memo://insights resource

Usage with Claude Desktop# Installing via Smithery

To install Snowflake Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install mcp_snowflake_server --client claude