Snowflake
Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments
This is a first-class FlyMyAI MCP. Agents discover it automatically via tool search and call the actions below on demand - you never wire it up by hand. See the Composio catalog for how discovery works.
Connect
Snowflake connects with a single OAuth click - there is no token to paste. The first time an agent uses a Snowflake action, FlyMyAI asks you to authorize your Snowflake account. Approve it once and the connection is reused for every later run.
- Provider: Snowflake
Actions
Every action this integration exposes. Agents pick the right one from the task; you do not call them by name.
| Action | What it does | Required inputs |
|---|---|---|
SNOWFLAKE_CANCEL_STATEMENT_EXECUTION | Cancels the execution of a running sql statement. use this action to stop a long-running query. | statementHandle |
SNOWFLAKE_EXECUTE_SQL | Tool to execute a sql statement and return the resulting data. use when you need to query data from snowflake. | statement |
SNOWFLAKE_FETCH_CATALOG_INTEGRATION | Fetches details of a specific catalog integration. | name |
SNOWFLAKE_GET_ACTIVE_SCHEDULED_MAINTENANCES | Retrieves a list of any active scheduled maintenances currently in the in progress or verifying state. | - |
SNOWFLAKE_GET_ALL_SCHEDULED_MAINTENANCES | Retrieves a list of the 50 most recent scheduled maintenances, including those in the completed state. | - |
SNOWFLAKE_GET_COMPONENT_STATUS | Retrieves the status of individual components, each listed with its current status. | - |
SNOWFLAKE_GET_STATUS_ROLLUP | Retrieves the status rollup for the entire page, including indicators and human-readable descriptions of the blended component status. | - |
SNOWFLAKE_GET_STATUS_SUMMARY | Retrieves a summary of the status page, including status indicators, component statuses, unresolved incidents, and upcoming or in-progress scheduled maintenances. | - |
SNOWFLAKE_GET_UNRESOLVED_INCIDENTS | Retrieves a list of any unresolved incidents currently in the investigating, identified, or monitoring state. | - |
SNOWFLAKE_GET_UPCOMING_SCHEDULED_MAINTENANCES | Retrieves a list of any upcoming scheduled maintenances still in the scheduled state. | - |
SNOWFLAKE_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. | - |
SNOWFLAKE_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. | - |
SNOWFLAKE_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… | - |
SNOWFLAKE_SNOWFLAKE_CHECK_STATEMENT_STATUS | Retrieves the status of a previously submitted sql statement. replace '(statementhandle)' with the unique identifier of the statement. | statementHandle |
SNOWFLAKE_SUBMIT_SQL_STATEMENT | Submits a sql statement for execution. | statement |
Links
We love our partners - FlyMy.AI builds with the best. Thanks, Snowflake!