# Snowflake MCP - Tools, Setup and Examples | FlyMy.AI > Snowflake MCP for Claude, Cursor and Codex. Analytics, with 15 actions. Your account via OAuth. See setup, examples and pricing. Page: https://flymy.ai/mcp/snowflake/ MCP / Analytics and data # Snowflake MCP: analytics - your account Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments. Connect it to Claude, Codex, Cursor or any MCP client through one FlyMy.AI MCP. [Connect Snowflake](https://flymy.ai/mcp/snowflake/#connect) [What it can do](https://flymy.ai/mcp/snowflake/#actions) Sign in once, 15 actions, Analytics and data $ YOUR NEXT RUN Claude Code, Codex, Cursor, Any agent ## Use Snowflake MCP in your assistant Paste this prompt into Claude Code, Codex, Cursor or any agent. It reads the guide and helps you connect. ``` Read https://flymy.ai/skill.md and https://flymy.ai/mcp/snowflake.md. Help me connect Snowflake MCP to this assistant. Then help me run this task: Use Snowflake to cancel statement execution. Ask me for the required inputs first and show the result. ``` [Open FlyMy.AI](https://app.flymy.ai/new-agent) [Download brief](https://flymy.ai/mcp/snowflake.md) ## What Snowflake MCP can do 15 actions in the FlyMy.AI catalog, the most used first. Your agent finds them through search_tools and calls the one the task needs. | Action | What it does | |---|---| | [#](https://flymy.ai/mcp/snowflake/#method-SNOWFLAKE_CANCEL_STATEMENT_EXECUTION) `SNOWFLAKE_CANCEL_STATEMENT_EXECUTION` | Cancels the execution of a running sql statement. | | [#](https://flymy.ai/mcp/snowflake/#method-SNOWFLAKE_EXECUTE_SQL) `SNOWFLAKE_EXECUTE_SQL` | Execute a sql statement and return the resulting data. | | [#](https://flymy.ai/mcp/snowflake/#method-SNOWFLAKE_FETCH_CATALOG_INTEGRATION) `SNOWFLAKE_FETCH_CATALOG_INTEGRATION` | Fetches details of a specific catalog integration. | | [#](https://flymy.ai/mcp/snowflake/#method-SNOWFLAKE_GET_ACTIVE_SCHEDULED_MAINTENANCES) `SNOWFLAKE_GET_ACTIVE_SCHEDULED_MAINTENANCES` | Retrieves a list of any active scheduled maintenances currently in the in progress or verifying state. | | [#](https://flymy.ai/mcp/snowflake/#method-SNOWFLAKE_GET_ALL_SCHEDULED_MAINTENANCES) `SNOWFLAKE_GET_ALL_SCHEDULED_MAINTENANCES` | Retrieves a list of the 50 most recent scheduled maintenances, including those in the completed state. | | [#](https://flymy.ai/mcp/snowflake/#method-SNOWFLAKE_GET_COMPONENT_STATUS) `SNOWFLAKE_GET_COMPONENT_STATUS` | Retrieves the status of individual components, each listed with its current status. | | [#](https://flymy.ai/mcp/snowflake/#method-SNOWFLAKE_GET_STATUS_ROLLUP) `SNOWFLAKE_GET_STATUS_ROLLUP` | Retrieves the status rollup for the entire page, including indicators and human-readable descriptions of the blended component status. | | [#](https://flymy.ai/mcp/snowflake/#method-SNOWFLAKE_GET_STATUS_SUMMARY) `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. | | [#](https://flymy.ai/mcp/snowflake/#method-SNOWFLAKE_GET_UNRESOLVED_INCIDENTS) `SNOWFLAKE_GET_UNRESOLVED_INCIDENTS` | Retrieves a list of any unresolved incidents currently in the investigating, identified, or monitoring state. | | [#](https://flymy.ai/mcp/snowflake/#method-SNOWFLAKE_GET_UPCOMING_SCHEDULED_MAINTENANCES) `SNOWFLAKE_GET_UPCOMING_SCHEDULED_MAINTENANCES` | Retrieves a list of any upcoming scheduled maintenances still in the scheduled state. | | [#](https://flymy.ai/mcp/snowflake/#method-SNOWFLAKE_SHOW_DATABASES) `SNOWFLAKE_SHOW_DATABASES` | Lists all databases for which you have access privileges. | | [#](https://flymy.ai/mcp/snowflake/#method-SNOWFLAKE_SHOW_SCHEMAS) `SNOWFLAKE_SHOW_SCHEMAS` | Lists all schemas for which you have access privileges. | **Show all 15 actions** | Action | What it does | |---|---| | [#](https://flymy.ai/mcp/snowflake/#method-SNOWFLAKE_SHOW_TABLES) `SNOWFLAKE_SHOW_TABLES` | Lists all tables for which you have access privileges. | | [#](https://flymy.ai/mcp/snowflake/#method-SNOWFLAKE_SNOWFLAKE_CHECK_STATEMENT_STATUS) `SNOWFLAKE_SNOWFLAKE_CHECK_STATEMENT_STATUS` | Retrieves the status of a previously submitted sql statement. | | [#](https://flymy.ai/mcp/snowflake/#method-SNOWFLAKE_SUBMIT_SQL_STATEMENT) `SNOWFLAKE_SUBMIT_SQL_STATEMENT` | Submits a sql statement for execution. | ## Ask your agent Requests to paste as they are. Each one runs on the actions named under it. **“Use Snowflake to cancel statement execution. Ask me for the required inputs first and show the result.”** uses `SNOWFLAKE_CANCEL_STATEMENT_EXECUTION` **“Use Snowflake to execute sql. Ask me for the required inputs first and show the result.”** uses `SNOWFLAKE_EXECUTE_SQL` **“Use Snowflake to fetch catalog integration. Ask me for the required inputs first and show the result.”** uses `SNOWFLAKE_FETCH_CATALOG_INTEGRATION` ## Connect Snowflake in a minute One MCP for every integration. Add it once, then every MCP in the catalog is a request away. 1. 01 ### Add FlyMy.AI Add the FlyMy.AI MCP to your assistant with one of the commands below and sign in. No key to copy. 2. 02 ### Sign in to Snowflake Open the Snowflake [connection settings](https://app.flymy.ai/mcp-configs#snowflake) and sign in once. Your agent then works as your account; the token stays with FlyMy.AI, never in a prompt or a chat. 3. 03 ### Ask Paste a request from this page. Every run shows what it cost. Claude Code ``` claude mcp add --transport http flymyai https://mcp-agents.flymy.ai/mcp ``` Then run /mcp in Claude Code and sign in. Codex ``` codex mcp add flymy --url https://mcp-agents.flymy.ai/mcp ``` Then run codex mcp login flymy to sign in. claude.ai and Claude Desktop ``` https://mcp-agents.flymy.ai/mcp ``` Settings, Connectors, Add custom connector: paste this URL. ## Pay per run FlyMy.AI bills the run: the model and the tool's seconds. Calls go to your own Snowflake account, under its plan and limits. No seats and no minimum. [See usage pricing →](https://flymy.ai/pricing/) ## More Analytics and data MCPs Product analytics, BI dashboards and databases. ### 21Risk 21RISK is a web application that simplifies working with checklists, audits, and actions, facilitating compliance and risk management processes 9 actions / your API key Link: https://flymy.ai/mcp/21risk/ ### AI or Not AI or Not - detect AI-generated/deepfake image, video, audio or text 5 actions / no setup Link: https://flymy.ai/mcp/aiornot/ ### Amplitude Amplitude analytics: event segmentation, funnels, retention, cohorts 51 actions / your API key Link: https://flymy.ai/mcp/amplitude/ ### Baremetrics Baremetrics subscription analytics: sources, MRR/ARR metrics, customers, subscriptions, plans 8 actions / your API key Link: https://flymy.ai/mcp/baremetrics/ ### Baserow Baserow is an open-source database tool that lets teams build no-code data applications, collaborate on records, and integrate with other services for data... 2 actions / your API key Link: https://flymy.ai/mcp/baserow/ ### beaconcha.in Beaconchain is a platform providing real-time data and analytics for the Ethereum 2.0 Beacon Chain, offering insights into validators, blocks, and network... 2 actions / your API key Link: https://flymy.ai/mcp/beaconchain/ ## Go to the source [Snowflake in the docs →](https://docs.flymy.ai/mcp/apps/snowflake), [Snowflake connection settings →](https://app.flymy.ai/mcp-configs#snowflake), [Snowflake website →](https://www.snowflake.com/en/), [Every MCP in the catalog →](https://flymy.ai/mcp/#catalog), [Usage pricing →](https://flymy.ai/pricing/) From the FlyMy.AI platform catalog of 2026-11-03: name, description, actions and setup as the platform lists them. Examples are requests to paste, not recorded runs. --- For agents: the FlyMyAI operating guide (sign up, connect, run models, tools and agents) is https://flymy.ai/skill.md, and https://flymy.ai/llms.txt lists the other pages and the documentation.