mcp-snowflake-servermcp-snowflake-server MCP server

— (0)

Reviewed by Daniel Nikulshyn·Updated July 2026

Overview

The mcp-snowflake-server is a Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake. It enables running SQL queries via tools and exposes data insights and schema context as resources. The server offers various tools for querying, schema management, and data analysis. It can be installed via Smithery or configured using UVX with individual parameters or a TOML configuration file. The server supports read and write operations, with optional features like data insights and prefetching of table schema summaries.

Key features

Query Tools: read_query, write_query, create_table
Schema Tools: list_databases, list_schemas, list_tables, describe_table
Analysis Tools: append_insight
Resources: memo://insights, context://table/{table_name}

Pricing

Model: Free
Category: MCP Servers
Rating: No reviews yet

Use cases

Data Analysis with Claude Desktop

Use the Snowflake MCP Server with Claude Desktop for data analysis, enabling users to run SQL queries and access data insights.

Automated Data Insights Generation

Utilize the append_insight tool to automatically generate and update data insights in the memo resource.

Pros & Cons

Pros

Enables SQL queries and data insights on Snowflake via tools
Exposes schema context and data insights as resources
Supports read and write operations with optional restrictions
Automatically updates data insights

Cons

Requires Snowflake account and credentials
Configuration can be complex with multiple options
Security considerations for private key and credentials management

Reviews

Sign in to leave a review.

No reviews yet. Be the first!

Q&A

What are the limitations?

The server requires a Snowflake account and credentials, and configuration can be complex with multiple options.

Asked by Ingrid Bauer · Feb 28, 2026

How is the server configured?

The server can be installed via Smithery or configured using UVX with individual parameters or a TOML configuration file.

Asked by Lior Ben-David · Jan 23, 2026

What are the key features?

The server offers query tools, schema tools, analysis tools, and resources like memo://insights and context://table/{table_name}.

Asked by Quentin Lefevre · Nov 25, 2025

What databases are supported?

The mcp-snowflake-server supports Snowflake database interaction.

Asked by Larisa Ionescu · Nov 17, 2025

Ask a question

MCP Servers alternatives

Playwright MCP interface preview

Playwright MCPMCP Servers

Open-source MCP server that lets LLMs drive real browsers via Playwright and accessibility snapshots.

Pydantic AI interface preview

Pydantic AIMCP Servers

Python agent framework from the Pydantic team for building type-safe GenAI apps.

Cognee interface preview

CogneeMCP Servers

Adaptive memory layer that helps AI agents learn from context over time.

Inbox Zero interface preview

Inbox ZeroMCP Servers

AI email assistant that organizes, drafts replies, and helps you reach inbox zero faster.

Screenpipe interface preview

ScreenpipeMCP Servers

Open-source 24/7 local screen and audio recording for building context-aware AI apps

AgentKit interface preview

AgentKitMCP Servers

TypeScript library for building and orchestrating AI agents with tools, memory, and multi-agent workflows.

onchain-mcpMCP Servers

Bringing the bankless onchain API to MCP

markitdownMCP Servers

Python tool for converting files and office documents to Markdown.