yannbrrd/simple_snowflake_mcp

Эта страница переведена автоматически. Технические детали смотрите в оригинале. Открыть оригинал

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

Открыть полный README на GitHub

Установка

uvx simple_snowflake_mcp

Новичок в MCP? Начните с руководства на mcpskill.org →

Конфигурация

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