Snowflake

Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments

VIEWS

2447

USERS

105

VERSION

0.1.0(Updated 12h ago)

2447VIEWS

105USERS

Install MCP Server

Paste and run this command in your terminal to set up Cursor with MCP

npx @composio/cli add cursor --app snowflakenpx @composio/cli add cursor --app snowflakenpx @composio/cli add cursor --app snowflakenpx @composio/cli add cursor --app snowflakenpx @composio/cli add cursor --app snowflake

After running the command, restart Cursor to start using the MCP Server.

View Docs

Available Tools

Cancel Statement Execution

Cancels the execution of a running sql statement. use this action to stop a long-running query.

Execute Sql

Tool to execute a sql statement and return the resulting data. use when you need to query data from snowflake.

Fetch Catalog Integration

Fetches details of a specific catalog integration.

Get Active Scheduled Maintenances

Retrieves a list of any active scheduled maintenances currently in the in progress or verifying state.

Get All Scheduled Maintenances

Retrieves a list of the 50 most recent scheduled maintenances, including those in the completed state.

Get Component Status

Retrieves the status of individual components, each listed with its current status.

Get Status Rollup

Retrieves the status rollup for the entire page, including indicators and human-readable descriptions of the blended component status.

Get Status Summary

Retrieves a summary of the status page, including status indicators, component statuses, unresolved incidents, and upcoming or in-progress scheduled maintenances.

Get Unresolved Incidents

Retrieves a list of any unresolved incidents currently in the investigating, identified, or monitoring state.

Get Upcoming Scheduled Maintenances

Retrieves a list of any upcoming scheduled maintenances still in the scheduled state.

Show Databases

Lists all databases for which you have access privileges. shows database metadata including name, creation date, owner, retention time, and more. can filter results and include dropped databases within time travel retention period.

Show Schemas

Lists all schemas for which you have access privileges. shows schema metadata including name, creation date, owner, database, retention time, and more. can filter results and include dropped schemas within time travel retention period.

Show Tables

Lists all tables for which you have access privileges. shows table metadata including name, creation date, owner, database, schema, row count, size in bytes, clustering keys, and more. can filter results and include dropped tables within time travel retention period.

Check Statement Status

Retrieves the status of a previously submitted sql statement. replace '{statementhandle}' with the unique identifier of the statement.

Submit Sql Statement

Submits a sql statement for execution.

15 actions available