Interact with Snowflake data warehouse for executing SQL queries, managing tables/databases, and accessing data

Snowflake guMCP Server

Name of the database (e.g., 'SNOWFLAKE', 'MY_DATABASE')

Schema name containing the table (e.g., 'ACCOUNT_USAGE', 'PUBLIC')

Name of the actual table or view (e.g., 'ACCESS_HISTORY', 'USERS')

Name of the warehouse to use. Required if no default warehouse is configured.

describe_table

Column details for the specified table, with each column returned as a separate item

Execute a SQL query (Ensure its valid snowflake sql syntax)

Internal option: Do not display this parameter unless the user explicitly requests it. This is for advanced use cases only and should not be shown or suggested under normal circumstances.

Name of the database to execute query against

Skip OCSP certificate revocation checking entirely. Enable if encountering error 254007 on large result set downloads.

Allow connection when OCSP certificate validation fails. Enable if encountering certificate validation errors with large queries.

Valid Snowflake SQL query to execute (e.g., 'SELECT * FROM table_name LIMIT 10')

Name of the warehouse to use for query execution. Required if no default warehouse is configured.

execute_query

Query execution results. For data retrieval queries, returns rows of data. For data modification queries, returns status information.

COPY options (default: MATCH_BY_COLUMN_NAME=CASE_INSENSITIVE).

Array of records to load. Keys become CSV headers.

Override file format options (e.g., "FIELD_DELIMITER='|' DATE_FORMAT='YYYY-MM-DD'").

Snowflake guMCP Server

Tools

Describe Table

Execute Query

Stage Data

Installation Steps

Create a Gumloop Account

Generate Your Server URL