MCP Snowflake Reader

MCPOpen SourceMIT16.5

by fnf-deepHeading • Data & Databases

A read-only MCP server that provides secure, read-only access to Snowflake databases for agents and clients.

Example Use Cases

1
Read-only access to Snowflake tables to fetch data for analysis or context without risk of modifying the database.
2
Run safe, restricted SQL queries (SELECTs only) against Snowflake via the MCP protocol using Docker or UVX deployments.
3
A lightweight connector to integrate Snowflake data into LLM-based workflows while enforcing table-name and SQL keyword restrictions.

Description

MCP Snowflake Reader exposes Snowflake databases over the MCP protocol in a secure, read-only manner. It accepts Snowflake connection details as a JSON string and can be run via Docker or UVX; it also provides a Smithery installer entry. The server enforces read-only restrictions and forbids dangerous SQL keywords, helping agents safely query table data without risking modifications.

Capabilities(2 total)

Tools (1)

query

Executes a read-only SQL query against the Snowflake database. Args: sql: SQL query string to execute (must be read-only) Returns: Query results as a JSON-formatted string Note: This function is restricted to read-only operations for security

sql:string*

Resources (1)

list_tables

Returns a list of all tables in the connected Snowflake database. The result is formatted as a JSON string containing table information.

URI: snowflake://tablesMIME: text/plain

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

C56/100

6/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

Capabilities1 Tools / 0 Prompts / 1 Resources

Ownerfnf-deepHeading

CategoryData & Databases

DependenciesStandalone

Set Your Username