yannbrrd/simple_snowflake_mcp

このページは AI により自動翻訳されています。技術的な詳細は原文をご確認ください。原文を見る

8 stars 0 forks 品質 61 トレンド 24

A production-ready MCP server that provides seamless Snowflake integration with advanced features including configurable logging, resource subscriptions, and comprehensive error handling.

概要

A production-ready MCP server that provides seamless Snowflake integration with advanced features including configurable logging, resource subscriptions, and comprehensive error handling. Designed to work seamlessly behind corporate proxies. The server exposes the following MCP tools to interact with Snowflake: - : Executes a SQL query on Snowflake and returns the result. Supports json (default), markdown, and csv output via the format argument. - : Executes a SQL query with server-enforced read-only protection. In read-only mode (the default) only SELECT, SHOW, DESCRIBE, EXPLAIN, and WITH statements (without DML) are allowed. Read-only mode is governed and cannot be relaxed by the caller. Supports a limit, an offset for paging, and markdown (default)/json/csv output via format. When a result is truncated the response includes the offset for the next page. - : Returns current Snowflake connection information and server status. - : Lists available Data Warehouses (DWH) on Snowflake.

README

以下は原文 README の抜粋です。原文を見る。

Simple Snowflake MCP server

Enhanced Snowflake MCP Server with comprehensive configuration system and full MCP protocol compliance.

For release details, see CHANGELOG.md.

Tools

The server exposes the following MCP tools to interact with Snowflake:

Database Operations:

execute-snowflake-sql: Executes a SQL query on Snowflake and returns the result. Supports json (default), markdown, and csv output via the format argument.
execute-query: Executes a SQL query with server-enforced read-only protection. In read-only mode (the default) only SELECT, SHOW, DESCRIBE, EXPLAIN, and WITH statements (without DML) are allowed. Read-only mode is governed solely by server configuration and cannot be relaxed by the caller. Supports a limit, an offset for paging, and markdown (default)/json/csv output via format. When a result is truncated the response includes the offset for the next page.

Discovery and Metadata:

get-connection-info: Returns current Snowflake connection information and server status.
list-snowflake-warehouses: Lists available Data Warehouses (DWH) on Snowflake. Pass include_details: false for names only.
list-databases: Lists all accessible Snowflake databases. Supports a pattern filter (wildcards) and include_details.
list-schemas: Lists schemas in a database. Supports a pattern filter (wildcards) and include_details.
list-tables: Lists tables in a database/schema. Supports a pattern filter (wildcards) and include_details.
list-views: Lists views in a database/schema. Supports a pattern filter (wildcards) and include_details.
describe-table: Returns the columns and types of a database/schema/table (works for views too). Supports json (default)/markdown/csv via format.
query-view: Reads rows from a database/schema/view (or table) by name, with the same server-enforced read-only protection and row limiting as execute-query. Supports a limit, an offset for paging, and markdown (default)/json/csv via format.
export-schema: Exports hierarchical schema metadata (databases → schemas → tables/views → columns). Supports json (default), yaml, and sql via format, an optional database filter, and opt-in include_data_samples (table rows only, max 3 rows per table).

Notes (in-memory session state):

add-note: Adds or updates a note (name, content) kept in server memory for the session.
delete-note: Deletes an existing note by name.
list-notes: Lists current note names in sorted order.
get-note: Returns the note payload (name, content) for a given note name.

Prompts

GitHub で README 全文を見る

インストール

uvx simple_snowflake_mcp

MCP 初心者？mcpskill.org のガイドから始めましょう →

設定

"mcpServers": {
    "simple_snowflake_mcp": {
      "command": "uv",
      "args": [
        "--directory",
        ".", 
        "run",
        "simple_snowflake_mcp"
      ]
    }
  }