MCP Snowflake Reader

MCPOpen SourceMIT8.7

by fnf-deepHeading • Data & Databases

A read-only MCP server that provides secure, cross-platform access to Snowflake databases with query caching and optimized connection testing.

Example Use Cases

1
Secure, read-only access to Snowflake data via the MCP protocol without exposing write permissions.
2
Reduce Snowflake compute costs by reusing cached query results for repeated or common queries.
3
Fast connection health checks to Snowflake without running actual queries or incurring compute usage.

Description

MCP Snowflake Reader exposes Snowflake databases over the MCP protocol, allowing clients to run read-only queries securely. It supports Windows, macOS, and Linux, includes query result caching to reduce Snowflake compute costs, and offers connection testing without executing queries. The server enforces read-only constraints and blocks risky SQL keywords to prevent data modification. It's distributed as an installable npm package and licensed under MIT.

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

D44/100

4/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities0 Tools / 0 Prompts / 0 Resources

Ownerfnf-deepHeading

CategoryData & Databases

DependenciesStandalone