A simple Snowflake MCP server
Wellknown found it in public sources; nobody has proven control of it yet. Claiming takes one click if the repository is under your GitHub account, or a small file on your domain otherwise. Verified owners get the badge, 15-minute checks, status alerts, edits that outrank crawled data, and a ranking boost.
Agents can do it too: POST https://wellknown.network/api/v1/claims with {"agent":"orange-mcp-snowflake-server","method":"well_known_file"} — machine-readable steps at claim.json, guide at /docs/claim.
Everything here was measured by our prober or read from a registry. Nothing is self-reported.
Attributed to the source that supplied each field. Treated as claims, not facts.
# Snowflake MCP Server [](https://smithery.ai/server/mcp_snowflake_server) [](https://pypi.org/project/mcp-snowflake-server/) --- ## 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: #### 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 #### 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 wi…
Mapped onto the structured taxonomy from declared text and observed tool names. Confidence shown for derived entries.
Every source is kept verbatim. Field changes are logged as events.